SET
SET
SET
                                                                               QUERY PLAN                                                                                
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Hash Join  (cost=7686.74..23252.46 rows=138972 width=265) (actual time=152.636..590.517 rows=138972 loops=1)
   Hash Cond: (jtemp1c37l3b_baseline_windows_after_inclusion.uuid = jtemp1c37l3b_baseline_windows_with_collections.uuid)
   Buffers: shared hit=10620
   ->  Seq Scan on jtemp1c37l3b_baseline_windows_after_inclusion  (cost=0.00..14239.44 rows=505244 width=265) (actual time=0.024..110.964 rows=505244 loops=1)
         Buffers: shared hit=9187
   ->  Hash  (cost=5949.59..5949.59 rows=138972 width=46) (actual time=151.587..151.587 rows=138972 loops=1)
         Buckets: 262144  Batches: 1  Memory Usage: 12711kB
         Buffers: shared hit=1433
         ->  HashAggregate  (cost=3170.15..4559.87 rows=138972 width=46) (actual time=79.794..108.616 rows=138972 loops=1)
               Group Key: jtemp1c37l3b_baseline_windows_with_collections.uuid
               Buffers: shared hit=1433
               ->  Seq Scan on jtemp1c37l3b_baseline_windows_with_collections  (cost=0.00..2822.72 rows=138972 width=46) (actual time=0.020..18.391 rows=138972 loops=1)
                     Buffers: shared hit=1433
 Settings: effective_cache_size = '36GB', random_page_cost = '1', work_mem = '4GB'
 Planning Time: 0.623 ms
 Execution Time: 609.053 ms
(16 rows)

