205 SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Pe ... Person.verbose_bugnotifications, Person.visibility FROM Person WHERE Person.id = $INT LIMIT $INT:
GET: 203 Other: 2 Robots: 115 Local: 18
17 https://api.launchpad.net/1.0/branches (BranchSet:CollectionResource:#branches)
OOPS-1878O1181, OOPS-1878O1431, OOPS-1878O1654, OOPS-1878O2010, OOPS-1878O2026
Branch: launchpad-rev-12406
Revno: 12406
SQL time: 11955 ms
Non-sql time: 2488 ms
Total time: 14443 ms
Statement Count: 267
One long query which is tolerable:
1 1395.0 1 SQL-launchpad-main-master
SELECT Branch.branch_format,
Branch.branch_type,
Branch.metadir_format,
Branch.date_created,
Branch.date_last_modified,
Branch.summary,
Branch.distroseries,
Branch.id,
Branch.last_mirror_attempt,
Branch.last_mirrored,
Branch.last_mirrored_id,
Branch.last_scanned,
Branch.last_scanned_id,
Branch.lifecycle_status,
Branch.merge_queue_config,
Branch.merge_queue,
Branch.mirror_failures,
Branch.mirror_status_message,
Branch.name,
Branch.next_mirror_time,
Branch.OWNER, Branch.owner_name,
Branch.private,
Branch.product,
Branch.registrant,
Branch.repository_format,
Branch.reviewer,
Branch.revision_count,
Branch.sourcepackagename,
Branch.stacked_on,
Branch.target_suffix,
Branch.unique_name,
Branch.url,
Branch.whiteboard
FROM Branch
WHERE Branch.private = FALSE
AND Branch.last_scanned IS NOT NULL
AND Branch.private = FALSE
ORDER BY Branch.date_last_modified DESC, Branch.id DESC LIMIT $INT
OFFSET $INT
many seconds in repeated querys:
Repeated SQL Statements top
Reps Total time Average time Saving Database id Statement
1 62 1657 26 1631 SQL-launchpad-main-master
SELECT SeriesSourcePackageBranch.branch,
SeriesSourcePackageBranch.date_created,
SeriesSourcePackageBranch.distroseries,
SeriesSourcePackageBranch.id,
SeriesSourcePackageBranch.pocket,
SeriesSourcePackageBranch.registrant,
SeriesSourcePackageBranch.sourcepackagename
FROM SeriesSourcePackageBranch
WHERE SeriesSourcePackageBranch.branch = $INT
ORDER BY SeriesSourcePackageBranch.pocket
2 62 1541 24 1517 SQL-launchpad-main-master
SELECT ProductSeries.branch,
ProductSeries.datecreated,
ProductSeries.driver,
ProductSeries.id,
ProductSeries.name,
ProductSeries.OWNER, ProductSeries.product,
ProductSeries.releasefileglob,
ProductSeries.releaseverstyle,
ProductSeries.status,
ProductSeries.summary,
ProductSeries.translations_autoimport_mode,
ProductSeries.translations_branch
FROM ProductSeries
WHERE ProductSeries.branch = $INT
3 53 2765 52 2713 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
4 34 1568 46 1522 SQL-launchpad-main-master
SELECT CodeImport.assignee,
CodeImport.branch,
CodeImport.cvs_module,
CodeImport.cvs_root,
CodeImport.date_created,
CodeImport.date_last_successful,
CodeImport.id,
CodeImport.OWNER, CodeImport.rcs_type,
CodeImport.registrant,
CodeImport.review_status,
CodeImport.update_interval,
CodeImport.url
FROM CodeImport
WHERE CodeImport.branch = $INT
ORDER BY CodeImport.id
5 28 2196 78 2118 SQL-launchpad-main-master
SELECT Product.answers_usage,
Product.blueprints_usage,
Product.OWNER, Product.translations_usage,
Product.active,
Product.autoupdate,
Product.bug_reported_acknowledgement,
Product.bug_reporting_guidelines,
Product.bug_supervisor,
Product.bugtracker,
Product.date_next_suggest_packaging,
Product.datecreated,
Product.description,
Product.development_focus,
Product.displayname,
Product.downloadurl,
Product.driver,
Product.enable_bug_expiration,
Product.enable_bugfiling_duplicate_search,
Product.freshmeatproject,
Product.homepage_content,
Product.homepageurl,
Product.icon,
Product.id,
Product.lastdoap,
Product.license_approved,
Product.license_info,
Product.reviewed,
Product.logo,
Product.max_bug_heat,
Product.mugshot,
Product.name,
Product.official_answers,
Product.official_blueprints,
Product.official_malone,
Product.official_rosetta,
Product.private_bugs,
Product.programminglang,
Product.project,
Product.registrant,
Product.remote_product,
Product.reviewer_whiteboard,
Product.screenshotsurl,
Product.security_contact,
Product.sourceforgeproject,
Product.summary,
Product.title,
Product.translation_focus,
Product.translationgroup,
Product.translationpermission,
Product.wikiurl
FROM Product
WHERE Product.id = $INTLIMIT $INT
lazy evaluation of:
products
codeimports
productseries
sourcepackages
persons
One cause looks like late evaluation of sourcepackage.