ScopedCollection:CollectionResource:#person-page-resource timeouts

[Robert Collins]

  8 SELECT LibraryFileAlias.content, LibraryFileAlias.date_created, LibraryFileAlias.expires, Library ... pe, LibraryFileAlias.restricted FROM LibraryFileAlias WHERE LibraryFileAlias.id = $INT LIMIT $INT:
   GET: 8 Robots: 0 Local: 0
      2 https://api.launchpad.net/1.0/%7Elocoteams/members (ScopedCollection:CollectionResource:#person-page-resource)
       OOPS-1905C766, OOPS-1905L454
      2 https://api.launchpad.net/1.0/%7Eubuntu-core-dev/members (ScopedCollection:CollectionResource:#person-page-resource)
       OOPS-1905C1438, OOPS-1905D641

 OOPS-1905C766

Branch: launchpad-rev-12617
Revno: 12617
SQL time: 4559 ms
Non-sql time: 6636 ms
Total time: 11195 ms
Statement Count: 558

1 110 1032 9 1023 SQL-launchpad-main-master
SELECT LibraryFileAlias.content,
       LibraryFileAlias.date_created,
       LibraryFileAlias.expires,
       LibraryFileAlias.filename,
       LibraryFileAlias.hits,
       LibraryFileAlias.id,
       LibraryFileAlias.last_accessed,
       LibraryFileAlias.mimetype,
       LibraryFileAlias.restricted
FROM LibraryFileAlias
WHERE LibraryFileAlias.id = $INTLIMIT $INT

2 74 704 9 695 SQL-launchpad-main-master
SELECT PersonLocation.date_created,
       PersonLocation.date_last_modified,
       PersonLocation.id,
       PersonLocation.last_modified_by,
       PersonLocation.latitude,
       PersonLocation.longitude,
       PersonLocation.person,
       PersonLocation.time_zone,
       PersonLocation.visible
FROM PersonLocation
WHERE PersonLocation.person = $INT
ORDER BY PersonLocation.id
3 74 567 7 560 SQL-launchpad-main-master
SELECT Archive.enabled,
       Archive.authorized_size,
       Archive.binaries_cached,
       Archive.build_debug_symbols,
       Archive.buildd_secret,
       Archive.building_count,
       Archive.commercial,
       Archive.date_created,
       Archive.description,
       Archive.displayname,
       Archive.distribution,
       Archive.external_dependencies,
       Archive.failed_count,
       Archive.id,
       Archive.name,
       Archive.OWNER, Archive.package_description_cache,
                      Archive.pending_count,
                      Archive.private,
                      Archive.publish,
                      Archive.purpose,
                      Archive.relative_build_score,
                      Archive.require_virtualized,
                      Archive.signing_key,
                      Archive.sources_cached,
                      Archive.status,
                      Archive.succeeded_count,
                      Archive.total_count
FROM Archive
WHERE Archive.purpose = $INT
  AND Archive.OWNER = $INT
ORDER BY Archive.id LIMIT $INT
4 74 562 7 555 SQL-launchpad-main-master
SELECT EmailAddress.account,
       EmailAddress.email,
       EmailAddress.id,
       EmailAddress.person,
       EmailAddress.status
FROM EmailAddress
WHERE EmailAddress.person = $INT
  AND EmailAddress.status = $INT
ORDER BY EmailAddress.email
5 73 642 8 634 SQL-launchpad-main-master
SELECT KarmaTotalCache.id,
       KarmaTotalCache.karma_total,
       KarmaTotalCache.person
FROM KarmaTotalCache
WHERE KarmaTotalCache.person = $INT
ORDER BY KarmaTotalCache.id
6 73 485 6 479 SQL-launchpad-main-master
SELECT $INT
FROM
  (SELECT SignedCodeOfConduct.active, SignedCodeOfConduct.admincomment, SignedCodeOfConduct.datecreated, SignedCodeOfConduct.id, SignedCodeOfConduct.OWNER, SignedCodeOfConduct.recipient, SignedCodeOfConduct.signedcode, SignedCodeOfConduct.signingkey
   FROM SignedCodeOfConduct
   WHERE SignedCodeOfConduct.OWNER = $INT
     AND SignedCodeOfConduct.active = TRUE
     AND SignedCodeOfConduct.datecreated >= $INT-$INT-$INT $INT:$INT:$INT+$INT:$INTLIMIT $INT) AS "_tmp" LIMIT $INT
7 71 475 6 469 SQL-launchpad-main-master
SELECT Person.account,
       Person.creation_comment,
       Person.creation_rationale,
       Person.datecreated,
       Person.defaultmembershipperiod,
       Person.defaultrenewalperiod,
       Person.displayname,
       Person.hide_email_addresses,
       Person.homepage_content,
       Person.icon,
       Person.id,
       Person.logo,
       Person.mailing_list_auto_subscribe_policy,
       Person.merged,
       Person.mugshot,
       Person.name,
       Person.personal_standing,
       Person.personal_standing_reason,
       Person.registrant,
       Person.renewal_policy,
       Person.subscriptionpolicy,
       Person.teamdescription,
       Person.teamowner,
       Person.verbose_bugnotifications,
       Person.visibility
FROM Person
WHERE Person.id = $INTLIMIT $INT

[Launchpad QA Bot (lpqabot)]

Fixed in stable r12645 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/12645>.