# Logfile created on Tue Dec 11 18:30:10 +0800 2007 by logger.rb/1.5.2.9 SQL (0.000000) SET client_min_messages TO 'error' SQL (0.062000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.000000) PGError: ERROR: relation "hot_models" already exists : CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.047000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.015000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-11') LIMIT 1 SQL (0.000000) BEGIN PK and serial sequence (0.000000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-01', '2007-12-11 18:38:41.383000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.016000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.078000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-11') LIMIT 1 SQL (0.015000) BEGIN PK and serial sequence (0.000000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-01', '2007-12-11 18:40:50.930000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.078000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-11') LIMIT 1 SQL (0.000000) BEGIN PK and serial sequence (0.000000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-01', '2007-12-11 18:43:32.524000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.015000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  SQL (0.047000) SET client_min_messages TO 'error' SQL (0.250000) DROP TABLE hot_models SQL (0.359000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.172000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.063000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN PK and serial sequence (0.093000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-02', '2007-12-12 09:48:31.828000') SQL (0.016000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.015000) DROP TABLE hot_models SQL (0.078000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN PK and serial sequence (0.016000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-02', '2007-12-12 09:49:00.921000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.016000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.046000) DROP TABLE hot_models SQL (0.172000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN PK and serial sequence (0.125000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-02', '2007-12-12 09:50:30.968000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.078000) DROP TABLE hot_models SQL (0.047000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.016000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN PK and serial sequence (0.015000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-02', '2007-12-12 09:52:21.500000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.016000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.047000) DROP TABLE hot_models SQL (0.078000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.015000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN PK and serial sequence (0.016000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-02', '2007-12-12 09:55:03.343000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.016000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.047000) DROP TABLE hot_models SQL (0.047000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.016000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN PK and serial sequence (0.015000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-02', '2007-12-12 09:55:31.281000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.000000) DROP TABLE hot_models SQL (0.078000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  HotModel Load (0.015000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> NULL AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN PK and serial sequence (0.000000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.016000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test1', 1, NULL, '2244-07-02', '2007-12-12 10:01:59.843000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.016000) BEGIN HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:01:59.875000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.062000) DROP TABLE hot_models SQL (0.063000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  SQL (0.000000) BEGIN PK and serial sequence (0.015000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:03:40.453000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.016000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> 1 AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN HotModel Update (0.000000) UPDATE hot_models SET "created_at" = '2007-12-12 10:03:40.453000', "name" = 'test', "hotness_level" = 1, "hotness_expired_at" = '2244-07-02', "hotness_at" = NULL WHERE "id" = 1 SQL (0.000000) COMMIT HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) BEGIN HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:03:40.500000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.016000) DROP TABLE hot_models SQL (0.094000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.016000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  SQL (0.000000) BEGIN PK and serial sequence (0.016000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:21:58.312000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) BEGIN HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:21:58.328000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.016000) DROP TABLE hot_models SQL (0.047000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  SQL (0.000000) BEGIN PK and serial sequence (0.000000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:22:34.359000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.015000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> 1 AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN HotModel Update (0.000000) UPDATE hot_models SET "created_at" = '2007-12-12 10:22:34.359000', "name" = 'test', "hotness_level" = 1, "hotness_expired_at" = '2244-07-02', "hotness_at" = NULL WHERE "id" = 1 SQL (0.000000) COMMIT HotModel Load (0.000000) PGError: ERROR: syntax error at or near "hotness_expired_at" LINE 1: ... * FROM hot_models WHERE (hotness_level IN (NULL) hotness_ex... ^ : SELECT * FROM hot_models WHERE (hotness_level IN (NULL) hotness_expired_at > '2007-12-12' ) ORDER BY hotness_level DESC LIMIT 10 HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) BEGIN HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:22:34.406000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.094000) DROP TABLE hot_models SQL (0.047000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  SQL (0.000000) BEGIN PK and serial sequence (0.015000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:26:04.453000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.016000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> 1 AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN HotModel Update (0.000000) UPDATE hot_models SET "created_at" = '2007-12-12 10:26:04.453000', "name" = 'test', "hotness_level" = 1, "hotness_expired_at" = '2244-07-02', "hotness_at" = NULL WHERE "id" = 1 SQL (0.000000) COMMIT HotModel Load (0.000000) PGError: ERROR: syntax error at or near "hotness_expired_at" LINE 1: ...T * FROM hot_models WHERE (hotness_level IN (1,2) hotness_ex... ^ : SELECT * FROM hot_models WHERE (hotness_level IN (1,2) hotness_expired_at > '2007-12-12' ) ORDER BY hotness_level DESC LIMIT 10 HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) BEGIN HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:26:04.500000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.016000) DROP TABLE hot_models SQL (0.125000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.015000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  SQL (0.000000) BEGIN PK and serial sequence (0.032000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:26:28.468000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> 1 AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN HotModel Update (0.000000) UPDATE hot_models SET "created_at" = '2007-12-12 10:26:28.468000', "name" = 'test', "hotness_level" = 1, "hotness_expired_at" = '2244-07-02', "hotness_at" = NULL WHERE "id" = 1 SQL (0.000000) COMMIT HotModel Load (0.031000) SELECT * FROM hot_models WHERE (hotness_level IN (1,2) AND hotness_expired_at > '2007-12-12' ) ORDER BY hotness_level DESC LIMIT 10 HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) BEGIN HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:26:28.546000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) SET client_min_messages TO 'error' SQL (0.047000) DROP TABLE hot_models SQL (0.047000) CREATE TABLE hot_models ("id" serial primary key, "name" character varying(255) DEFAULT NULL, "created_at" timestamp DEFAULT NULL, "hotness_level" integer DEFAULT NULL, "hotness_expired_at" timestamp DEFAULT NULL, "hotness_at" timestamp DEFAULT NULL)  SQL (0.000000)  SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'hot_models'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum  SQL (0.000000) BEGIN PK and serial sequence (0.016000)  SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = 'S' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = 'p' AND dep.refobjid = 'hot_models'::regclass  HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:27:18.109000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.015000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> 1 AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN HotModel Update (0.000000) UPDATE hot_models SET "created_at" = '2007-12-12 10:27:18.109000', "name" = 'test', "hotness_level" = 1, "hotness_expired_at" = '2244-07-02', "hotness_at" = NULL WHERE "id" = 1 SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models WHERE (hotness_level IN (1,2) AND hotness_expired_at > '2007-12-12' ) ORDER BY hotness_level DESC LIMIT 10 HotModel Load (0.000000) SELECT * FROM hot_models WHERE (hotness_level IN (1,2) AND hotness_expired_at > '2007-12-12' ) ORDER BY hotness_level DESC LIMIT 10 HotModel Delete all (0.000000) DELETE FROM hot_models  SQL (0.000000) BEGIN HotModel Create (0.000000) INSERT INTO hot_models ("name", "hotness_level", "hotness_at", "hotness_expired_at", "created_at") VALUES('test', NULL, NULL, NULL, '2007-12-12 10:27:18.156000') SQL (0.000000) SELECT currval('hot_models_id_seq') SQL (0.000000) COMMIT HotModel Load (0.000000) SELECT * FROM hot_models  HotModel Load (0.000000) SELECT * FROM hot_models WHERE ( hotness_level = 2 AND id <> 2 AND hotness_expired_at > '2007-12-12') LIMIT 1 SQL (0.000000) BEGIN HotModel Update (0.000000) UPDATE hot_models SET "created_at" = '2007-12-12 10:27:18.156000', "name" = 'test', "hotness_level" = 2, "hotness_expired_at" = '2717-08-12', "hotness_at" = NULL WHERE "id" = 2 SQL (0.000000) COMMIT HotModel Delete all (0.000000) DELETE FROM hot_models