| 2009-08-31 12:27:16 |
Luke Faraone |
bug |
|
|
added bug |
| 2009-08-31 14:03:11 |
Curtis Hovey |
affects |
launchpad-registry |
malone |
|
| 2009-11-19 05:30:51 |
Deryck Hodge |
malone: status |
New |
Triaged |
|
| 2009-11-19 05:30:55 |
Deryck Hodge |
malone: importance |
Undecided |
High |
|
| 2010-04-19 22:22:41 |
Ursula Junque |
malone: assignee |
|
Björn Tillenius (bjornt) |
|
| 2010-04-19 22:22:45 |
Ursula Junque |
malone: milestone |
|
10.04 |
|
| 2010-04-19 22:22:46 |
Ursula Junque |
malone: status |
Triaged |
Fix Committed |
|
| 2010-04-19 22:22:51 |
Ursula Junque |
tags |
|
qa-needstesting |
|
| 2010-04-20 06:36:07 |
Björn Tillenius |
malone: status |
Fix Committed |
Triaged |
|
| 2010-04-20 06:36:07 |
Björn Tillenius |
malone: milestone |
10.04 |
|
|
| 2010-04-20 06:36:07 |
Björn Tillenius |
malone: assignee |
Björn Tillenius (bjornt) |
|
|
| 2010-04-27 10:27:26 |
Deryck Hodge |
tags |
qa-needstesting |
|
|
| 2010-11-18 06:10:21 |
Curtis Hovey |
tags |
|
timeout |
|
| 2010-11-23 23:53:24 |
Robert Collins |
description |
Hi,
I understand that ~janitor has a lot of bugs attached to it, but visiting https://bugs.launchpad.net/~janitor shouldn't cause an OOPS. (OOPS-1339D1090 is one such example)
priority: low |
OOPS-1788D2599
https://bugs.launchpad.net/~janitor
|
|
| 2010-11-23 23:53:33 |
Robert Collins |
summary |
Visiting https://bugs.launchpad.net/~janitor causes a timeout |
bugs homepage timeouts |
|
| 2010-11-24 00:19:02 |
Robert Collins |
summary |
bugs homepage timeouts |
Person:+bugs timeouts |
|
| 2010-11-24 00:20:24 |
Robert Collins |
description |
OOPS-1788D2599
https://bugs.launchpad.net/~janitor
|
OOPS-1788D2599
https://bugs.launchpad.net/~janitor/+bugs
DB id: 2
Branch: launchpad-rev-11952
Revno: 11952
SQL time: 16813 ms
Non-sql time: 307 ms
Total time: 17120 ms
Statement Count: 26
Looks like one poor query (counted and then retrieved):
24. 231 10294ms SQL-launchpad-main-slave SELECT COUNT(*) FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND BugTask.assignee = 931129 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug, BugSubscription WHERE Bug.id = BugTask.bug AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND Bug.id = BugSubscription.bug AND BugSubscription.person = 931129 AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND BugTask.owner = 931129 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.bug = Bug.id AND Bug.owner = 931129 AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.id IN ( SELECT DISTINCT BugTask.id FROM BugTask, BugMessage, Message WHERE Message.owner = 931129 AND Message.id = BugMessage.message AND BugTask.bug = BugMessage.bug AND Message.id NOT IN ( SELECT BugMessage.message FROM BugMessage WHERE BugMessage.bug = BugTask.bug ORDER BY BugMessage.id LIMIT 1 ) ) AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) )) AS BugTask LEFT JOIN Bug ON BugTask.bug = Bug.id LEFT JOIN Product ON BugTask.product = Product.id LEFT JOIN SourcePackageName ON BugTask.sourcepackagename = SourcePackageName.id
25. 10536 6465ms SQL-launchpad-main-slave SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, Bug.date_last_message, Bug.date_last_updated, Bug.date_made_private, Bug.datecreated, Bug.description, Bug.duplicateof, Bug.heat, Bug.heat_last_updated, Bug.id, Bug.latest_patch_uploaded, Bug.message_count, Bug.name, Bug.number_of_duplicates, Bug.owner, Bug.private, Bug.security_related, Bug.title, Bug.users_affected_count, Bug.users_unaffected_count, Bug.who_made_private, 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.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, SourcePackageName.id, SourcePackageName.name FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND BugTask.assignee = 931129 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug, BugSubscription WHERE Bug.id = BugTask.bug AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND Bug.id = BugSubscription.bug AND BugSubscription.person = 931129 AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND BugTask.owner = 931129 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.bug = Bug.id AND Bug.owner = 931129 AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.id IN ( SELECT DISTINCT BugTask.id FROM BugTask, BugMessage, Message WHERE Message.owner = 931129 AND Message.id = BugMessage.message AND BugTask.bug = BugMessage.bug AND Message.id NOT IN ( SELECT BugMessage.message FROM BugMessage WHERE BugMessage.bug = BugTask.bug ORDER BY BugMessage.id LIMIT 1 ) ) AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) )) AS BugTask LEFT JOIN Bug ON BugTask.bug = Bug.id LEFT JOIN Product ON BugTask.product = Product.id LEFT JOIN SourcePackageName ON BugTask.sourcepackagename = SourcePackageName.id ORDER BY BugTask.importance DESC, BugTask.id LIMIT 76 OFFSET 0
|
|
| 2011-01-12 17:02:56 |
Robert Collins |
launchpad: importance |
High |
Critical |
|
| 2011-01-31 21:29:36 |
j.c.sackett |
launchpad: assignee |
|
j.c.sackett (jcsackett) |
|
| 2011-01-31 22:32:20 |
j.c.sackett |
launchpad: status |
Triaged |
In Progress |
|
| 2011-02-06 02:19:15 |
Robert Collins |
description |
OOPS-1788D2599
https://bugs.launchpad.net/~janitor/+bugs
DB id: 2
Branch: launchpad-rev-11952
Revno: 11952
SQL time: 16813 ms
Non-sql time: 307 ms
Total time: 17120 ms
Statement Count: 26
Looks like one poor query (counted and then retrieved):
24. 231 10294ms SQL-launchpad-main-slave SELECT COUNT(*) FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND BugTask.assignee = 931129 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug, BugSubscription WHERE Bug.id = BugTask.bug AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND Bug.id = BugSubscription.bug AND BugSubscription.person = 931129 AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND BugTask.owner = 931129 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.bug = Bug.id AND Bug.owner = 931129 AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.id IN ( SELECT DISTINCT BugTask.id FROM BugTask, BugMessage, Message WHERE Message.owner = 931129 AND Message.id = BugMessage.message AND BugTask.bug = BugMessage.bug AND Message.id NOT IN ( SELECT BugMessage.message FROM BugMessage WHERE BugMessage.bug = BugTask.bug ORDER BY BugMessage.id LIMIT 1 ) ) AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) )) AS BugTask LEFT JOIN Bug ON BugTask.bug = Bug.id LEFT JOIN Product ON BugTask.product = Product.id LEFT JOIN SourcePackageName ON BugTask.sourcepackagename = SourcePackageName.id
25. 10536 6465ms SQL-launchpad-main-slave SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, Bug.date_last_message, Bug.date_last_updated, Bug.date_made_private, Bug.datecreated, Bug.description, Bug.duplicateof, Bug.heat, Bug.heat_last_updated, Bug.id, Bug.latest_patch_uploaded, Bug.message_count, Bug.name, Bug.number_of_duplicates, Bug.owner, Bug.private, Bug.security_related, Bug.title, Bug.users_affected_count, Bug.users_unaffected_count, Bug.who_made_private, 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.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, SourcePackageName.id, SourcePackageName.name FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND BugTask.assignee = 931129 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug, BugSubscription WHERE Bug.id = BugTask.bug AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND Bug.id = BugSubscription.bug AND BugSubscription.person = 931129 AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND BugTask.owner = 931129 AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.bug = Bug.id AND Bug.owner = 931129 AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) ) UNION (SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.owner, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti FROM BugTask, Bug WHERE Bug.id = BugTask.bug AND ((BugTask.status = 10) OR (BugTask.status = 15) OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.id IN ( SELECT DISTINCT BugTask.id FROM BugTask, BugMessage, Message WHERE Message.owner = 931129 AND Message.id = BugMessage.message AND BugTask.bug = BugMessage.bug AND Message.id NOT IN ( SELECT BugMessage.message FROM BugMessage WHERE BugMessage.bug = BugTask.bug ORDER BY BugMessage.id LIMIT 1 ) ) AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 2 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) )) AS BugTask LEFT JOIN Bug ON BugTask.bug = Bug.id LEFT JOIN Product ON BugTask.product = Product.id LEFT JOIN SourcePackageName ON BugTask.sourcepackagename = SourcePackageName.id ORDER BY BugTask.importance DESC, BugTask.id LIMIT 76 OFFSET 0
|
OOPS-1862D2109
https://bugs.launchpad.net/~janitor/+bugs
Branch: launchpad-rev-12309
Revno: 12309
SQL time: 15034 ms
Non-sql time: 421 ms
Total time: 15455 ms
Statement Count: 10
SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 931129
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.bug = Bug.id
AND Bug.OWNER = 931129
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 931129
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND Message.id NOT IN
(SELECT BugMessage.message
FROM BugMessage
WHERE BugMessage.bug = BugTask.bug
ORDER BY BugMessage.id LIMIT 1))
AND Bug.private = FALSE)) AS BugTask
LEFT JOIN Bug ON BugTask.bug = Bug.id
LEFT JOIN Product ON BugTask.product = Product.id
LEFT JOIN SourcePackageName ON BugTask.sourcepackagename = SourcePackageName.id |
|
| 2011-02-07 14:23:15 |
j.c.sackett |
launchpad: status |
In Progress |
Triaged |
|
| 2011-02-07 14:23:18 |
j.c.sackett |
launchpad: assignee |
j.c.sackett (jcsackett) |
|
|
| 2011-02-10 07:49:14 |
Robert Collins |
branch linked |
|
lp:~lifeless/launchpad/bug-704446 |
|
| 2011-02-10 07:49:34 |
Robert Collins |
launchpad: assignee |
|
Robert Collins (lifeless) |
|
| 2011-02-10 08:09:29 |
Robert Collins |
branch unlinked |
lp:~lifeless/launchpad/bug-704446 |
|
|
| 2011-02-14 01:15:06 |
Robert Collins |
launchpad: assignee |
Robert Collins (lifeless) |
|
|
| 2011-02-23 08:42:01 |
Robert Collins |
description |
OOPS-1862D2109
https://bugs.launchpad.net/~janitor/+bugs
Branch: launchpad-rev-12309
Revno: 12309
SQL time: 15034 ms
Non-sql time: 421 ms
Total time: 15455 ms
Statement Count: 10
SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 931129
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.bug = Bug.id
AND Bug.OWNER = 931129
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 931129
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND Message.id NOT IN
(SELECT BugMessage.message
FROM BugMessage
WHERE BugMessage.bug = BugTask.bug
ORDER BY BugMessage.id LIMIT 1))
AND Bug.private = FALSE)) AS BugTask
LEFT JOIN Bug ON BugTask.bug = Bug.id
LEFT JOIN Product ON BugTask.product = Product.id
LEFT JOIN SourcePackageName ON BugTask.sourcepackagename = SourcePackageName.id |
OOPS-1880B954
https://bugs.launchpad.net/~janitor/+bugs
Branch: launchpad-rev-12406
Revno: 12406
SQL time: 13463 ms
Non-sql time: 846 ms
Total time: 14309 ms
Statement Count: 34
25. 257 6997ms SQL-launchpad-main-slave
SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.bug = Bug.id
AND Bug.OWNER = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 931129
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id
26. 7260 6211ms SQL-launchpad-main-slave
SELECT BugTask.assignee,
BugTask.bug,
BugTask.bugwatch,
BugTask.date_assigned,
BugTask.date_closed,
BugTask.date_confirmed,
BugTask.date_fix_committed,
BugTask.date_fix_released,
BugTask.date_incomplete,
BugTask.date_inprogress,
BugTask.date_left_closed,
BugTask.date_left_new,
BugTask.date_triaged,
BugTask.datecreated,
BugTask.distribution,
BugTask.distroseries,
BugTask.id,
BugTask.importance,
BugTask.milestone,
BugTask.OWNER, BugTask.product,
BugTask.productseries,
BugTask.sourcepackagename,
BugTask.status,
BugTask.statusexplanation,
BugTask.targetnamecache,
Bug.date_last_message,
Bug.date_last_updated,
Bug.date_made_private,
Bug.datecreated,
Bug.description,
Bug.duplicateof,
Bug.heat,
Bug.heat_last_updated,
Bug.id,
Bug.latest_patch_uploaded,
Bug.message_count,
Bug.name,
Bug.number_of_duplicates,
Bug.OWNER, Bug.private,
Bug.security_related,
Bug.title,
Bug.users_affected_count,
Bug.users_unaffected_count,
Bug.who_made_private
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.bug = Bug.id
AND Bug.OWNER = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 931129
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id
ORDER BY BugTask.importance DESC, BugTask.id LIMIT 76
OFFSET 0 |
|
| 2011-02-23 22:33:02 |
Robert Collins |
description |
OOPS-1880B954
https://bugs.launchpad.net/~janitor/+bugs
Branch: launchpad-rev-12406
Revno: 12406
SQL time: 13463 ms
Non-sql time: 846 ms
Total time: 14309 ms
Statement Count: 34
25. 257 6997ms SQL-launchpad-main-slave
SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.bug = Bug.id
AND Bug.OWNER = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 931129
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id
26. 7260 6211ms SQL-launchpad-main-slave
SELECT BugTask.assignee,
BugTask.bug,
BugTask.bugwatch,
BugTask.date_assigned,
BugTask.date_closed,
BugTask.date_confirmed,
BugTask.date_fix_committed,
BugTask.date_fix_released,
BugTask.date_incomplete,
BugTask.date_inprogress,
BugTask.date_left_closed,
BugTask.date_left_new,
BugTask.date_triaged,
BugTask.datecreated,
BugTask.distribution,
BugTask.distroseries,
BugTask.id,
BugTask.importance,
BugTask.milestone,
BugTask.OWNER, BugTask.product,
BugTask.productseries,
BugTask.sourcepackagename,
BugTask.status,
BugTask.statusexplanation,
BugTask.targetnamecache,
Bug.date_last_message,
Bug.date_last_updated,
Bug.date_made_private,
Bug.datecreated,
Bug.description,
Bug.duplicateof,
Bug.heat,
Bug.heat_last_updated,
Bug.id,
Bug.latest_patch_uploaded,
Bug.message_count,
Bug.name,
Bug.number_of_duplicates,
Bug.OWNER, Bug.private,
Bug.security_related,
Bug.title,
Bug.users_affected_count,
Bug.users_unaffected_count,
Bug.who_made_private
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.bug = Bug.id
AND Bug.OWNER = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 931129
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id
ORDER BY BugTask.importance DESC, BugTask.id LIMIT 76
OFFSET 0 |
https://bugs.launchpad.net/~janitor/+bugs
OOPS-1880F2305
SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.bug = Bug.id
AND Bug.OWNER = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 931129
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id; |
|
| 2011-04-07 00:14:57 |
Robert Collins |
description |
https://bugs.launchpad.net/~janitor/+bugs
OOPS-1880F2305
SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 931129
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.bug = Bug.id
AND Bug.OWNER = 931129
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache, BugTask.fti
FROM BugTask, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 931129
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask, TeamParticipation
WHERE TeamParticipation.person = 2
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)))) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id; |
20 SELECT COUNT(*) FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assig ... D BugMessage.index > $INT ) AND Bug.private = FALSE)) AS BugTask JOIN Bug ON BugTask.bug = Bug.id:
GET: 20 Robots: 7 Local: 0
5 https://bugs.launchpad.net/%7Epitti/+bugs (Person:+bugs)
OOPS-1921A1382, OOPS-1921C413, OOPS-1921C637, OOPS-1921J566, OOPS-1921N401
4 https://bugs.launchpad.net/%7Eapport/+bugs (Person:+bugs)
OOPS-1921J1015, OOPS-1921J1118, OOPS-1921J1300, OOPS-1921K931
3 https://bugs.launchpad.net/%7Epvillavi/+bugs (Person:+bugs)
OOPS-1921A1224, OOPS-1921C652, OOPS-1921K1381
[7 other URLs] |
|
| 2011-04-07 00:33:39 |
Robert Collins |
description |
20 SELECT COUNT(*) FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assig ... D BugMessage.index > $INT ) AND Bug.private = FALSE)) AS BugTask JOIN Bug ON BugTask.bug = Bug.id:
GET: 20 Robots: 7 Local: 0
5 https://bugs.launchpad.net/%7Epitti/+bugs (Person:+bugs)
OOPS-1921A1382, OOPS-1921C413, OOPS-1921C637, OOPS-1921J566, OOPS-1921N401
4 https://bugs.launchpad.net/%7Eapport/+bugs (Person:+bugs)
OOPS-1921J1015, OOPS-1921J1118, OOPS-1921J1300, OOPS-1921K931
3 https://bugs.launchpad.net/%7Epvillavi/+bugs (Person:+bugs)
OOPS-1921A1224, OOPS-1921C652, OOPS-1921K1381
[7 other URLs] |
20 SELECT COUNT(*) FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assig ... D BugMessage.index > $INT ) AND Bug.private = FALSE)) AS BugTask JOIN Bug ON BugTask.bug = Bug.id:
GET: 20 Robots: 7 Local: 0
5 https://bugs.launchpad.net/%7Epitti/+bugs (Person:+bugs)
OOPS-1921A1382, OOPS-1921C413, OOPS-1921C637, OOPS-1921J566, OOPS-1921N401
4 https://bugs.launchpad.net/%7Eapport/+bugs (Person:+bugs)
OOPS-1921J1015, OOPS-1921J1118, OOPS-1921J1300, OOPS-1921K931
3 https://bugs.launchpad.net/%7Epvillavi/+bugs (Person:+bugs)
OOPS-1921A1224, OOPS-1921C652, OOPS-1921K1381
[7 other URLs]
(from N401)
8 second query:
explain analyze SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 100
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.bug = Bug.id
AND Bug.OWNER = 100
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 100
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND Bug.private = FALSE)) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=62118.581..62118.581 rows=1 loops=1)
-> Nested Loop (cost=447450.90..467399.75 rows=3677 width=0) (actual time=62089.979..62117.834 rows=2119 loops=1)
-> HashAggregate (cost=447450.90..447487.67 rows=3677 width=276) (actual time=62089.957..62094.172 rows=2119 loops=1)
-> Append (cost=3162.15..447211.89 rows=3677 width=276) (actual time=848.743..62067.289 rows=2718 loops=1)
-> Nested Loop (cost=3162.15..21506.62 rows=1313 width=276) (actual time=848.741..3473.458 rows=31 loops=1)
-> Hash Left Join (cost=3162.15..13733.22 rows=1313 width=276) (actual time=378.237..3466.088 rows=112 loops=1)
Hash Cond: (public.bugtask.product = public.product.id)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Bitmap Heap Scan on bugtask (cost=117.30..10670.74 rows=1440 width=276) (actual time=320.456..3407.221 rows=112 loops=1)
Recheck Cond: (assignee = 100)
Filter: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> Bitmap Index Scan on bugtask__assignee__idx (cost=0.00..116.94 rows=4337 width=0) (actual time=122.220..122.220 rows=4323 loops=1)
Index Cond: (assignee = 100)
-> Hash (cost=2771.72..2771.72 rows=21851 width=5) (actual time=57.712..57.712 rows=21733 loops=1)
-> Seq Scan on product (cost=0.00..2771.72 rows=21851 width=5) (actual time=0.027..47.756 rows=21733 loops=1)
Filter: active
-> Index Scan using bug_pkey on bug (cost=0.00..5.91 rows=1 width=4) (actual time=0.059..0.060 rows=0 loops=112)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop (cost=63.95..37702.23 rows=1499 width=276) (actual time=90.524..15438.651 rows=582 loops=1)
-> Nested Loop Left Join (cost=63.95..28913.97 rows=1499 width=280) (actual time=90.431..15403.304 rows=918 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=63.95..28403.88 rows=1644 width=280) (actual time=90.416..15333.718 rows=918 loops=1)
-> Bitmap Heap Scan on bugsubscription (cost=63.95..6725.08 rows=3944 width=4) (actual time=26.524..1481.745 rows=3922 loops=1)
Recheck Cond: (person = 100)
-> Bitmap Index Scan on bugsubscription_person_idx (cost=0.00..62.97 rows=3944 width=0) (actual time=25.478..25.478 rows=3922 loops=1)
Index Cond: (person = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..5.48 rows=1 width=276) (actual time=3.269..3.530 rows=0 loops=3922)
Index Cond: (public.bugtask.bug = bugsubscription.bug)
Filter: ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25))
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.072..0.072 rows=0 loops=918)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..5.85 rows=1 width=4) (actual time=0.035..0.036 rows=1 loops=918)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop Left Join (cost=32.10..9565.86 rows=683 width=276) (actual time=62.144..90.007 rows=73 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=32.10..7541.03 rows=749 width=276) (actual time=62.137..89.518 rows=73 loops=1)
-> Bitmap Heap Scan on bug (cost=32.10..2881.42 rows=749 width=4) (actual time=62.083..74.974 rows=875 loops=1)
Recheck Cond: (owner = 100)
Filter: ((duplicateof IS NULL) AND (NOT private))
-> Bitmap Index Scan on bug_owner_idx (cost=0.00..31.91 rows=1001 width=0) (actual time=61.730..61.730 rows=1023 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..6.21 rows=1 width=276) (actual time=0.015..0.016 rows=0 loops=875)
Index Cond: (public.bugtask.bug = public.bug.id)
Filter: ((public.bugtask.owner = 100) AND ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25)))
-> Index Scan using product_pkey on product (cost=0.00..2.69 rows=1 width=5) (actual time=0.004..0.005 rows=0 loops=73)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Nested Loop (cost=305503.56..378400.41 rows=182 width=276) (actual time=38760.014..43063.254 rows=2032 loops=1)
-> Nested Loop Left Join (cost=305503.56..378026.51 rows=182 width=276) (actual time=38626.835..42983.983 rows=2722 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Hash Semi Join (cost=305503.56..377964.46 rows=200 width=276) (actual time=38626.821..42957.350 rows=2728 loops=1)
Hash Cond: (public.bugtask.id = public.bugtask.id)
-> Bitmap Heap Scan on bugtask (cost=8513.27..80064.62 rows=276215 width=276) (actual time=182.746..4598.998 rows=308733 loops=1)
Recheck Cond: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> BitmapOr (cost=8513.27..8513.27 rows=308734 width=0) (actual time=156.137..156.137 rows=0 loops=1)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..4829.87 rows=184328 width=0) (actual time=103.983..103.983 rows=184491 loops=1)
Index Cond: (status = 10)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..466.01 rows=17680 width=0) (actual time=8.011..8.011 rows=17642 loops=1)
Index Cond: (status = 15)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..1479.89 rows=56464 width=0) (actual time=22.718..22.718 rows=56538 loops=1)
Index Cond: (status = 20)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..794.52 rows=30282 width=0) (actual time=12.404..12.404 rows=30304 loops=1)
Index Cond: (status = 21)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..142.56 rows=5354 width=0) (actual time=2.719..2.719 rows=5351 loops=1)
Index Cond: (status = 22)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..386.11 rows=14627 width=0) (actual time=6.288..6.288 rows=14653 loops=1)
Index Cond: (status = 25)
-> Hash (cost=295746.16..295746.16 rows=99531 width=4) (actual time=38118.466..38118.466 rows=29835 loops=1)
-> HashAggregate (cost=293755.54..294750.85 rows=99531 width=4) (actual time=38081.451..38099.894 rows=29835 loops=1)
-> Nested Loop (cost=142973.14..293506.71 rows=99531 width=4) (actual time=15019.216..37979.238 rows=84427 loops=1)
-> Hash Join (cost=142973.14..256158.69 rows=75294 width=4) (actual time=15019.177..23263.791 rows=32134 loops=1)
Hash Cond: (bugmessage.message = message.id)
-> Seq Scan on bugmessage (cost=0.00..70798.85 rows=3027910 width=8) (actual time=7.042..3248.033 rows=3026226 loops=1)
Filter: (index > 0)
-> Hash (cost=142031.96..142031.96 rows=75294 width=4) (actual time=15011.968..15011.968 rows=75175 loops=1)
-> Bitmap Heap Scan on message (cost=1205.51..142031.96 rows=75294 width=4) (actual time=129.011..14917.650 rows=75175 loops=1)
Recheck Cond: (owner = 100)
-> Bitmap Index Scan on message_owner_idx (cost=0.00..1186.69 rows=75294 width=0) (actual time=115.022..115.022 rows=75175 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..0.48 rows=1 width=8) (actual time=0.272..0.455 rows=3 loops=32134)
Index Cond: (public.bugtask.bug = bugmessage.bug)
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.007..0.007 rows=0 loops=2728)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..2.04 rows=1 width=4) (actual time=0.027..0.027 rows=1 loops=2722)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Index Scan using bug_pkey on bug (cost=0.00..5.39 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=2119)
Index Cond: (public.bug.id = public.bugtask.bug)
Total runtime: 62125.406 ms
(93 rows)
runtime hot is:
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=7239.114..7239.114 rows=1 loops=1) |
|
| 2011-04-07 10:45:04 |
Robert Collins |
branch linked |
|
lp:~lifeless/launchpad/bug-421901 |
|
| 2011-04-08 08:16:36 |
Launchpad QA Bot |
launchpad: milestone |
|
11.04 |
|
| 2011-04-08 08:16:36 |
Launchpad QA Bot |
launchpad: assignee |
|
Robert Collins (lifeless) |
|
| 2011-04-08 08:16:39 |
Launchpad QA Bot |
tags |
lp-bugs timeout |
lp-bugs qa-needstesting timeout |
|
| 2011-04-08 08:16:40 |
Launchpad QA Bot |
launchpad: status |
Triaged |
Fix Committed |
|
| 2011-04-08 09:02:41 |
Robert Collins |
tags |
lp-bugs qa-needstesting timeout |
lp-bugs qa-ok timeout |
|
| 2011-04-11 04:17:30 |
Launchpad QA Bot |
tags |
lp-bugs qa-ok timeout |
lp-bugs qa-needstesting timeout |
|
| 2011-04-12 03:03:52 |
Robert Collins |
tags |
lp-bugs qa-needstesting timeout |
lp-bugs qa-ok timeout |
|
| 2011-04-12 15:47:16 |
Launchpad QA Bot |
launchpad: milestone |
11.04 |
11.05 |
|
| 2011-04-12 15:47:18 |
Launchpad QA Bot |
tags |
lp-bugs qa-ok timeout |
lp-bugs qa-needstesting timeout |
|
| 2011-04-12 20:30:52 |
Robert Collins |
tags |
lp-bugs qa-needstesting timeout |
lp-bugs qa-ok timeout |
|
| 2011-04-12 20:46:58 |
Luke Faraone |
removed subscriber Luke Faraone |
|
|
|
| 2011-04-17 22:40:07 |
Robert Collins |
launchpad: assignee |
Robert Collins (lifeless) |
|
|
| 2011-04-17 22:40:09 |
Robert Collins |
launchpad: milestone |
11.05 |
|
|
| 2011-05-01 21:02:45 |
Robert Collins |
description |
20 SELECT COUNT(*) FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assig ... D BugMessage.index > $INT ) AND Bug.private = FALSE)) AS BugTask JOIN Bug ON BugTask.bug = Bug.id:
GET: 20 Robots: 7 Local: 0
5 https://bugs.launchpad.net/%7Epitti/+bugs (Person:+bugs)
OOPS-1921A1382, OOPS-1921C413, OOPS-1921C637, OOPS-1921J566, OOPS-1921N401
4 https://bugs.launchpad.net/%7Eapport/+bugs (Person:+bugs)
OOPS-1921J1015, OOPS-1921J1118, OOPS-1921J1300, OOPS-1921K931
3 https://bugs.launchpad.net/%7Epvillavi/+bugs (Person:+bugs)
OOPS-1921A1224, OOPS-1921C652, OOPS-1921K1381
[7 other URLs]
(from N401)
8 second query:
explain analyze SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 100
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.bug = Bug.id
AND Bug.OWNER = 100
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 100
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND Bug.private = FALSE)) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=62118.581..62118.581 rows=1 loops=1)
-> Nested Loop (cost=447450.90..467399.75 rows=3677 width=0) (actual time=62089.979..62117.834 rows=2119 loops=1)
-> HashAggregate (cost=447450.90..447487.67 rows=3677 width=276) (actual time=62089.957..62094.172 rows=2119 loops=1)
-> Append (cost=3162.15..447211.89 rows=3677 width=276) (actual time=848.743..62067.289 rows=2718 loops=1)
-> Nested Loop (cost=3162.15..21506.62 rows=1313 width=276) (actual time=848.741..3473.458 rows=31 loops=1)
-> Hash Left Join (cost=3162.15..13733.22 rows=1313 width=276) (actual time=378.237..3466.088 rows=112 loops=1)
Hash Cond: (public.bugtask.product = public.product.id)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Bitmap Heap Scan on bugtask (cost=117.30..10670.74 rows=1440 width=276) (actual time=320.456..3407.221 rows=112 loops=1)
Recheck Cond: (assignee = 100)
Filter: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> Bitmap Index Scan on bugtask__assignee__idx (cost=0.00..116.94 rows=4337 width=0) (actual time=122.220..122.220 rows=4323 loops=1)
Index Cond: (assignee = 100)
-> Hash (cost=2771.72..2771.72 rows=21851 width=5) (actual time=57.712..57.712 rows=21733 loops=1)
-> Seq Scan on product (cost=0.00..2771.72 rows=21851 width=5) (actual time=0.027..47.756 rows=21733 loops=1)
Filter: active
-> Index Scan using bug_pkey on bug (cost=0.00..5.91 rows=1 width=4) (actual time=0.059..0.060 rows=0 loops=112)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop (cost=63.95..37702.23 rows=1499 width=276) (actual time=90.524..15438.651 rows=582 loops=1)
-> Nested Loop Left Join (cost=63.95..28913.97 rows=1499 width=280) (actual time=90.431..15403.304 rows=918 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=63.95..28403.88 rows=1644 width=280) (actual time=90.416..15333.718 rows=918 loops=1)
-> Bitmap Heap Scan on bugsubscription (cost=63.95..6725.08 rows=3944 width=4) (actual time=26.524..1481.745 rows=3922 loops=1)
Recheck Cond: (person = 100)
-> Bitmap Index Scan on bugsubscription_person_idx (cost=0.00..62.97 rows=3944 width=0) (actual time=25.478..25.478 rows=3922 loops=1)
Index Cond: (person = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..5.48 rows=1 width=276) (actual time=3.269..3.530 rows=0 loops=3922)
Index Cond: (public.bugtask.bug = bugsubscription.bug)
Filter: ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25))
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.072..0.072 rows=0 loops=918)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..5.85 rows=1 width=4) (actual time=0.035..0.036 rows=1 loops=918)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop Left Join (cost=32.10..9565.86 rows=683 width=276) (actual time=62.144..90.007 rows=73 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=32.10..7541.03 rows=749 width=276) (actual time=62.137..89.518 rows=73 loops=1)
-> Bitmap Heap Scan on bug (cost=32.10..2881.42 rows=749 width=4) (actual time=62.083..74.974 rows=875 loops=1)
Recheck Cond: (owner = 100)
Filter: ((duplicateof IS NULL) AND (NOT private))
-> Bitmap Index Scan on bug_owner_idx (cost=0.00..31.91 rows=1001 width=0) (actual time=61.730..61.730 rows=1023 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..6.21 rows=1 width=276) (actual time=0.015..0.016 rows=0 loops=875)
Index Cond: (public.bugtask.bug = public.bug.id)
Filter: ((public.bugtask.owner = 100) AND ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25)))
-> Index Scan using product_pkey on product (cost=0.00..2.69 rows=1 width=5) (actual time=0.004..0.005 rows=0 loops=73)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Nested Loop (cost=305503.56..378400.41 rows=182 width=276) (actual time=38760.014..43063.254 rows=2032 loops=1)
-> Nested Loop Left Join (cost=305503.56..378026.51 rows=182 width=276) (actual time=38626.835..42983.983 rows=2722 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Hash Semi Join (cost=305503.56..377964.46 rows=200 width=276) (actual time=38626.821..42957.350 rows=2728 loops=1)
Hash Cond: (public.bugtask.id = public.bugtask.id)
-> Bitmap Heap Scan on bugtask (cost=8513.27..80064.62 rows=276215 width=276) (actual time=182.746..4598.998 rows=308733 loops=1)
Recheck Cond: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> BitmapOr (cost=8513.27..8513.27 rows=308734 width=0) (actual time=156.137..156.137 rows=0 loops=1)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..4829.87 rows=184328 width=0) (actual time=103.983..103.983 rows=184491 loops=1)
Index Cond: (status = 10)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..466.01 rows=17680 width=0) (actual time=8.011..8.011 rows=17642 loops=1)
Index Cond: (status = 15)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..1479.89 rows=56464 width=0) (actual time=22.718..22.718 rows=56538 loops=1)
Index Cond: (status = 20)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..794.52 rows=30282 width=0) (actual time=12.404..12.404 rows=30304 loops=1)
Index Cond: (status = 21)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..142.56 rows=5354 width=0) (actual time=2.719..2.719 rows=5351 loops=1)
Index Cond: (status = 22)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..386.11 rows=14627 width=0) (actual time=6.288..6.288 rows=14653 loops=1)
Index Cond: (status = 25)
-> Hash (cost=295746.16..295746.16 rows=99531 width=4) (actual time=38118.466..38118.466 rows=29835 loops=1)
-> HashAggregate (cost=293755.54..294750.85 rows=99531 width=4) (actual time=38081.451..38099.894 rows=29835 loops=1)
-> Nested Loop (cost=142973.14..293506.71 rows=99531 width=4) (actual time=15019.216..37979.238 rows=84427 loops=1)
-> Hash Join (cost=142973.14..256158.69 rows=75294 width=4) (actual time=15019.177..23263.791 rows=32134 loops=1)
Hash Cond: (bugmessage.message = message.id)
-> Seq Scan on bugmessage (cost=0.00..70798.85 rows=3027910 width=8) (actual time=7.042..3248.033 rows=3026226 loops=1)
Filter: (index > 0)
-> Hash (cost=142031.96..142031.96 rows=75294 width=4) (actual time=15011.968..15011.968 rows=75175 loops=1)
-> Bitmap Heap Scan on message (cost=1205.51..142031.96 rows=75294 width=4) (actual time=129.011..14917.650 rows=75175 loops=1)
Recheck Cond: (owner = 100)
-> Bitmap Index Scan on message_owner_idx (cost=0.00..1186.69 rows=75294 width=0) (actual time=115.022..115.022 rows=75175 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..0.48 rows=1 width=8) (actual time=0.272..0.455 rows=3 loops=32134)
Index Cond: (public.bugtask.bug = bugmessage.bug)
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.007..0.007 rows=0 loops=2728)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..2.04 rows=1 width=4) (actual time=0.027..0.027 rows=1 loops=2722)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Index Scan using bug_pkey on bug (cost=0.00..5.39 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=2119)
Index Cond: (public.bug.id = public.bugtask.bug)
Total runtime: 62125.406 ms
(93 rows)
runtime hot is:
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=7239.114..7239.114 rows=1 loops=1) |
Summary
=======
Determining which bugs a person commented on is very expensive due to querying across 3 multi-million-row tables. This most often shows up on the +bugs page for persons that comment on a high proportion of bugs.
Workaround
==========
None available. Retrying may work.
Status
======
A schema change to permit more efficient queries has been made. After the next db downtime the page queries need tuning to take advantage of this change
Details
=======
20 SELECT COUNT(*) FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assig ... D BugMessage.index > $INT ) AND Bug.private = FALSE)) AS BugTask JOIN Bug ON BugTask.bug = Bug.id:
GET: 20 Robots: 7 Local: 0
5 https://bugs.launchpad.net/%7Epitti/+bugs (Person:+bugs)
OOPS-1921A1382, OOPS-1921C413, OOPS-1921C637, OOPS-1921J566, OOPS-1921N401
4 https://bugs.launchpad.net/%7Eapport/+bugs (Person:+bugs)
OOPS-1921J1015, OOPS-1921J1118, OOPS-1921J1300, OOPS-1921K931
3 https://bugs.launchpad.net/%7Epvillavi/+bugs (Person:+bugs)
OOPS-1921A1224, OOPS-1921C652, OOPS-1921K1381
[7 other URLs]
(from N401)
8 second query:
explain analyze SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 100
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.bug = Bug.id
AND Bug.OWNER = 100
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 100
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND Bug.private = FALSE)) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=62118.581..62118.581 rows=1 loops=1)
-> Nested Loop (cost=447450.90..467399.75 rows=3677 width=0) (actual time=62089.979..62117.834 rows=2119 loops=1)
-> HashAggregate (cost=447450.90..447487.67 rows=3677 width=276) (actual time=62089.957..62094.172 rows=2119 loops=1)
-> Append (cost=3162.15..447211.89 rows=3677 width=276) (actual time=848.743..62067.289 rows=2718 loops=1)
-> Nested Loop (cost=3162.15..21506.62 rows=1313 width=276) (actual time=848.741..3473.458 rows=31 loops=1)
-> Hash Left Join (cost=3162.15..13733.22 rows=1313 width=276) (actual time=378.237..3466.088 rows=112 loops=1)
Hash Cond: (public.bugtask.product = public.product.id)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Bitmap Heap Scan on bugtask (cost=117.30..10670.74 rows=1440 width=276) (actual time=320.456..3407.221 rows=112 loops=1)
Recheck Cond: (assignee = 100)
Filter: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> Bitmap Index Scan on bugtask__assignee__idx (cost=0.00..116.94 rows=4337 width=0) (actual time=122.220..122.220 rows=4323 loops=1)
Index Cond: (assignee = 100)
-> Hash (cost=2771.72..2771.72 rows=21851 width=5) (actual time=57.712..57.712 rows=21733 loops=1)
-> Seq Scan on product (cost=0.00..2771.72 rows=21851 width=5) (actual time=0.027..47.756 rows=21733 loops=1)
Filter: active
-> Index Scan using bug_pkey on bug (cost=0.00..5.91 rows=1 width=4) (actual time=0.059..0.060 rows=0 loops=112)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop (cost=63.95..37702.23 rows=1499 width=276) (actual time=90.524..15438.651 rows=582 loops=1)
-> Nested Loop Left Join (cost=63.95..28913.97 rows=1499 width=280) (actual time=90.431..15403.304 rows=918 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=63.95..28403.88 rows=1644 width=280) (actual time=90.416..15333.718 rows=918 loops=1)
-> Bitmap Heap Scan on bugsubscription (cost=63.95..6725.08 rows=3944 width=4) (actual time=26.524..1481.745 rows=3922 loops=1)
Recheck Cond: (person = 100)
-> Bitmap Index Scan on bugsubscription_person_idx (cost=0.00..62.97 rows=3944 width=0) (actual time=25.478..25.478 rows=3922 loops=1)
Index Cond: (person = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..5.48 rows=1 width=276) (actual time=3.269..3.530 rows=0 loops=3922)
Index Cond: (public.bugtask.bug = bugsubscription.bug)
Filter: ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25))
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.072..0.072 rows=0 loops=918)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..5.85 rows=1 width=4) (actual time=0.035..0.036 rows=1 loops=918)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop Left Join (cost=32.10..9565.86 rows=683 width=276) (actual time=62.144..90.007 rows=73 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=32.10..7541.03 rows=749 width=276) (actual time=62.137..89.518 rows=73 loops=1)
-> Bitmap Heap Scan on bug (cost=32.10..2881.42 rows=749 width=4) (actual time=62.083..74.974 rows=875 loops=1)
Recheck Cond: (owner = 100)
Filter: ((duplicateof IS NULL) AND (NOT private))
-> Bitmap Index Scan on bug_owner_idx (cost=0.00..31.91 rows=1001 width=0) (actual time=61.730..61.730 rows=1023 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..6.21 rows=1 width=276) (actual time=0.015..0.016 rows=0 loops=875)
Index Cond: (public.bugtask.bug = public.bug.id)
Filter: ((public.bugtask.owner = 100) AND ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25)))
-> Index Scan using product_pkey on product (cost=0.00..2.69 rows=1 width=5) (actual time=0.004..0.005 rows=0 loops=73)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Nested Loop (cost=305503.56..378400.41 rows=182 width=276) (actual time=38760.014..43063.254 rows=2032 loops=1)
-> Nested Loop Left Join (cost=305503.56..378026.51 rows=182 width=276) (actual time=38626.835..42983.983 rows=2722 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Hash Semi Join (cost=305503.56..377964.46 rows=200 width=276) (actual time=38626.821..42957.350 rows=2728 loops=1)
Hash Cond: (public.bugtask.id = public.bugtask.id)
-> Bitmap Heap Scan on bugtask (cost=8513.27..80064.62 rows=276215 width=276) (actual time=182.746..4598.998 rows=308733 loops=1)
Recheck Cond: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> BitmapOr (cost=8513.27..8513.27 rows=308734 width=0) (actual time=156.137..156.137 rows=0 loops=1)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..4829.87 rows=184328 width=0) (actual time=103.983..103.983 rows=184491 loops=1)
Index Cond: (status = 10)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..466.01 rows=17680 width=0) (actual time=8.011..8.011 rows=17642 loops=1)
Index Cond: (status = 15)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..1479.89 rows=56464 width=0) (actual time=22.718..22.718 rows=56538 loops=1)
Index Cond: (status = 20)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..794.52 rows=30282 width=0) (actual time=12.404..12.404 rows=30304 loops=1)
Index Cond: (status = 21)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..142.56 rows=5354 width=0) (actual time=2.719..2.719 rows=5351 loops=1)
Index Cond: (status = 22)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..386.11 rows=14627 width=0) (actual time=6.288..6.288 rows=14653 loops=1)
Index Cond: (status = 25)
-> Hash (cost=295746.16..295746.16 rows=99531 width=4) (actual time=38118.466..38118.466 rows=29835 loops=1)
-> HashAggregate (cost=293755.54..294750.85 rows=99531 width=4) (actual time=38081.451..38099.894 rows=29835 loops=1)
-> Nested Loop (cost=142973.14..293506.71 rows=99531 width=4) (actual time=15019.216..37979.238 rows=84427 loops=1)
-> Hash Join (cost=142973.14..256158.69 rows=75294 width=4) (actual time=15019.177..23263.791 rows=32134 loops=1)
Hash Cond: (bugmessage.message = message.id)
-> Seq Scan on bugmessage (cost=0.00..70798.85 rows=3027910 width=8) (actual time=7.042..3248.033 rows=3026226 loops=1)
Filter: (index > 0)
-> Hash (cost=142031.96..142031.96 rows=75294 width=4) (actual time=15011.968..15011.968 rows=75175 loops=1)
-> Bitmap Heap Scan on message (cost=1205.51..142031.96 rows=75294 width=4) (actual time=129.011..14917.650 rows=75175 loops=1)
Recheck Cond: (owner = 100)
-> Bitmap Index Scan on message_owner_idx (cost=0.00..1186.69 rows=75294 width=0) (actual time=115.022..115.022 rows=75175 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..0.48 rows=1 width=8) (actual time=0.272..0.455 rows=3 loops=32134)
Index Cond: (public.bugtask.bug = bugmessage.bug)
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.007..0.007 rows=0 loops=2728)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..2.04 rows=1 width=4) (actual time=0.027..0.027 rows=1 loops=2722)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Index Scan using bug_pkey on bug (cost=0.00..5.39 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=2119)
Index Cond: (public.bug.id = public.bugtask.bug)
Total runtime: 62125.406 ms
(93 rows)
runtime hot is:
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=7239.114..7239.114 rows=1 loops=1) |
|
| 2011-05-03 22:56:59 |
Robert Collins |
description |
Summary
=======
Determining which bugs a person commented on is very expensive due to querying across 3 multi-million-row tables. This most often shows up on the +bugs page for persons that comment on a high proportion of bugs.
Workaround
==========
None available. Retrying may work.
Status
======
A schema change to permit more efficient queries has been made. After the next db downtime the page queries need tuning to take advantage of this change
Details
=======
20 SELECT COUNT(*) FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assig ... D BugMessage.index > $INT ) AND Bug.private = FALSE)) AS BugTask JOIN Bug ON BugTask.bug = Bug.id:
GET: 20 Robots: 7 Local: 0
5 https://bugs.launchpad.net/%7Epitti/+bugs (Person:+bugs)
OOPS-1921A1382, OOPS-1921C413, OOPS-1921C637, OOPS-1921J566, OOPS-1921N401
4 https://bugs.launchpad.net/%7Eapport/+bugs (Person:+bugs)
OOPS-1921J1015, OOPS-1921J1118, OOPS-1921J1300, OOPS-1921K931
3 https://bugs.launchpad.net/%7Epvillavi/+bugs (Person:+bugs)
OOPS-1921A1224, OOPS-1921C652, OOPS-1921K1381
[7 other URLs]
(from N401)
8 second query:
explain analyze SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 100
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.bug = Bug.id
AND Bug.OWNER = 100
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 100
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND Bug.private = FALSE)) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=62118.581..62118.581 rows=1 loops=1)
-> Nested Loop (cost=447450.90..467399.75 rows=3677 width=0) (actual time=62089.979..62117.834 rows=2119 loops=1)
-> HashAggregate (cost=447450.90..447487.67 rows=3677 width=276) (actual time=62089.957..62094.172 rows=2119 loops=1)
-> Append (cost=3162.15..447211.89 rows=3677 width=276) (actual time=848.743..62067.289 rows=2718 loops=1)
-> Nested Loop (cost=3162.15..21506.62 rows=1313 width=276) (actual time=848.741..3473.458 rows=31 loops=1)
-> Hash Left Join (cost=3162.15..13733.22 rows=1313 width=276) (actual time=378.237..3466.088 rows=112 loops=1)
Hash Cond: (public.bugtask.product = public.product.id)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Bitmap Heap Scan on bugtask (cost=117.30..10670.74 rows=1440 width=276) (actual time=320.456..3407.221 rows=112 loops=1)
Recheck Cond: (assignee = 100)
Filter: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> Bitmap Index Scan on bugtask__assignee__idx (cost=0.00..116.94 rows=4337 width=0) (actual time=122.220..122.220 rows=4323 loops=1)
Index Cond: (assignee = 100)
-> Hash (cost=2771.72..2771.72 rows=21851 width=5) (actual time=57.712..57.712 rows=21733 loops=1)
-> Seq Scan on product (cost=0.00..2771.72 rows=21851 width=5) (actual time=0.027..47.756 rows=21733 loops=1)
Filter: active
-> Index Scan using bug_pkey on bug (cost=0.00..5.91 rows=1 width=4) (actual time=0.059..0.060 rows=0 loops=112)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop (cost=63.95..37702.23 rows=1499 width=276) (actual time=90.524..15438.651 rows=582 loops=1)
-> Nested Loop Left Join (cost=63.95..28913.97 rows=1499 width=280) (actual time=90.431..15403.304 rows=918 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=63.95..28403.88 rows=1644 width=280) (actual time=90.416..15333.718 rows=918 loops=1)
-> Bitmap Heap Scan on bugsubscription (cost=63.95..6725.08 rows=3944 width=4) (actual time=26.524..1481.745 rows=3922 loops=1)
Recheck Cond: (person = 100)
-> Bitmap Index Scan on bugsubscription_person_idx (cost=0.00..62.97 rows=3944 width=0) (actual time=25.478..25.478 rows=3922 loops=1)
Index Cond: (person = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..5.48 rows=1 width=276) (actual time=3.269..3.530 rows=0 loops=3922)
Index Cond: (public.bugtask.bug = bugsubscription.bug)
Filter: ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25))
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.072..0.072 rows=0 loops=918)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..5.85 rows=1 width=4) (actual time=0.035..0.036 rows=1 loops=918)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop Left Join (cost=32.10..9565.86 rows=683 width=276) (actual time=62.144..90.007 rows=73 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=32.10..7541.03 rows=749 width=276) (actual time=62.137..89.518 rows=73 loops=1)
-> Bitmap Heap Scan on bug (cost=32.10..2881.42 rows=749 width=4) (actual time=62.083..74.974 rows=875 loops=1)
Recheck Cond: (owner = 100)
Filter: ((duplicateof IS NULL) AND (NOT private))
-> Bitmap Index Scan on bug_owner_idx (cost=0.00..31.91 rows=1001 width=0) (actual time=61.730..61.730 rows=1023 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..6.21 rows=1 width=276) (actual time=0.015..0.016 rows=0 loops=875)
Index Cond: (public.bugtask.bug = public.bug.id)
Filter: ((public.bugtask.owner = 100) AND ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25)))
-> Index Scan using product_pkey on product (cost=0.00..2.69 rows=1 width=5) (actual time=0.004..0.005 rows=0 loops=73)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Nested Loop (cost=305503.56..378400.41 rows=182 width=276) (actual time=38760.014..43063.254 rows=2032 loops=1)
-> Nested Loop Left Join (cost=305503.56..378026.51 rows=182 width=276) (actual time=38626.835..42983.983 rows=2722 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Hash Semi Join (cost=305503.56..377964.46 rows=200 width=276) (actual time=38626.821..42957.350 rows=2728 loops=1)
Hash Cond: (public.bugtask.id = public.bugtask.id)
-> Bitmap Heap Scan on bugtask (cost=8513.27..80064.62 rows=276215 width=276) (actual time=182.746..4598.998 rows=308733 loops=1)
Recheck Cond: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> BitmapOr (cost=8513.27..8513.27 rows=308734 width=0) (actual time=156.137..156.137 rows=0 loops=1)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..4829.87 rows=184328 width=0) (actual time=103.983..103.983 rows=184491 loops=1)
Index Cond: (status = 10)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..466.01 rows=17680 width=0) (actual time=8.011..8.011 rows=17642 loops=1)
Index Cond: (status = 15)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..1479.89 rows=56464 width=0) (actual time=22.718..22.718 rows=56538 loops=1)
Index Cond: (status = 20)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..794.52 rows=30282 width=0) (actual time=12.404..12.404 rows=30304 loops=1)
Index Cond: (status = 21)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..142.56 rows=5354 width=0) (actual time=2.719..2.719 rows=5351 loops=1)
Index Cond: (status = 22)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..386.11 rows=14627 width=0) (actual time=6.288..6.288 rows=14653 loops=1)
Index Cond: (status = 25)
-> Hash (cost=295746.16..295746.16 rows=99531 width=4) (actual time=38118.466..38118.466 rows=29835 loops=1)
-> HashAggregate (cost=293755.54..294750.85 rows=99531 width=4) (actual time=38081.451..38099.894 rows=29835 loops=1)
-> Nested Loop (cost=142973.14..293506.71 rows=99531 width=4) (actual time=15019.216..37979.238 rows=84427 loops=1)
-> Hash Join (cost=142973.14..256158.69 rows=75294 width=4) (actual time=15019.177..23263.791 rows=32134 loops=1)
Hash Cond: (bugmessage.message = message.id)
-> Seq Scan on bugmessage (cost=0.00..70798.85 rows=3027910 width=8) (actual time=7.042..3248.033 rows=3026226 loops=1)
Filter: (index > 0)
-> Hash (cost=142031.96..142031.96 rows=75294 width=4) (actual time=15011.968..15011.968 rows=75175 loops=1)
-> Bitmap Heap Scan on message (cost=1205.51..142031.96 rows=75294 width=4) (actual time=129.011..14917.650 rows=75175 loops=1)
Recheck Cond: (owner = 100)
-> Bitmap Index Scan on message_owner_idx (cost=0.00..1186.69 rows=75294 width=0) (actual time=115.022..115.022 rows=75175 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..0.48 rows=1 width=8) (actual time=0.272..0.455 rows=3 loops=32134)
Index Cond: (public.bugtask.bug = bugmessage.bug)
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.007..0.007 rows=0 loops=2728)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..2.04 rows=1 width=4) (actual time=0.027..0.027 rows=1 loops=2722)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Index Scan using bug_pkey on bug (cost=0.00..5.39 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=2119)
Index Cond: (public.bug.id = public.bugtask.bug)
Total runtime: 62125.406 ms
(93 rows)
runtime hot is:
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=7239.114..7239.114 rows=1 loops=1) |
Summary
=======
Determining which bugs a person commented on is very expensive due to querying across 3 multi-million-row tables. This most often shows up on the +bugs page for persons that comment on a high proportion of bugs.
Workaround
==========
None available. Retrying may work.
Status
======
A schema change to permit more efficient queries has been made. After the next db downtime the page queries need tuning to take advantage of this change. The feature flag malone.bugmessager_owner controls the use of the new schema (but setting that flag may not be enough on its own).
Details
=======
20 SELECT COUNT(*) FROM ((SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assig ... D BugMessage.index > $INT ) AND Bug.private = FALSE)) AS BugTask JOIN Bug ON BugTask.bug = Bug.id:
GET: 20 Robots: 7 Local: 0
5 https://bugs.launchpad.net/%7Epitti/+bugs (Person:+bugs)
OOPS-1921A1382, OOPS-1921C413, OOPS-1921C637, OOPS-1921J566, OOPS-1921N401
4 https://bugs.launchpad.net/%7Eapport/+bugs (Person:+bugs)
OOPS-1921J1015, OOPS-1921J1118, OOPS-1921J1300, OOPS-1921K931
3 https://bugs.launchpad.net/%7Epvillavi/+bugs (Person:+bugs)
OOPS-1921A1224, OOPS-1921C652, OOPS-1921K1381
[7 other URLs]
(from N401)
8 second query:
explain analyze SELECT COUNT(*)
FROM (
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.assignee = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug, BugSubscription
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND Bug.id = BugSubscription.bug
AND BugSubscription.person = 100
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND BugTask.OWNER = 100
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.bug = Bug.id
AND Bug.OWNER = 100
AND Bug.private = FALSE)
UNION
(SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_closed, BugTask.date_confirmed, BugTask.date_fix_committed, BugTask.date_fix_released, BugTask.date_incomplete, BugTask.date_inprogress, BugTask.date_left_closed, BugTask.date_left_new, BugTask.date_triaged, BugTask.datecreated, BugTask.distribution, BugTask.distroseries, BugTask.id, BugTask.importance, BugTask.milestone, BugTask.OWNER, BugTask.product, BugTask.productseries, BugTask.sourcepackagename, BugTask.status, BugTask.statusexplanation, BugTask.targetnamecache
FROM BugTask
LEFT JOIN Product ON BugTask.product = Product.id
AND Product.active, Bug
WHERE Bug.id = BugTask.bug
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bugtask.product IS NULL
OR Product.active = TRUE)
AND BugTask.id IN
(SELECT DISTINCT BugTask.id
FROM BugTask, BugMessage, Message
WHERE Message.OWNER = 100
AND Message.id = BugMessage.message
AND BugTask.bug = BugMessage.bug
AND BugMessage.INDEX > 0)
AND Bug.private = FALSE)) AS BugTask
JOIN Bug ON BugTask.bug = Bug.id;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=62118.581..62118.581 rows=1 loops=1)
-> Nested Loop (cost=447450.90..467399.75 rows=3677 width=0) (actual time=62089.979..62117.834 rows=2119 loops=1)
-> HashAggregate (cost=447450.90..447487.67 rows=3677 width=276) (actual time=62089.957..62094.172 rows=2119 loops=1)
-> Append (cost=3162.15..447211.89 rows=3677 width=276) (actual time=848.743..62067.289 rows=2718 loops=1)
-> Nested Loop (cost=3162.15..21506.62 rows=1313 width=276) (actual time=848.741..3473.458 rows=31 loops=1)
-> Hash Left Join (cost=3162.15..13733.22 rows=1313 width=276) (actual time=378.237..3466.088 rows=112 loops=1)
Hash Cond: (public.bugtask.product = public.product.id)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Bitmap Heap Scan on bugtask (cost=117.30..10670.74 rows=1440 width=276) (actual time=320.456..3407.221 rows=112 loops=1)
Recheck Cond: (assignee = 100)
Filter: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> Bitmap Index Scan on bugtask__assignee__idx (cost=0.00..116.94 rows=4337 width=0) (actual time=122.220..122.220 rows=4323 loops=1)
Index Cond: (assignee = 100)
-> Hash (cost=2771.72..2771.72 rows=21851 width=5) (actual time=57.712..57.712 rows=21733 loops=1)
-> Seq Scan on product (cost=0.00..2771.72 rows=21851 width=5) (actual time=0.027..47.756 rows=21733 loops=1)
Filter: active
-> Index Scan using bug_pkey on bug (cost=0.00..5.91 rows=1 width=4) (actual time=0.059..0.060 rows=0 loops=112)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop (cost=63.95..37702.23 rows=1499 width=276) (actual time=90.524..15438.651 rows=582 loops=1)
-> Nested Loop Left Join (cost=63.95..28913.97 rows=1499 width=280) (actual time=90.431..15403.304 rows=918 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=63.95..28403.88 rows=1644 width=280) (actual time=90.416..15333.718 rows=918 loops=1)
-> Bitmap Heap Scan on bugsubscription (cost=63.95..6725.08 rows=3944 width=4) (actual time=26.524..1481.745 rows=3922 loops=1)
Recheck Cond: (person = 100)
-> Bitmap Index Scan on bugsubscription_person_idx (cost=0.00..62.97 rows=3944 width=0) (actual time=25.478..25.478 rows=3922 loops=1)
Index Cond: (person = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..5.48 rows=1 width=276) (actual time=3.269..3.530 rows=0 loops=3922)
Index Cond: (public.bugtask.bug = bugsubscription.bug)
Filter: ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25))
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.072..0.072 rows=0 loops=918)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..5.85 rows=1 width=4) (actual time=0.035..0.036 rows=1 loops=918)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Nested Loop Left Join (cost=32.10..9565.86 rows=683 width=276) (actual time=62.144..90.007 rows=73 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Nested Loop (cost=32.10..7541.03 rows=749 width=276) (actual time=62.137..89.518 rows=73 loops=1)
-> Bitmap Heap Scan on bug (cost=32.10..2881.42 rows=749 width=4) (actual time=62.083..74.974 rows=875 loops=1)
Recheck Cond: (owner = 100)
Filter: ((duplicateof IS NULL) AND (NOT private))
-> Bitmap Index Scan on bug_owner_idx (cost=0.00..31.91 rows=1001 width=0) (actual time=61.730..61.730 rows=1023 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..6.21 rows=1 width=276) (actual time=0.015..0.016 rows=0 loops=875)
Index Cond: (public.bugtask.bug = public.bug.id)
Filter: ((public.bugtask.owner = 100) AND ((public.bugtask.status = 10) OR (public.bugtask.status = 15) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25)))
-> Index Scan using product_pkey on product (cost=0.00..2.69 rows=1 width=5) (actual time=0.004..0.005 rows=0 loops=73)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Nested Loop (cost=305503.56..378400.41 rows=182 width=276) (actual time=38760.014..43063.254 rows=2032 loops=1)
-> Nested Loop Left Join (cost=305503.56..378026.51 rows=182 width=276) (actual time=38626.835..42983.983 rows=2722 loops=1)
Filter: ((public.bugtask.product IS NULL) OR public.product.active)
-> Hash Semi Join (cost=305503.56..377964.46 rows=200 width=276) (actual time=38626.821..42957.350 rows=2728 loops=1)
Hash Cond: (public.bugtask.id = public.bugtask.id)
-> Bitmap Heap Scan on bugtask (cost=8513.27..80064.62 rows=276215 width=276) (actual time=182.746..4598.998 rows=308733 loops=1)
Recheck Cond: ((status = 10) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> BitmapOr (cost=8513.27..8513.27 rows=308734 width=0) (actual time=156.137..156.137 rows=0 loops=1)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..4829.87 rows=184328 width=0) (actual time=103.983..103.983 rows=184491 loops=1)
Index Cond: (status = 10)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..466.01 rows=17680 width=0) (actual time=8.011..8.011 rows=17642 loops=1)
Index Cond: (status = 15)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..1479.89 rows=56464 width=0) (actual time=22.718..22.718 rows=56538 loops=1)
Index Cond: (status = 20)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..794.52 rows=30282 width=0) (actual time=12.404..12.404 rows=30304 loops=1)
Index Cond: (status = 21)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..142.56 rows=5354 width=0) (actual time=2.719..2.719 rows=5351 loops=1)
Index Cond: (status = 22)
-> Bitmap Index Scan on bugtask__status__idx (cost=0.00..386.11 rows=14627 width=0) (actual time=6.288..6.288 rows=14653 loops=1)
Index Cond: (status = 25)
-> Hash (cost=295746.16..295746.16 rows=99531 width=4) (actual time=38118.466..38118.466 rows=29835 loops=1)
-> HashAggregate (cost=293755.54..294750.85 rows=99531 width=4) (actual time=38081.451..38099.894 rows=29835 loops=1)
-> Nested Loop (cost=142973.14..293506.71 rows=99531 width=4) (actual time=15019.216..37979.238 rows=84427 loops=1)
-> Hash Join (cost=142973.14..256158.69 rows=75294 width=4) (actual time=15019.177..23263.791 rows=32134 loops=1)
Hash Cond: (bugmessage.message = message.id)
-> Seq Scan on bugmessage (cost=0.00..70798.85 rows=3027910 width=8) (actual time=7.042..3248.033 rows=3026226 loops=1)
Filter: (index > 0)
-> Hash (cost=142031.96..142031.96 rows=75294 width=4) (actual time=15011.968..15011.968 rows=75175 loops=1)
-> Bitmap Heap Scan on message (cost=1205.51..142031.96 rows=75294 width=4) (actual time=129.011..14917.650 rows=75175 loops=1)
Recheck Cond: (owner = 100)
-> Bitmap Index Scan on message_owner_idx (cost=0.00..1186.69 rows=75294 width=0) (actual time=115.022..115.022 rows=75175 loops=1)
Index Cond: (owner = 100)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..0.48 rows=1 width=8) (actual time=0.272..0.455 rows=3 loops=32134)
Index Cond: (public.bugtask.bug = bugmessage.bug)
-> Index Scan using product_pkey on product (cost=0.00..0.30 rows=1 width=5) (actual time=0.007..0.007 rows=0 loops=2728)
Index Cond: (public.bugtask.product = public.product.id)
Filter: public.product.active
-> Index Scan using bug_pkey on bug (cost=0.00..2.04 rows=1 width=4) (actual time=0.027..0.027 rows=1 loops=2722)
Index Cond: (public.bug.id = public.bugtask.bug)
Filter: ((public.bug.duplicateof IS NULL) AND (NOT public.bug.private))
-> Index Scan using bug_pkey on bug (cost=0.00..5.39 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=2119)
Index Cond: (public.bug.id = public.bugtask.bug)
Total runtime: 62125.406 ms
(93 rows)
runtime hot is:
Aggregate (cost=467408.94..467408.95 rows=1 width=0) (actual time=7239.114..7239.114 rows=1 loops=1) |
|
| 2011-05-04 14:45:33 |
Launchpad QA Bot |
launchpad: milestone |
|
11.05 |
|
| 2011-05-04 14:45:33 |
Launchpad QA Bot |
launchpad: assignee |
|
Robert Collins (lifeless) |
|
| 2011-05-04 14:45:35 |
Launchpad QA Bot |
tags |
lp-bugs qa-ok timeout |
lp-bugs qa-needstesting timeout |
|
| 2011-05-04 22:19:51 |
Robert Collins |
tags |
lp-bugs qa-needstesting timeout |
lp-bugs qa-ok timeout |
|
| 2011-05-06 17:03:36 |
Curtis Hovey |
launchpad: status |
Fix Committed |
Fix Released |
|
