(thats with disk IO, its 8-8.5seconds when repeated.

plan for it:

                                                                                                                                                                                                           QUERY PLAN                                                                                                                                                                                                           
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1261.93..1261.94 rows=1 width=0) (actual time=8106.454..8106.455 rows=1 loops=1)
   ->  Unique  (cost=1261.85..1261.90 rows=2 width=830) (actual time=7895.168..8106.442 rows=1 loops=1)
         ->  Sort  (cost=1261.85..1261.85 rows=2 width=830) (actual time=7895.165..7903.721 rows=1382 loops=1)
               Sort Key: distributionsourcepackagecache.archive, distributionsourcepackagecache.binpkgdescriptions, distributionsourcepackagecache.binpkgnames, distributionsourcepackagecache.binpkgsummaries, distributionsourcepackagecache.changelog, distributionsourcepackagecache.distribution, distributionsourcepackagecache.id, distributionsourcepackagecache.name, distributionsourcepackagecache.sourcepackagename
               Sort Method:  quicksort  Memory: 761kB
               ->  Nested Loop  (cost=0.00..1261.84 rows=2 width=830) (actual time=1.103..7686.693 rows=1382 loops=1)
                     ->  Nested Loop  (cost=0.00..649.04 rows=1 width=8) (actual time=0.195..364.537 rows=1917 loops=1)
                           ->  Nested Loop  (cost=0.00..648.76 rows=1 width=4) (actual time=0.180..335.799 rows=1917 loops=1)
                                 ->  Nested Loop  (cost=0.00..648.21 rows=1 width=4) (actual time=0.161..299.414 rows=1917 loops=1)
                                       Join Filter: (distroarchseries.distroseries = distroseries.id)
                                       ->  Seq Scan on distroseries  (cost=0.00..2.45 rows=1 width=4) (actual time=0.031..0.077 rows=6 loops=1)
                                             Filter: ((releasestatus <> 6) AND (distribution = 1))
                                       ->  Nested Loop  (cost=0.00..645.32 rows=35 width=8) (actual time=0.058..47.401 rows=2327 loops=6)
                                             ->  Nested Loop  (cost=0.00..635.52 rows=35 width=8) (actual time=0.052..33.313 rows=2327 loops=6)
                                                   ->  Nested Loop  (cost=0.00..620.13 rows=35 width=4) (actual time=0.041..12.791 rows=2327 loops=6)
                                                         ->  Index Scan using binarypackagename_name_key on binarypackagename  (cost=0.00..6.29 rows=1 width=4) (actual time=0.016..0.017 rows=1 loops=6)
                                                               Index Cond: (name = 'mplayer'::text)
                                                         ->  Index Scan using binarypackagerelease_binarypackagename_key on binarypackagerelease  (cost=0.00..610.97 rows=230 width=8) (actual time=0.021..8.937 rows=2327 loops=6)
                                                               Index Cond: (binarypackagerelease.binarypackagename = binarypackagename.id)
                                                   ->  Index Scan using binarypackagebuild_pkey on binarypackagebuild  (cost=0.00..0.43 rows=1 width=12) (actual time=0.005..0.006 rows=1 loops=13962)
                                                         Index Cond: (binarypackagebuild.id = binarypackagerelease.build)
                                             ->  Index Scan using distroarchrelease_pkey on distroarchseries  (cost=0.00..0.27 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=13962)
                                                   Index Cond: (distroarchseries.id = binarypackagebuild.distro_arch_series)
                                 ->  Index Scan using sourcepackagerelease_pkey on sourcepackagerelease  (cost=0.00..0.53 rows=1 width=8) (actual time=0.011..0.013 rows=1 loops=1917)

                                       Index Cond: (sourcepackagerelease.id = binarypackagebuild.source_package_release)
                           ->  Index Scan using sourcepackagename_pkey on sourcepackagename  (cost=0.00..0.27 rows=1 width=4) (actual time=0.007..0.010 rows=1 loops=1917)
                                 Index Cond: (sourcepackagename.id = sourcepackagerelease.sourcepackagename)
                     ->  Index Scan using distributionsourcepackagecache__distribution__sourcepackagename on distributionsourcepackagecache  (cost=0.00..612.79 rows=1 width=830) (actual time=1.340..3.815 rows=1 loops=1917)
                           Index Cond: (distributionsourcepackagecache.sourcepackagename = sourcepackagerelease.sourcepackagename)
                           Filter: (distributionsourcepackagecache.archive = ANY ('{1,534}'::integer[]))
 Total runtime: 8106.731 ms