Skip to content

Instantly share code, notes, and snippets.

@jeremywadsack

jeremywadsack/rails_3.2.19

Created November 25, 2014 23:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeremywadsack/8f3e95f4e26194686d7e to your computer and use it in GitHub Desktop.
Save jeremywadsack/8f3e95f4e26194686d7e to your computer and use it in GitHub Desktop.
Download ZIP
Postgres logs from rspec run under rails 3.2.19 and 4.1.8
Raw
rails_3.2.19
[unknown]LOG: connection received: host=::1 port=58397
my-app-test LOG: connection authorized: user=jeremywadsack database=my-app-test
my-app-test LOG: statement: set client_encoding to 'UTF8'
my-app-test LOG: statement: set client_encoding to 'utf8'
my-app-test LOG: statement: SET client_min_messages TO 'WARNING'
my-app-test LOG: statement: SHOW client_min_messages
my-app-test LOG: statement: SET client_min_messages TO 'panic'
my-app-test LOG: statement: SET standard_conforming_strings = on
my-app-test LOG: statement: SET client_min_messages TO 'warning'
my-app-test LOG: statement: SET time zone 'UTC'
my-app-test LOG: statement: SHOW TIME ZONE
my-app-test LOG: statement: SELECT 1
my-app-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'site_daily_processings'
AND n.nspname = ANY (current_schemas(false))
my-app-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"site_daily_processings"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
my-app-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"site_daily_processings"'::regclass
my-app-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"sources"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
my-app-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'sources'
AND n.nspname = ANY (current_schemas(false))
my-app-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"sources"'::regclass
my-app-test LOG: statement: BEGIN
my-app-test LOG: statement: SHOW search_path
my-app-test LOG: execute a1: INSERT INTO "sources" ("search", "val") VALUES ($1, $2) RETURNING "id"
my-app-test DETAIL: parameters: $1 = 't', $2 = 'search'
my-app-test LOG: statement: COMMIT
my-app-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"media"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
my-app-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'media'
AND n.nspname = ANY (current_schemas(false))
my-app-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"media"'::regclass
my-app-test LOG: statement: BEGIN
my-app-test LOG: execute a2: INSERT INTO "media" ("val") VALUES ($1) RETURNING "id"
my-app-test DETAIL: parameters: $1 = 'organic'
my-app-test LOG: statement: COMMIT
[unknown]LOG: connection received: host=::1 port=58398
shared-test LOG: connection authorized: user=jeremywadsack database=shared-test
shared-test LOG: statement: set client_encoding to 'UTF8'
shared-test LOG: statement: set client_encoding to 'utf8'
shared-test LOG: statement: SET client_min_messages TO 'WARNING'
shared-test LOG: statement: SHOW client_min_messages
shared-test LOG: statement: SET client_min_messages TO 'panic'
shared-test LOG: statement: SET standard_conforming_strings = on
shared-test LOG: statement: SET client_min_messages TO 'warning'
shared-test LOG: statement: SET time zone 'UTC'
shared-test LOG: statement: SHOW TIME ZONE
shared-test LOG: statement: SELECT 1
my-app-test LOG: statement: BEGIN
shared-test LOG: statement: BEGIN
shared-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"groups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
shared-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'groups'
AND n.nspname = ANY (current_schemas(false))
shared-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"groups"'::regclass
shared-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"clients"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
shared-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'clients'
AND n.nspname = ANY (current_schemas(false))
shared-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"clients"'::regclass
shared-test LOG: statement: SAVEPOINT active_record_1
shared-test LOG: statement: SHOW search_path
shared-test LOG: execute a1: INSERT INTO "clients" ("app_version", "blueprint_active", "consulting", "created_at", "email", "main_contact", "name", "stage", "switched_to_trial_date", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) RETURNING "id"
shared-test DETAIL: parameters: $1 = 'complete', $2 = 't', $3 = 'f', $4 = '2014-11-25 22:40:31.563635', $5 = NULL, $6 = NULL, $7 = 'client 1', $8 = NULL, $9 = NULL, $10 = '2014-11-25 22:40:31.563635'
shared-test LOG: statement: RELEASE SAVEPOINT active_record_1
shared-test LOG: statement: SAVEPOINT active_record_1
shared-test LOG: execute <unnamed>: SELECT "groups".* FROM "groups" WHERE ("slug" = 'the-group' OR "slug" LIKE 'the-group--%') ORDER BY LENGTH("slug") DESC, "slug" DESC LIMIT 1
shared-test LOG: execute a2: INSERT INTO "groups" ("client_id", "created_at", "match_subdomains", "name", "projection_method", "segment_limit", "slug", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "id"
shared-test DETAIL: parameters: $1 = '1', $2 = '2014-11-25 22:40:31.649915', $3 = 't', $4 = 'the group', $5 = NULL, $6 = '5', $7 = 'the-group', $8 = '2014-11-25 22:40:31.649915'
shared-test LOG: statement: RELEASE SAVEPOINT active_record_1
my-app-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"my_sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
my-app-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'my_sites'
AND n.nspname = ANY (current_schemas(false))
my-app-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"my_sites"'::regclass
my-app-test LOG: statement: SAVEPOINT active_record_1
my-app-test LOG: execute <unnamed>: SELECT "my_sites".* FROM "my_sites" WHERE ("slug" = 'www-example-com' OR "slug" LIKE 'www-example-com--%') ORDER BY LENGTH("slug") DESC, "slug" DESC LIMIT 1
my-app-test LOG: execute <unnamed>: SELECT 1 AS one FROM "my_sites" WHERE "my_sites"."url" = 'www.example.com' LIMIT 1
my-app-test LOG: execute a3: INSERT INTO "my_sites" ("active", "created_at", "ga_account_id", "ga_property_id", "last_authorized_date", "slug", "updated_at", "url", "view") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"
my-app-test DETAIL: parameters: $1 = 't', $2 = '2014-11-25 22:40:31.670129', $3 = NULL, $4 = NULL, $5 = '2014-11-25', $6 = 'www-example-com', $7 = '2014-11-25 22:40:31.670129', $8 = 'www.example.com', $9 = NULL
my-app-test LOG: statement: RELEASE SAVEPOINT active_record_1
my-app-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"my_groups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
my-app-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'my_groups'
AND n.nspname = ANY (current_schemas(false))
my-app-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"my_groups"'::regclass
my-app-test LOG: statement: SAVEPOINT active_record_1
my-app-test LOG: execute <unnamed>: SELECT "my_groups".* FROM "my_groups" WHERE ("slug" = 'the-group' OR "slug" LIKE 'the-group--%') ORDER BY LENGTH("slug") DESC, "slug" DESC LIMIT 1
my-app-test LOG: execute <unnamed>: SELECT 1 AS one FROM "my_groups" WHERE "my_groups"."name" = 'the group' LIMIT 1
my-app-test LOG: execute a4: INSERT INTO "my_groups" ("created_at", "name", "slug", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id"
my-app-test DETAIL: parameters: $1 = '2014-11-25 22:40:31.682863', $2 = 'the group', $3 = 'the-group', $4 = '2014-11-25 22:40:31.682863'
my-app-test LOG: statement: RELEASE SAVEPOINT active_record_1
shared-test LOG: execute <unnamed>: SELECT "groups".* FROM "groups" WHERE "groups"."slug" = '1' LIMIT 1
shared-test LOG: execute a3: SELECT "groups".* FROM "groups" WHERE "groups"."id" = $1 LIMIT 1
shared-test DETAIL: parameters: $1 = '1'
my-app-test LOG: execute <unnamed>: SELECT "my_groups".* FROM "my_groups" WHERE "my_groups"."slug" = 'the-group' LIMIT 1
my-app-test LOG: execute <unnamed>: SELECT "my_groups".* FROM "my_groups" WHERE "my_groups"."slug" = 'the-group' LIMIT 1
shared-test LOG: execute <unnamed>: SELECT "groups".* FROM "groups" WHERE "groups"."slug" = 'the-group' LIMIT 1
shared-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"patterns"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
shared-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'patterns'
AND n.nspname = ANY (current_schemas(false))
shared-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"patterns"'::regclass
shared-test LOG: execute <unnamed>: SELECT "patterns".* FROM "patterns" WHERE "patterns"."site_group_id" = 1
shared-test LOG: execute <unnamed>: SELECT "patterns".* FROM "patterns" WHERE "patterns"."site_group_id" = 1 AND "patterns"."category" = 'Example' LIMIT 1
my-app-test LOG: statement: ROLLBACK
shared-test LOG: statement: ROLLBACK
my-app-test LOG: statement: SELECT 1
my-app-test LOG: execute <unnamed>: DELETE FROM "sources"
my-app-test LOG: execute <unnamed>: DELETE FROM "media"
Raw
rails_4.1.8
[unknown]LOG: connection received: host=::1 port=58383
my-app-test LOG: connection authorized: user=jeremywadsack database=my-app-test
my-app-test LOG: statement: set client_encoding to 'UTF8'
my-app-test LOG: statement: set client_encoding to 'utf8'
my-app-test LOG: statement: SET client_min_messages TO 'WARNING'
my-app-test LOG: statement: SHOW client_min_messages
my-app-test LOG: statement: SET client_min_messages TO 'panic'
my-app-test LOG: statement: SET standard_conforming_strings = on
my-app-test LOG: statement: SET client_min_messages TO 'warning'
my-app-test LOG: statement: SET time zone 'UTC'
my-app-test LOG: statement: SELECT oid, typname, typelem, typdelim, typinput FROM pg_type
my-app-test LOG: statement: SHOW TIME ZONE
my-app-test LOG: statement: SELECT 1
my-app-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"sources"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
my-app-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'sources'
AND n.nspname = ANY (current_schemas(false))
my-app-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"sources"'::regclass
my-app-test LOG: statement: BEGIN
my-app-test LOG: statement: SHOW search_path
my-app-test LOG: execute a1: INSERT INTO "sources" ("search", "val") VALUES ($1, $2) RETURNING "id"
my-app-test DETAIL: parameters: $1 = 't', $2 = 'search'
my-app-test LOG: statement: COMMIT
my-app-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"media"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
my-app-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'media'
AND n.nspname = ANY (current_schemas(false))
my-app-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"media"'::regclass
my-app-test LOG: statement: BEGIN
my-app-test LOG: execute a2: INSERT INTO "media" ("val") VALUES ($1) RETURNING "id"
my-app-test DETAIL: parameters: $1 = 'organic'
my-app-test LOG: statement: COMMIT
my-app-test LOG: statement: BEGIN
[unknown]LOG: connection received: host=::1 port=58384
shared-test LOG: connection authorized: user=jeremywadsack database=shared-test
shared-test LOG: statement: set client_encoding to 'UTF8'
shared-test LOG: statement: set client_encoding to 'utf8'
shared-test LOG: statement: SET client_min_messages TO 'WARNING'
shared-test LOG: statement: SHOW client_min_messages
shared-test LOG: statement: SET client_min_messages TO 'panic'
shared-test LOG: statement: SET standard_conforming_strings = on
shared-test LOG: statement: SET client_min_messages TO 'warning'
shared-test LOG: statement: SET time zone 'UTC'
shared-test LOG: statement: SELECT oid, typname, typelem, typdelim, typinput FROM pg_type
shared-test LOG: statement: SHOW TIME ZONE
shared-test LOG: statement: SELECT 1
shared-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"groups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
shared-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'groups'
AND n.nspname = ANY (current_schemas(false))
shared-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"groups"'::regclass
shared-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"clients"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
shared-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'clients'
AND n.nspname = ANY (current_schemas(false))
shared-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"clients"'::regclass
shared-test LOG: statement: BEGIN
shared-test LOG: statement: SHOW search_path
shared-test LOG: execute a1: INSERT INTO "clients" ("created_at", "name", "updated_at") VALUES ($1, $2, $3) RETURNING "id"
shared-test DETAIL: parameters: $1 = '2014-11-25 22:37:28.136107', $2 = 'client 1', $3 = '2014-11-25 22:37:28.136107'
shared-test LOG: statement: COMMIT
shared-test LOG: statement: BEGIN
shared-test LOG: execute <unnamed>: SELECT 1 AS one FROM "groups" WHERE "groups"."id" IS NOT NULL AND "groups"."slug" = 'the-group' LIMIT 1
shared-test LOG: execute a2: INSERT INTO "groups" ("client_id", "created_at", "name", "slug", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"
shared-test DETAIL: parameters: $1 = '1', $2 = '2014-11-25 22:37:28.248017', $3 = 'the group', $4 = 'the-group', $5 = '2014-11-25 22:37:28.248017'
shared-test LOG: statement: COMMIT
my-app-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"my_sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
my-app-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'my_sites'
AND n.nspname = ANY (current_schemas(false))
my-app-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"my_sites"'::regclass
my-app-test LOG: statement: SAVEPOINT active_record_1
my-app-test LOG: execute <unnamed>: SELECT 1 AS one FROM "my_sites" WHERE "my_sites"."id" IS NOT NULL AND "my_sites"."slug" = 'www-example-com' LIMIT 1
my-app-test LOG: execute <unnamed>: SELECT 1 AS one FROM "my_sites" WHERE "my_sites"."url" = 'www.example.com' LIMIT 1
my-app-test LOG: execute a3: INSERT INTO "my_sites" ("created_at", "last_authorized_date", "slug", "updated_at", "url") VALUES ($1, $2, $3, $4, $5) RETURNING "id"
my-app-test DETAIL: parameters: $1 = '2014-11-25 22:37:28.270924', $2 = '2014-11-25', $3 = 'www-example-com', $4 = '2014-11-25 22:37:28.270924', $5 = 'www.example.com'
my-app-test LOG: statement: RELEASE SAVEPOINT active_record_1
my-app-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"my_groups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
my-app-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'my_groups'
AND n.nspname = ANY (current_schemas(false))
my-app-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"my_groups"'::regclass
my-app-test LOG: statement: SAVEPOINT active_record_1
my-app-test LOG: execute <unnamed>: SELECT 1 AS one FROM "my_groups" WHERE "my_groups"."id" IS NOT NULL AND "my_groups"."slug" = 'the-group' LIMIT 1
my-app-test LOG: execute <unnamed>: SELECT 1 AS one FROM "my_groups" WHERE "my_groups"."name" = 'the group' LIMIT 1
my-app-test LOG: execute a4: INSERT INTO "my_groups" ("created_at", "name", "slug", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id"
my-app-test DETAIL: parameters: $1 = '2014-11-25 22:37:28.280183', $2 = 'the group', $3 = 'the-group', $4 = '2014-11-25 22:37:28.280183'
my-app-test LOG: statement: RELEASE SAVEPOINT active_record_1
shared-test LOG: execute <unnamed>: SELECT "groups".* FROM "groups" WHERE "groups"."slug" = '1' ORDER BY "groups"."id" ASC LIMIT 1
shared-test LOG: execute a3: SELECT "groups".* FROM "groups" WHERE "groups"."id" = $1 LIMIT 1
shared-test DETAIL: parameters: $1 = '1'
my-app-test LOG: execute <unnamed>: SELECT "my_groups".* FROM "my_groups" WHERE "my_groups"."slug" = 'the-group' ORDER BY "my_groups"."id" ASC LIMIT 1
my-app-test LOG: execute <unnamed>: SELECT "my_groups".* FROM "my_groups" WHERE "my_groups"."slug" = 'the-group' ORDER BY "my_groups"."id" ASC LIMIT 1
shared-test LOG: execute <unnamed>: SELECT "groups".* FROM "groups" WHERE "groups"."slug" = 'the-group' ORDER BY "groups"."id" ASC LIMIT 1
shared-test LOG: execute <unnamed>: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"patterns"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
shared-test LOG: execute a4: SELECT "patterns".* FROM "patterns" WHERE "patterns"."site_group_id" = $1
shared-test DETAIL: parameters: $1 = '1'
shared-test LOG: execute <unnamed>: SELECT COUNT(*)
FROM pg_class c
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind in ('v','r')
AND c.relname = 'patterns'
AND n.nspname = ANY (current_schemas(false))
shared-test LOG: execute <unnamed>: SELECT attr.attname
FROM pg_attribute attr
INNER JOIN pg_constraint cons ON attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1]
WHERE cons.contype = 'p'
AND cons.conrelid = '"patterns"'::regclass
shared-test LOG: execute a5: SELECT "patterns".* FROM "patterns" WHERE "patterns"."site_group_id" = $1 AND "patterns"."category" = 'Example' ORDER BY "patterns"."id" ASC LIMIT 1
shared-test DETAIL: parameters: $1 = '1'
my-app-test LOG: statement: ROLLBACK
my-app-test LOG: statement: SELECT 1
my-app-test LOG: execute <unnamed>: DELETE FROM "sources"
my-app-test LOG: execute <unnamed>: DELETE FROM "media"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment