SET
SET
SET
                                                                                     QUERY PLAN                                                                                      
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=25014.74..67192.73 rows=138972 width=265) (actual time=312.938..990.092 rows=138972 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   Buffers: shared hit=13691, temp read=11835 written=11844
   ->  Hash Join  (cost=24014.74..52295.53 rows=57905 width=265) (actual time=455.657..838.207 rows=46324 loops=3)
         Hash Cond: (jtemp1c37l3b_baseline_windows_after_inclusion.uuid = jtemp1c37l3b_baseline_windows_with_collections.uuid)
         Buffers: shared hit=13691, temp read=11835 written=11844
         ->  Parallel Seq Scan on jtemp1c37l3b_baseline_windows_after_inclusion  (cost=0.00..11292.18 rows=210518 width=265) (actual time=0.016..106.590 rows=168415 loops=3)
               Buffers: shared hit=9187
         ->  Hash  (cost=21055.59..21055.59 rows=138972 width=46) (actual time=454.815..454.815 rows=138972 loops=3)
               Buckets: 65536  Batches: 4  Memory Usage: 3195kB
               Buffers: shared hit=4318, temp read=2889 written=5430
               ->  Group  (cost=18971.01..19665.87 rows=138972 width=46) (actual time=247.692..379.475 rows=138972 loops=3)
                     Group Key: jtemp1c37l3b_baseline_windows_with_collections.uuid
                     Buffers: shared hit=4318, temp read=2889 written=2898
                     ->  Sort  (cost=18971.01..19318.44 rows=138972 width=46) (actual time=247.688..319.338 rows=138972 loops=3)
                           Sort Key: jtemp1c37l3b_baseline_windows_with_collections.uuid
                           Sort Method: external merge  Disk: 7704kB
                           Worker 0:  Sort Method: external merge  Disk: 7704kB
                           Worker 1:  Sort Method: external merge  Disk: 7704kB
                           Buffers: shared hit=4318, temp read=2889 written=2898
                           ->  Seq Scan on jtemp1c37l3b_baseline_windows_with_collections  (cost=0.00..2822.72 rows=138972 width=46) (actual time=0.026..31.802 rows=138972 loops=3)
                                 Buffers: shared hit=4299
 Settings: effective_cache_size = '36GB'
 Planning Time: 0.618 ms
 Execution Time: 1006.396 ms
(26 rows)

