2011-03-08 23:47:15 |
Robert Collins |
description |
Another search timeout, but not high-offset this time.
29 SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_close ... $INT AND Bug.private = FALSE ORDER BY BugTask.importance DESC, BugTask.id LIMIT $INT OFFSET $INT:
GET: 29 Robots: 0 Local: 0
29 https://bugs.launchpad.net/ubuntu/+bugs (Distribution:+bugs)
OOPS-1892A158, OOPS-1892B1957, OOPS-1892B587, OOPS-1892C2069, OOPS-1892D1181 |
Another search timeout, but not high-offset this time.
29 SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_close ... $INT AND Bug.private = FALSE ORDER BY BugTask.importance DESC, BugTask.id LIMIT $INT OFFSET $INT:
GET: 29 Robots: 0 Local: 0
29 https://bugs.launchpad.net/ubuntu/+bugs (Distribution:+bugs)
OOPS-1892A158, OOPS-1892B1957, OOPS-1892B587, OOPS-1892C2069, OOPS-1892D1181
Branch: launchpad-rev-12515
Revno: 12515
SQL time: 16970 ms
Non-sql time: 698 ms
Total time: 17668 ms
Statement Count: 21
QUERY_STRING: field.searchtext=&orderby=-importance&assignee_option=any&field.assignee=&field.bug_reporter=&fie ... ed=&field.tag=&field.has_cve.used=&field.has_no_package.used=&search=Search&field.status:list=New
REMOTE_ADDR: 91.189.89.30
REQUEST_METHOD: GET
SCRIPT_NAME:
SERVER_NAME: soybean
SERVER_PORT: 9031
SERVER_PROTOCOL: HTTP/1.0
SERVER_SOFTWARE: zope.server.http (HTTP)
assignee_option: any
field.assignee:
field.bug_commenter:
field.bug_contact:
field.bug_reporter:
field.component: 3
field.component-empty-marker: 1
field.has_cve.used:
field.has_no_package.used:
field.has_patch.used:
field.omit_dupes: on
field.omit_dupes.used:
field.searchtext:
field.status: [u'New']
field.status_upstream-empty-marker: 1
field.subscriber:
field.tag:
orderby: -importance
search: Search
18. 2213 14919ms 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 BugTask
JOIN Bug ON BugTask.bug = Bug.id,
SourcePackagePublishingHistory,
SourcePackageRelease
WHERE Bug.id = BugTask.bug
AND BugTask.distribution = 1
AND ((BugTask.status = 10))
AND Bug.duplicateof IS NULL
AND BugTask.sourcepackagename = SourcePackageRelease.sourcepackagename
AND SourcePackageRelease.id = SourcePackagePublishingHistory.sourcepackagerelease
AND SourcePackagePublishingHistory.distroseries = 106
AND SourcePackagePublishingHistory.archive IN (1,
534)
AND SourcePackagePublishingHistory.component IN ('3')
AND SourcePackagePublishingHistory.status = 2
AND Bug.private = FALSE
ORDER BY BugTask.importance DESC, BugTask.id LIMIT 76
OFFSET 0
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.00..13405.41 rows=76 width=1017) (actual time=16037.847..149141.010 rows=76 loops=1)
-> Nested Loop (cost=0.00..16735776.75 rows=94881 width=1017) (actual time=16037.845..149140.888 rows=76 loops=1)
-> Nested Loop (cost=0.00..16476819.05 rows=94881 width=276) (actual time=6269.181..149113.784 rows=761 loops=1)
-> Nested Loop (cost=0.00..672139.10 rows=31019067 width=280) (actual time=9.959..134427.302 rows=1276160 loops=1)
-> Index Scan Backward using bugtask_importance_idx on bugtask (cost=0.00..116380.60 rows=110413 width=276) (actual time=9.909..2039.202 rows=3788 loops=1)
Filter: ((distribution = 1) AND (status = 10))
-> Index Scan using sourcepackagerelease_sourcepackagename_idx on sourcepackagerelease (cost=0.00..4.77 rows=21 width=8) (actual time=0.508..34.643 rows=337 loops=3788)
Index Cond: (sourcepackagerelease.sourcepackagename = bugtask.sourcepackagename)
-> Index Scan using securesourcepackagepublishinghistory_sourcepackagerelease_idx on sourcepackagepublishinghistory (cost=0.00..0.50 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=1276160)
Index Cond: (sourcepackagepublishinghistory.sourcepackagerelease = sourcepackagerelease.id)
Filter: ((sourcepackagepublishinghistory.archive = ANY ('{1,534}'::integer[])) AND (sourcepackagepublishinghistory.distroseries = 106) AND (sourcepackagepublishinghistory.component = 3) AND (sourcepackagepublishinghistory.status = 2))
-> Index Scan using bug_pkey on bug (cost=0.00..2.72 rows=1 width=741) (actual time=0.033..0.033 rows=0 loops=761)
Index Cond: (bug.id = bugtask.bug)
Filter: ((bug.duplicateof IS NULL) AND (NOT bug.private))
Total runtime: 149141.444 ms
(15 rows) |
|