# Pastebin ZA7Wsyz4
acousticbrainz_big=> explain analyze SELECT *
acousticbrainz_big->             FROM lowlevel
acousticbrainz_big->             WHERE EXISTS (
acousticbrainz_big(>                 SELECT musicbrainz.recording.gid 
acousticbrainz_big(>                 FROM musicbrainz.recording
acousticbrainz_big(>                 WHERE musicbrainz.recording.gid = lowlevel.gid
acousticbrainz_big(>             )
acousticbrainz_big->             LIMIT 10000;


                                                                     QUERY PLAN                                                                      
-----------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.56..16519.67 rows=10000 width=78) (actual time=42.482..111458.385 rows=10000 loops=1)
   ->  Nested Loop  (cost=0.56..22316506.60 rows=13509513 width=78) (actual time=42.480..111448.308 rows=10000 loops=1)
         ->  Seq Scan on lowlevel  (cost=0.00..315222.13 rows=13509513 width=78) (actual time=9.699..29.388 rows=11068 loops=1)
         ->  Index Only Scan using recording_idx_gid on recording  (cost=0.56..1.63 rows=1 width=16) (actual time=10.059..10.059 rows=1 loops=11068)
               Index Cond: (gid = lowlevel.gid)
               Heap Fetches: 10000
 Planning Time: 645.264 ms
 Execution Time: 111466.768 ms
(8 rows)

acousticbrainz_big=> 
acousticbrainz_big=> 
acousticbrainz_big=> explain analyze             SELECT *
acousticbrainz_big->               FROM lowlevel
acousticbrainz_big->         INNER JOIN musicbrainz.recording
acousticbrainz_big->                 ON musicbrainz.recording.gid = lowlevel.gid
acousticbrainz_big->              LIMIT 10000;
                                                                  QUERY PLAN                                                                  
----------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.56..16519.67 rows=10000 width=141) (actual time=0.090..33.235 rows=10000 loops=1)
   ->  Nested Loop  (cost=0.56..22316506.60 rows=13509513 width=141) (actual time=0.087..32.646 rows=10000 loops=1)
         ->  Seq Scan on lowlevel  (cost=0.00..315222.13 rows=13509513 width=78) (actual time=0.045..0.905 rows=11068 loops=1)
         ->  Index Scan using recording_idx_gid on recording  (cost=0.56..1.63 rows=1 width=63) (actual time=0.002..0.002 rows=1 loops=11068)
               Index Cond: (gid = lowlevel.gid)
 Planning Time: 16.642 ms
 Execution Time: 33.774 ms
(7 rows)