Launchpad itself

timeout on Bugtask:+Index in subscription lookups

Bug #1062291 reported by Andreas Hasenack
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
Steve Kowalik

Related branches

lp://staging/~stevenk/launchpad/no-more-o-n-queries-bug-dupes
William Grant (community): Approve (code)
Diff: 345 lines (+88/-90)
5 files modified
lib/lp/bugs/browser/tests/test_bug_views.py (+25/-10)
lib/lp/bugs/browser/tests/test_bugtask.py (+1/-1)
lib/lp/bugs/model/bug.py (+25/-22)
lib/lp/bugs/model/personsubscriptioninfo.py (+36/-56)
lib/lp/bugs/model/tests/test_personsubscriptioninfo.py (+1/-1)
Revision history for this message
Robert Collins (lifeless) wrote :

slow SQL:
                                                                                    QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Unique (cost=159.03..159.04 rows=1 width=763) (actual time=3892.866..3892.888 rows=1 loops=1)
   -> Sort (cost=159.03..159.04 rows=1 width=763) (actual time=3892.864..3892.864 rows=26 loops=1)
         Sort Key: person.name, bugsubscription.person
         Sort Method: quicksort Memory: 38kB
         -> Nested Loop (cost=0.00..159.02 rows=1 width=763) (actual time=709.710..3892.594 rows=26 loops=1)
               -> Nested Loop (cost=0.00..155.07 rows=1 width=32) (actual time=709.665..3892.042 rows=26 loops=1)
                     -> Nested Loop (cost=0.00..105.38 rows=101 width=32) (actual time=0.085..512.618 rows=158602 loops=1)
                           -> Index Scan using teamparticipation_person_idx on teamparticipation (cost=0.00..5.01 rows=2 width=4) (actual time=0.020..0.110 rows=30 loops=1)
                                 Index Cond: (person = 1191103)
                           -> Index Scan using bugsubscription_person_idx on bugsubscription (cost=0.00..49.76 rows=34 width=28) (actual time=0.029..14.230 rows=5287 loops=30)
                                 Index Cond: (person = teamparticipation.team)
                     -> Index Scan using bug_pkey on bug (cost=0.00..0.48 rows=1 width=4) (actual time=0.021..0.021 rows=0 loops=158602)
                           Index Cond: (id = bugsubscription.bug)
                           Filter: ((id = 523896) OR (duplicateof = 523896))
               -> Index Scan using person_pkey on person (cost=0.00..3.93 rows=1 width=735) (actual time=0.014..0.014 rows=1 loops=26)
                     Index Cond: (id = bugsubscription.person)
 Total runtime: 3893.299 ms

Changed in launchpad:
status: New → Triaged
importance: Undecided → Critical
tags: added: bugs timeout
tags: added: subscriptions
William Grant (wgrant)
Changed in launchpad:
assignee: nobody → Steve Kowalik (stevenk)
status: Triaged → In Progress
Revision history for this message
Launchpad QA Bot (lpqabot) wrote :

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

tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
Curtis Hovey (sinzui)
tags: added: qa-ok
removed: qa-needstesting
Richard Harding (rharding)
Changed in launchpad:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.