Launchpad itself

  1. Bug #276950
  2. Comment #18

Comment 18 for bug 276950

Revision history for this message
Robert Collins (lifeless) wrote :

slow query uses

 Limit (cost=0.00..1843.12 rows=31 width=36) (actual time=248.269..25253.418 rows=1 loops=1)
   -> Index Scan Backward using distroreleasequeue_pkey on packageupload (cost=0.00..93404.35 rows=1571 width=36) (actual time=248.266..25253.412 rows=1 loops=1)
         Filter: ((archive = ANY ('{1,534}'::integer[])) AND (distroseries = 104) AND (status = 0))
 Total runtime: 25253.503 ms

at the moment. 1.6 seconds hot.