Skip to content

Instantly share code, notes, and snippets.

@spif

spif/gist:829273

Created February 16, 2011 12:04
Show Gist options
  • Save spif/829273 to your computer and use it in GitHub Desktop.
Save spif/829273 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1
Started POST "/invites" for 127.0.0.1 at Wed Feb 16 13:03:05 +0100 2011
Processing by InvitesController#create as HTML
Parameters: {"commit"=>"Send invite", "from"=>"Stefan Fountain <stefan@soocial.com>", "authenticity_token"=>"/wF5G2sSjAhQ7A019hf+Wy7rr/mpwbGpdNQt3PlT2gE=", "utf8"=>"✓", "subject"=>"Check soocial.com out", "to"=>"Bitch <bart+456789@soocial.com>", "message"=>"Check soocial.com out, it's awesome"}
PK and serial sequence (2.0ms) SELECT attr.attname, 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.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 = '"voucher_users"'::regclass
PK and custom sequence (1.1ms) SELECT attr.attname,
CASE
WHEN split_part(def.adsrc, '''', 2) ~ '.' THEN
substr(split_part(def.adsrc, '''', 2),
strpos(split_part(def.adsrc, '''', 2), '.')+1)
ELSE split_part(def.adsrc, '''', 2)
END
FROM pg_class t
JOIN pg_attribute attr ON (t.oid = attrelid)
JOIN pg_attrdef def ON (adrelid = attrelid AND adnum = attnum)
JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1])
WHERE t.oid = '"voucher_users"'::regclass
AND cons.contype = 'p'
AND def.adsrc ~* 'nextval'
SQL (2.0ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
WARNING: Can't mass-assign protected attributes: confirmed
User Load (0.5ms) SELECT "users".* FROM "users" WHERE (lower(username) = 'bart+456789@soocial.com') LIMIT 1
*** success: true, existing: nil, is_me: false
SQL (0.6ms) 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 = '"plans"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.5ms) 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 = '"plans"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Plan Load (0.5ms) SELECT "plans".* FROM "plans" WHERE "plans"."name" = 'Free' LIMIT 1
SQL (1.2ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
PK and serial sequence (2.3ms) SELECT attr.attname, 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.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 = '"users"'::regclass
SQL (306.6ms) INSERT INTO "users" ("allow_tip_emails", "updated_at", "me_status", "webapp_count_calculated", "connection_count", "clear", "created_at", "plan_valid_until", "last_device_sync_at", "allow_invite_emails", "plan_id", "referral", "last_login_at", "contact_count", "psp_reference", "username", "last_engine_sync_at", "trial_used", "vcard", "timezone", "allow_newsletters", "username_password_hash", "subscription_type", "deleted", "locked", "first_login", "confirmed", "name") VALUES ('f', '2011-02-16 12:03:06.298770', 1, 't', 0, 0, '2011-02-16 12:03:06.298770', NULL, NULL, 't', 2, NULL, NULL, 0, NULL, 'bart+456789@soocial.com', NULL, NULL, NULL, 'UTC', 't', '2R1+TVEzWUqdmGMV9XyApA==', NULL, 'f', 0, 't', 'f', 'Bitch') RETURNING "id"
SQL (1.0ms) 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 = '"contacts"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.9ms) 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 = '"contacts"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
PK and serial sequence (1.8ms) SELECT attr.attname, 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.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 = '"contacts"'::regclass
SQL (1.7ms) INSERT INTO "contacts" ("updated_at", "g_signature", "me", "in_transit", "deleted", "deleted_at", "relationship_id", "g_name_for_sorting", "vcard", "created_by", "generation", "latest", "user_id", "created_at", "g_three_chars", "parents") VALUES ('2011-02-16 12:03:06.805216', xml '<sign><fn>Bitch</fn><name_given>Bitch</name_given><email>bart+456789@soocial.com</email></sign>', 't', 'f', 'f', NULL, NULL, ' - Bitch', 'BEGIN:VCARD
N:;Bitch;;;
VERSION:3.0
EMAIL:bart+456789@soocial.com
FN:Bitch
END:VCARD
', 'analytics@spif.local/', 0, 't', 14, '2011-02-16 12:03:06.805216', 'Bit', NULL) RETURNING "id"
Contact Load (0.6ms) SELECT "contacts".* FROM "contacts" WHERE "contacts"."id" = 474 LIMIT 1
SQL (0.7ms) 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 = '"devices"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
User Load (0.5ms) SELECT "users".* FROM "users" WHERE (lower(username) = 'bart+456789@soocial.com') LIMIT 1
*** success: true, existing: #<User id: 14, username: "bart+456789@soocial.com", username_password_hash: "2R1+TVEzWUqdmGMV9XyApA==", created_at: "2011-02-16 12:03:06", updated_at: "2011-02-16 12:03:06", confirmed: false, name: "Bitch", first_login: true, allow_newsletters: true, timezone: "UTC", deleted: false, vcard: nil, me_status: 1, allow_invite_emails: true, contact_count: 1, connection_count: 0, plan_id: 2, plan_valid_until: nil, locked: 0, psp_reference: nil, subscription_type: nil, webapp_count_calculated: true, referral: nil, last_login_at: nil, last_engine_sync_at: nil, last_device_sync_at: nil, allow_tip_emails: false, clear: 0, trial_used: nil>, is_me: true
AREL (0.8ms) UPDATE "users" SET "updated_at" = '2011-02-16 12:03:06.298770', "created_at" = '2011-02-16 12:03:06.298770', "plan_id" = 2, "username" = 'bart+456789@soocial.com', "vcard" = 'BEGIN:VCARD
N:;Bitch;;;
VERSION:3.0
EMAIL:bart+456789@soocial.com
FN:Bitch
END:VCARD
', "username_password_hash" = '2R1+TVEzWUqdmGMV9XyApA==', "name" = 'Bitch' WHERE "users"."id" = 14
User Load (0.5ms) SELECT "users".* FROM "users" WHERE (lower(username) = 'bart+456789@soocial.com') LIMIT 1
*** success: true, existing: #<User id: 14, username: "bart+456789@soocial.com", username_password_hash: "2R1+TVEzWUqdmGMV9XyApA==", created_at: "2011-02-16 12:03:06", updated_at: "2011-02-16 12:03:06", confirmed: false, name: "Bitch", first_login: true, allow_newsletters: true, timezone: "UTC", deleted: false, vcard: "BEGIN:VCARD\nN:;Bitch;;;\nVERSION:3.0\nEMAIL:bart+4567...", me_status: 1, allow_invite_emails: true, contact_count: 1, connection_count: 0, plan_id: 2, plan_valid_until: nil, locked: 0, psp_reference: nil, subscription_type: nil, webapp_count_calculated: true, referral: nil, last_login_at: nil, last_engine_sync_at: nil, last_device_sync_at: nil, allow_tip_emails: false, clear: 0, trial_used: nil>, is_me: true
AREL (0.7ms) UPDATE "users" SET "updated_at" = '2011-02-16 12:03:06.839282', "me_status" = 2 WHERE "users"."id" = 14
SQL (0.8ms) 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 = '"tokens"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.5ms) 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 = '"tokens"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
VipInviteKey Load (0.2ms) SELECT "tokens".* FROM "tokens" WHERE "tokens"."type" = 'VipInviteKey' AND ("tokens".user_id = 14) LIMIT 1
SQL (0.6ms) 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 = '"tokens"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.5ms) 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 = '"tokens"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Token Load (0.2ms) SELECT "tokens"."id" FROM "tokens" WHERE ("tokens"."value" = '9551ea2e26222e0620cf4ebb5f32a99a5f4fd87359c1bee2') LIMIT 1
PK and serial sequence (1.8ms) SELECT attr.attname, 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.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 = '"tokens"'::regclass
SQL (0.6ms) INSERT INTO "tokens" ("created_at", "type", "sent_at", "updated_at", "value", "user_id") VALUES ('2011-02-16 12:03:06.860275', 'VipInviteKey', NULL, '2011-02-16 12:03:06.860275', '9551ea2e26222e0620cf4ebb5f32a99a5f4fd87359c1bee2', 14) RETURNING "id"
User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = 14 LIMIT 1
VipInviteKey Load (0.3ms) SELECT "tokens".* FROM "tokens" WHERE "tokens"."type" = 'VipInviteKey' AND ("tokens".user_id = 14) LIMIT 1
Rendered mailer/vip_invite.html.erb (0.8ms)
Rendered mailer/vip_invite.text.erb (0.4ms)
SQL (0.8ms) 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 = '"email_logs"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.7ms) 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 = '"email_logs"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
PK and serial sequence (1.8ms) SELECT attr.attname, 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.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 = '"email_logs"'::regclass
SQL (0.7ms) INSERT INTO "email_logs" ("updated_at", "name", "created_at", "user_id") VALUES ('2011-02-16 12:03:06.949508', 'VIP Invite', '2011-02-16 12:03:06.949508', 14) RETURNING "id"
Sent mail to bart+456789@soocial.com (146ms)
Date: Wed, 16 Feb 2011 13:03:06 +0100
From: Stefan Fountain <stefan@soocial.com>
To: bart+456789@soocial.com
Message-ID: <4d5bbcfaeb3c6_71c0825222cc30f8@spif.local.mail>
Subject: Check soocial.com out
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="--==_mimepart_4d5bbcfae22f8_71c0825222cc271";
charset=UTF-8
Content-Transfer-Encoding: 7bit
List-Unsubscribe: <https://bleeding.soocial.com/user/blacklist?email=bart+456789@soocial.com>
X-SMTPAPI: {"category": "VIP invite"}
----==_mimepart_4d5bbcfae22f8_71c0825222cc271
Date: Wed, 16 Feb 2011 13:03:06 +0100
Mime-Version: 1.0
Content-Type: text/plain;
charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-ID: <4d5bbcfae99ce_71c0825222cc28ae@spif.local.mail>
Hi there,
Check soocial.com out, it's awesome
You've been sent an invite by Stefan Fountain to use Soocial premium. We're
giving you access to a Soocial account with the limitations of the free
account.
Click the following link to confirm your account and choose a password:
https://bleeding.soocial.com/vip-invite?utm_source=soocial&utm_medium=email&utm_campaign=vip_invite&key=9551ea2e26222e0620cf4ebb5f32a99a5f4fd87359c1bee2
------------------------------------------
Soocial never uses your contact details without your permission.
This email was sent to personally by .
If you need help visit Soocial support: https://bleeding.soocial.com/support?utm_source=soocial&amp;utm_medium=email&amp;utm_campaign=vip_invite
----==_mimepart_4d5bbcfae22f8_71c0825222cc271
Date: Wed, 16 Feb 2011 13:03:06 +0100
Mime-Version: 1.0
Content-Type: text/html;
charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-ID: <4d5bbcfaea7ed_71c0825222cc292a@spif.local.mail>
<html>
<body>
<div style="width:560px;margin: 0 auto;max-width:560px;font: 13px 'Lucida Grande', Lucida Grande, Helvetica, Arial, sans-serif;line-height: 18px; border: 4px solid #e6e6e6; padding:0px;-moz-border-radius:10px;-webkit-border-radius:10px;">
<table border="0" cellpadding="0" cellspacing="0" style="width:100%; background: #fff;font: 13px 'Lucida Grande', Lucida Grande, Helvetica, Arial, sans-serif; padding:20px 30px; -moz-border-radius:7px;-webkit-border-radius:7px;">
<tr>
<td>
<h1 style="color: #000; font: bold 23px lucida grande; margin:5px 0;"><img src="https://bleeding.soocial.com/images/logo_mail_header.gif" height="55px"></h1>
<div style="font: 13px 'Lucida Grande', Lucida Grande, Helvetica, Arial, sans-serif; width:480px; margin: 10px 0; color: #000;">
<p style="font: 13px 'Lucida Grande', Lucida Grande, Helvetica, Arial, sans-serif; width:480px; margin: 10px 0; color: #000;">Check soocial.com out, it's awesome</p>
<a style="width:200px; height:30px; font: 14px 'Lucida Grande', Lucida Grande, Helvetica, Arial, sans-serif;background: #b7cd34 url('https://bleeding.soocial.com/images/mail_button_bg.gif') repeat center center; display:block; border: 2px solid #7d8c07; text-decoration: none; color: #000; text-align: center; white-space:none; font-weight: bold; -moz-border-radius:4px; -webkit-border-radius:4px;line-height:30px; margin-top:20px;" href="https://bleeding.soocial.com/vip-invite?utm_source=soocial&amp;utm_medium=email&amp;utm_campaign=vip_invite&amp;key=9551ea2e26222e0620cf4ebb5f32a99a5f4fd87359c1bee2">View invite</a>
<div style="margin-top: 5px; border-bottom: 1px solid #ddd; line-height:2px">&nbsp;</div>
<p style="width: 490px; margin: 10px 0; font: 10px 'Lucida Grande', Lucida Grande, Helvetica, Arial, sans-serif; color: #999;"> Soocial never uses your contact details without your permission. This email was sent to . If you need help visit <a href="https://bleeding.soocial.com/support?utm_source=soocial&amp;utm_medium=email&amp;utm_campaign=vip_invite">Soocial support</a>.
</p>
</div>
</td>
</tr>
</table>
</div>
</body>
</html>
----==_mimepart_4d5bbcfae22f8_71c0825222cc271--
AREL (0.8ms) UPDATE "tokens" SET "sent_at" = '2011-02-16 12:03:07.100625', "updated_at" = '2011-02-16 12:03:07.100938' WHERE "tokens"."type" = 'VipInviteKey' AND "tokens"."id" = 5
Redirected to http://localhost:3000/users/14
Completed 302 Found in 1312ms
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DestroyUserJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DedupeJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DeviceSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DestroyExternalContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeGmailSetupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FillDeviceMappingsJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ContactCleaner
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant PremiumDeviceSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant EmailNewsletterJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant UpdateFollowerContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant SaveExternalContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RenameCategoryJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ConnectedFriendsSyncGenerator
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant SpecificDedupeJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DeviceJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant BumpedDeviceSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RecoveryJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RestoreSnapshotJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant BlackListed
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ExternalContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeDeviceSetupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ResqueJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RecoveryFromBackupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant SyncGenerator
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant BumpedSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeYahooSetupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FillCategoriesJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FillCountsJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RemoveCategoryJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant MingleJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeWindowsLiveSetupJob
Started GET "/users/14" for 127.0.0.1 at Wed Feb 16 13:03:07 +0100 2011
Processing by UsersController#show as HTML
Parameters: {"id"=>"14"}
PK and serial sequence (2.3ms) SELECT attr.attname, 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.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 = '"voucher_users"'::regclass
PK and custom sequence (1.1ms) SELECT attr.attname,
CASE
WHEN split_part(def.adsrc, '''', 2) ~ '.' THEN
substr(split_part(def.adsrc, '''', 2),
strpos(split_part(def.adsrc, '''', 2), '.')+1)
ELSE split_part(def.adsrc, '''', 2)
END
FROM pg_class t
JOIN pg_attribute attr ON (t.oid = attrelid)
JOIN pg_attrdef def ON (adrelid = attrelid AND adnum = attnum)
JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1])
WHERE t.oid = '"voucher_users"'::regclass
AND cons.contype = 'p'
AND def.adsrc ~* 'nextval'
SQL (0.9ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 14 LIMIT 1
SQL (0.7ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Category Load (0.4ms) SELECT "categories".* FROM "categories" WHERE ("categories".user_id = 14)
Device Load (0.3ms) SELECT "devices".* FROM "devices" WHERE ("devices".user_id = 14)
SQL (0.7ms) 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 = '"devices"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Device Load (0.3ms) SELECT "devices".* FROM "devices" WHERE ("devices".user_id = 14 AND ("devices"."type" IN ('Device::WindowsLive', 'Device::Yahoo', 'Device::GMail')))
SQL (0.5ms) 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 = '"plans"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Plan Load (0.3ms) SELECT "plans".* FROM "plans" WHERE ("plans"."id" = 2)
SQL (0.9ms) 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 = '"contacts"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Contact Load (0.3ms) SELECT "contacts".* FROM "contacts" WHERE ("contacts".user_id = 14 AND ("contacts"."me" = 't'))
SQL (0.6ms) 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 = '"contacts"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.9ms) 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 = '"email_blacklists"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.6ms) 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 = '"email_blacklists"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
EmailBlacklist Load (0.3ms) SELECT "email_blacklists".* FROM "email_blacklists" WHERE "email_blacklists"."address" = 'bart+456789@soocial.com' LIMIT 1
DEPRECATION WARNING: <% %> style block helpers are deprecated. Please use <%= %>. (called from _app_views_users_show_html_erb___1710862944_2188282740_0 at /Users/spif/repos/soocial/analytics/app/views/users/show.html.erb:106)
SQL (0.8ms) 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 = '"categories"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) SELECT COUNT(*) FROM "categories" WHERE ("categories".user_id = 14)
SQL (0.6ms) 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 = '"backups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) SELECT COUNT(*) FROM "backups" WHERE ("backups".user_id = 14)
SQL (0.8ms) 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 = '"relationships"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) SELECT COUNT(*) FROM "relationships" WHERE ("relationships".origin_id = 14)
SQL (0.2ms) SELECT COUNT(*) FROM "relationships" WHERE ("relationships".follower_id = 14)
Rendered users/show.html.erb within layouts/application (40.8ms)
Completed 200 OK in 804ms (Views: 91.2ms | ActiveRecord: 14.5ms)
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DestroyUserJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DedupeJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DeviceSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DestroyExternalContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeGmailSetupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FillDeviceMappingsJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ContactCleaner
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant PremiumDeviceSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant EmailNewsletterJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant UpdateFollowerContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant SaveExternalContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RenameCategoryJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ConnectedFriendsSyncGenerator
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant SpecificDedupeJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DeviceJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant BumpedDeviceSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RecoveryJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RestoreSnapshotJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant BlackListed
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ExternalContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeDeviceSetupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ResqueJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RecoveryFromBackupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant SyncGenerator
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant BumpedSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeYahooSetupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FillCategoriesJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FillCountsJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RemoveCategoryJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant MingleJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeWindowsLiveSetupJob
Started POST "/users/14" for 127.0.0.1 at Wed Feb 16 13:03:10 +0100 2011
Processing by UsersController#update as HTML
Parameters: {"commit"=>"Give Lifetime", "id"=>"14"}
PK and serial sequence (2.4ms) SELECT attr.attname, 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.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 = '"voucher_users"'::regclass
PK and custom sequence (4.4ms) SELECT attr.attname,
CASE
WHEN split_part(def.adsrc, '''', 2) ~ '.' THEN
substr(split_part(def.adsrc, '''', 2),
strpos(split_part(def.adsrc, '''', 2), '.')+1)
ELSE split_part(def.adsrc, '''', 2)
END
FROM pg_class t
JOIN pg_attribute attr ON (t.oid = attrelid)
JOIN pg_attrdef def ON (adrelid = attrelid AND adnum = attnum)
JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1])
WHERE t.oid = '"voucher_users"'::regclass
AND cons.contype = 'p'
AND def.adsrc ~* 'nextval'
SQL (1.0ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 14 LIMIT 1
SQL (1.5ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.8ms) 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 = '"plans"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.5ms) 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 = '"plans"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Plan Load (0.3ms) SELECT "plans".* FROM "plans" WHERE "plans"."name" = 'Premium' LIMIT 1
User Load (0.5ms) SELECT "users".* FROM "users" WHERE (lower(username) = 'bart+456789@soocial.com') LIMIT 1
*** success: true, existing: #<User id: 14, username: "bart+456789@soocial.com", username_password_hash: "2R1+TVEzWUqdmGMV9XyApA==", created_at: "2011-02-16 12:03:06", updated_at: "2011-02-16 12:03:06", confirmed: false, name: "Bitch", first_login: true, allow_newsletters: true, timezone: "UTC", deleted: false, vcard: "BEGIN:VCARD\nN:;Bitch;;;\nVERSION:3.0\nEMAIL:bart+4567...", me_status: 2, allow_invite_emails: true, contact_count: 1, connection_count: 0, plan_id: 2, plan_valid_until: nil, locked: 0, psp_reference: nil, subscription_type: nil, webapp_count_calculated: true, referral: nil, last_login_at: nil, last_engine_sync_at: nil, last_device_sync_at: nil, allow_tip_emails: false, clear: 0, trial_used: nil>, is_me: true
AREL (0.7ms) UPDATE "users" SET "plan_valid_until" = '2036-12-31 23:00:00.000000', "updated_at" = '2011-02-16 12:03:11.388113', "subscription_type" = 2, "plan_id" = 3 WHERE "users"."id" = 14
Redirected to http://localhost:3000/users/14
Completed 302 Found in 446ms
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DestroyUserJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DedupeJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DeviceSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DestroyExternalContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeGmailSetupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FillDeviceMappingsJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ContactCleaner
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant PremiumDeviceSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant EmailNewsletterJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant UpdateFollowerContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant SaveExternalContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RenameCategoryJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ConnectedFriendsSyncGenerator
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant SpecificDedupeJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant DeviceJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant BumpedDeviceSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RecoveryJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RestoreSnapshotJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant BlackListed
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ExternalContactJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeDeviceSetupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant ResqueJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RecoveryFromBackupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant SyncGenerator
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant BumpedSyncJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeYahooSetupJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FillCategoriesJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FillCountsJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant RemoveCategoryJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant MingleJob
/Users/spif/repos/soocial/analytics/app/models/job_descriptions.rb:334: warning: already initialized constant FinalizeWindowsLiveSetupJob
Started GET "/users/14" for 127.0.0.1 at Wed Feb 16 13:03:11 +0100 2011
Processing by UsersController#show as HTML
Parameters: {"id"=>"14"}
PK and serial sequence (2.0ms) SELECT attr.attname, 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.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 = '"voucher_users"'::regclass
PK and custom sequence (1.0ms) SELECT attr.attname,
CASE
WHEN split_part(def.adsrc, '''', 2) ~ '.' THEN
substr(split_part(def.adsrc, '''', 2),
strpos(split_part(def.adsrc, '''', 2), '.')+1)
ELSE split_part(def.adsrc, '''', 2)
END
FROM pg_class t
JOIN pg_attribute attr ON (t.oid = attrelid)
JOIN pg_attrdef def ON (adrelid = attrelid AND adnum = attnum)
JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1])
WHERE t.oid = '"voucher_users"'::regclass
AND cons.contype = 'p'
AND def.adsrc ~* 'nextval'
SQL (0.9ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 14 LIMIT 1
SQL (0.7ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Category Load (0.4ms) SELECT "categories".* FROM "categories" WHERE ("categories".user_id = 14)
Device Load (0.3ms) SELECT "devices".* FROM "devices" WHERE ("devices".user_id = 14)
SQL (0.8ms) 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 = '"devices"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Device Load (0.3ms) SELECT "devices".* FROM "devices" WHERE ("devices".user_id = 14 AND ("devices"."type" IN ('Device::WindowsLive', 'Device::Yahoo', 'Device::GMail')))
SQL (0.6ms) 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 = '"plans"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Plan Load (0.2ms) SELECT "plans".* FROM "plans" WHERE ("plans"."id" = 3)
SQL (0.9ms) 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 = '"contacts"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Contact Load (0.3ms) SELECT "contacts".* FROM "contacts" WHERE ("contacts".user_id = 14 AND ("contacts"."me" = 't'))
SQL (0.6ms) 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 = '"contacts"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (1.0ms) 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 = '"email_blacklists"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.5ms) 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 = '"email_blacklists"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
EmailBlacklist Load (0.2ms) SELECT "email_blacklists".* FROM "email_blacklists" WHERE "email_blacklists"."address" = 'bart+456789@soocial.com' LIMIT 1
DEPRECATION WARNING: <% %> style block helpers are deprecated. Please use <%= %>. (called from _app_views_users_show_html_erb___1710862944_2186424480_0 at /Users/spif/repos/soocial/analytics/app/views/users/show.html.erb:106)
SQL (0.8ms) 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 = '"categories"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) SELECT COUNT(*) FROM "categories" WHERE ("categories".user_id = 14)
SQL (0.6ms) 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 = '"backups"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) SELECT COUNT(*) FROM "backups" WHERE ("backups".user_id = 14)
SQL (0.7ms) 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 = '"relationships"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) SELECT COUNT(*) FROM "relationships" WHERE ("relationships".origin_id = 14)
SQL (0.2ms) SELECT COUNT(*) FROM "relationships" WHERE ("relationships".follower_id = 14)
Rendered users/show.html.erb within layouts/application (40.4ms)
Completed 200 OK in 675ms (Views: 42.2ms | ActiveRecord: 14.1ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment