Comment 12 for bug 276950

The slow query in the updated description is slow on qastaging:

SELECT PackageUpload.archive, PackageUpload.changesfile, PackageUpload.date_created, PackageUpload.distroseries, PackageUpload.id, PackageUpload.pocket, PackageUpload.signing_key, PackageUpload.status FROM PackageUpload WHERE packageupload.distroseries = 103 AND packageupload.archive IN (1, 534) AND packageupload.status IN (0) ORDER BY PackageUpload.id DESC LIMIT 31 OFFSET 0;
 archive | changesfile | date_created | distroseries | id | pocket | signing_key | status
---------+-------------+----------------------------+--------------+---------+--------+-------------+--------
       1 | 57505775 | 2010-10-12 15:35:10.566515 | 103 | 2153607 | 30 | 5446 | 0
(1 row)

Time: 1625.788 ms

-----------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit (cost=0.00..824.59 rows=31 width=36) (actual time=0.575..1627.040 rows=1 loops=1)
   -> Index Scan Backward using distroreleasequeue_pkey on packageupload (cost=0.00..81368.69 rows=3059 width=36) (actual time=0.571..1627.035 rows=1 loops=1)
         Filter: ((archive = ANY ('{1,534}'::integer[])) AND (distroseries = 103) AND (status = 0))
 Total runtime: 1627.106 ms
(4 rows)