SET
SET
SET
                                                                                   QUERY PLAN                                                                                    
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Hash Join  (cost=22181.74..77439.57 rows=252622 width=265) (actual time=1502.006..2419.247 rows=138972 loops=1)
   Hash Cond: (jtemp1c37l3b_baseline_windows_after_inclusion.uuid = jtemp1c37l3b_baseline_windows_with_collections.uuid)
   Buffers: shared hit=3 read=10620, temp read=8216 written=8210
   ->  Seq Scan on jtemp1c37l3b_baseline_windows_after_inclusion  (cost=0.00..14239.44 rows=505244 width=265) (actual time=46.916..403.169 rows=505244 loops=1)
         Buffers: shared read=9187
   ->  Hash  (cost=19222.59..19222.59 rows=138972 width=46) (actual time=1454.294..1454.294 rows=138972 loops=1)
         Buckets: 65536  Batches: 4  Memory Usage: 3195kB
         Buffers: shared hit=3 read=1433, temp read=960 written=1804
         ->  Group  (cost=17138.01..17832.87 rows=138972 width=46) (actual time=1334.627..1407.488 rows=138972 loops=1)
               Group Key: jtemp1c37l3b_baseline_windows_with_collections.uuid
               Buffers: shared hit=3 read=1433, temp read=960 written=960
               ->  Sort  (cost=17138.01..17485.44 rows=138972 width=46) (actual time=1334.622..1368.945 rows=138972 loops=1)
                     Sort Key: jtemp1c37l3b_baseline_windows_with_collections.uuid
                     Sort Method: external sort  Disk: 7680kB
                     Buffers: shared hit=3 read=1433, temp read=960 written=960
                     ->  Seq Scan on jtemp1c37l3b_baseline_windows_with_collections  (cost=0.00..2822.72 rows=138972 width=46) (actual time=11.635..510.093 rows=138972 loops=1)
                           Buffers: shared read=1433
 Planning time: 38.363 ms
 Execution time: 2437.721 ms
(19 rows)

