SET
SET
SET
                                                                                     QUERY PLAN                                                                                      
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=23181.74..65359.73 rows=138972 width=265) (actual time=517.581..939.479 rows=138972 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   Buffers: shared hit=13691, temp read=11835 written=11844
   ->  Hash Join  (cost=22181.74..50462.53 rows=57905 width=265) (actual time=520.180..889.117 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.022..109.478 rows=168415 loops=3)
               Buffers: shared hit=9187
         ->  Hash  (cost=19222.59..19222.59 rows=138972 width=46) (actual time=519.229..519.230 rows=138972 loops=3)
               Buckets: 65536  Batches: 4  Memory Usage: 3195kB
               Buffers: shared hit=4318, temp read=2889 written=5430
               ->  Group  (cost=17138.01..17832.87 rows=138972 width=46) (actual time=293.482..438.080 rows=138972 loops=3)
                     Group Key: jtemp1c37l3b_baseline_windows_with_collections.uuid
                     Buffers: shared hit=4318, temp read=2889 written=2898
                     ->  Sort  (cost=17138.01..17485.44 rows=138972 width=46) (actual time=293.478..372.419 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.030..37.728 rows=138972 loops=3)
                                 Buffers: shared hit=4299
 Settings: effective_cache_size = '36GB', random_page_cost = '1'
 Planning Time: 1.080 ms
 Execution Time: 950.525 ms
(26 rows)

