gistfile1.txt

 Sort  (cost=45223.48..45223.91 rows=174 width=70)
   Sort Key: (sum(t.listen_count)) DESC
   ->  GroupAggregate  (cost=45213.09..45217.00 rows=174 width=70)
         Group Key: q.recording_mbid, r.name, ac.name
         ->  Sort  (cost=45213.09..45213.52 rows=174 width=66)
               Sort Key: q.recording_mbid, r.name, ac.name
               ->  Nested Loop  (cost=26654.58..45206.61 rows=174 width=66)
                     ->  Nested Loop  (cost=26654.15..45127.91 rows=174 width=44)
                           ->  Hash Join  (cost=26653.59..43660.13 rows=174 width=36)
                                 Hash Cond: (t.recording_mbid = q.recording_mbid)
                                 ->  Bitmap Heap Scan on tracks_of_the_year t  (cost=129.46..17121.17 rows=5648 width=20)
                                       Recheck Cond: (user_name = ANY ('{Damselfish,mr_monkey,alastairp}'::text[]))
                                       ->  Bitmap Index Scan on tracks_of_the_year_ndx_user_name  (cost=0.00..128.05 rows=5648 width=0)
                                             Index Cond: (user_name = ANY ('{Damselfish,mr_monkey,alastairp}'::text[]))
                                 ->  Hash  (cost=26453.52..26453.52 rows=5649 width=16)
                                  ->  Hash  (cost=26453.52..26453.52 rows=5649 width=16)
                                       ->  Subquery Scan on q  (cost=19723.63..26453.52 rows=5649 width=16)
                                             ->  HashSetOp Except  (cost=19723.63..26397.03 rows=5649 width=20)
                                                   ->  Append  (cost=19723.63..26378.20 rows=7532 width=20)
                                                         ->  HashAggregate  (cost=19723.63..19780.12 rows=5649 width=20)
                                                               Group Key: t_1.recording_mbid
                                                               ->  Append  (cost=43.15..19709.50 rows=5649 width=16)
                                                                     ->  Bitmap Heap Scan on tracks_of_the_year t_1  (cost=43.15..6541.59 rows=1883 width=16)
                                                                           Recheck Cond: (user_name = 'Damselfish'::text)
                                                                           ->  Bitmap Index Scan on tracks_of_the_year_ndx_user_name  (cost=0.00..42.68 rows=1883 width=0)
                                                                                 Index Cond: (user_name= 'Damselfish'::text)
                                                                     ->  Bitmap Heap Scan on tracks_of_the_year t_2  (cost=43.15..6541.59 rows=1883 width=16)
                                                                     Recheck Cond: (user_name = 'mr_monkey'::text)
                                                                           ->  Bitmap Index Scan on tracks_of_the_year_ndx_user_name  (cost=0.00..42.68 rows=1883 width=0)
                                                                                 Index Cond: (user_name= 'mr_monkey'::text)
                                                                     ->  Bitmap Heap Scan on tracks_of_the_year t_3  (cost=43.15..6541.59 rows=1883 width=16)
                                                                           Recheck Cond: (user_name = 'alastairp'::text)
                                                                           ->  Bitmap Index Scan on tracks_of_the_year_ndx_user_name  (cost=0.00..42.68 rows=1883 width=0)
                                                                                 Index Cond: (user_name= 'alastairp'::text)
                                                         ->  Subquery Scan on "*SELECT* 4"  (cost=43.15..6560.42 rows=1883 width=20)
                                                               ->  Bitmap Heap Scan on tracks_of_the_year t_4  (cost=43.15..6541.59 rows=1883 width=16)
                                                                     Recheck Cond: (user_name = 'rob'::text)
                                                                     ->  Bitmap Index Scan on tracks_of_the_year_ndx_user_name  (cost=0.00..42.68 rows=1883 width=0)
                                                                           Index Cond: (user_name = 'rob)::text)
                           ->  Index Scan using recording_idx_gid on recording r  (cost=0.56..8.44 rows=1 width=40)
                                 Index Cond: (gid = t.recording_mbid)        
                        ->  Index Scan using artist_credit_pkey on artist_credit ac  (cost=0.43..0.45 rows=1 width=30)
                           Index Cond: (id = r.artist_credit)