Person:+branches timeout: sometimes-slow bug-branch link query
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Abel Deuring |
Bug Description
OOPS-1916L440
OOPS-1923D667
https:/
User: Martin Pool
Branch: launchpad-rev-12696
Revno: 12696
SQL time: 10073 ms
Non-sql time: 1666 ms
Total time: 11739 ms
Statement Count: 78
5137ms SQL-launchpad-
SELECT DISTINCT BugBranch.branch
FROM Bug,
BugBranch
WHERE BugBranch.branch IN (451217, 451208, 451207, 451206, 310641, 450226, 449792, 449762, 449192, 449190, 444685, 439423, 436128, 421710, 317004, 374978, 404904, 412011, 411115, 245099, 400223, 377965, 373979, 372939, 372691, 362490, 362566, 362564, 361252, 359795, 359423, 357633, 355943, 348553,
322307, 319438, 316198, 316197, 315929, 310090, 308190, 305716, 305524, 296541, 294443, 245102, 275463, 273980, 40682, 34254, 175815, 152799, 115607, 81913, 81670, 62623, 52209, 42949, 39318, 38448, 37654, 12332, 30797, 21766, 13518, 16918, 12486, 10605, 10457, 5670, 9447, 7882, 4233, 3674, 2510, 2469)
AND Bug.id = BugBranch.bug
AND (Bug.private = FALSE
OR Bug.id IN
(SELECT BugSubscription.bug
FROM BugSubscription,
WHERE TeamParticipati
AND TeamParticipati
Related branches
- Aaron Bentley (community): Approve
-
Diff: 29 lines (+5/-3)1 file modifiedlib/lp/bugs/model/bugbranch.py (+5/-3)
description: | updated |
Changed in launchpad: | |
assignee: | nobody → Abel Deuring (adeuring) |
status: | Triaged → In Progress |
tags: |
added: qa-ok removed: qa-needstesting |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
tags: | added: critical-analysis |
-------
HashAggregate (cost=196060.
-> Hash Join (cost=184038.
Hash Cond: (bugbranch.bug = bug.id)
-> Seq Scan on bugbranch (cost=0.00..9341.04 rows=97 width=8) (actual time=1.622..99.300 rows=18 loops=1)
-> Hash (cost=172795.
-> Seq Scan on bug (cost=2964.
Total runtime: 5333.678 ms