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
slow query uses
Limit (cost=0.00..1843.12 rows=31 width=36) (actual time=248. 269..25253. 418 rows=1 loops=1) eue_pkey on packageupload (cost=0. 00..93404. 35 rows=1571 width=36) (actual time=248. 266..25253. 412 rows=1 loops=1) '::integer[ ])) AND (distroseries = 104) AND (status = 0))
-> Index Scan Backward using distroreleasequ
Filter: ((archive = ANY ('{1,534}
Total runtime: 25253.503 ms
at the moment. 1.6 seconds hot.