SET
SET
SET
                                                                                     QUERY PLAN                                                                                      
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=23181.74..65359.73 rows=138972 width=265) (actual time=508.624..980.756 rows=138972 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   Buffers: shared hit=13691, temp read=11836 written=11845
   ->  Hash Join  (cost=22181.74..50462.53 rows=57905 width=265) (actual time=495.025..905.924 rows=46324 loops=3)
         Hash Cond: (jtemp1c37l3b_baseline_windows_after_inclusion.uuid = jtemp1c37l3b_baseline_windows_with_collections.uuid)
         Buffers: shared hit=13691, temp read=11836 written=11845
         ->  Parallel Seq Scan on jtemp1c37l3b_baseline_windows_after_inclusion  (cost=0.00..11292.18 rows=210518 width=265) (actual time=0.017..108.942 rows=168415 loops=3)
               Buffers: shared hit=9187
         ->  Hash  (cost=19222.59..19222.59 rows=138972 width=46) (actual time=494.128..494.129 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=277.990..416.382 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=277.986..353.398 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.028..35.561 rows=138972 loops=3)
                                 Buffers: shared hit=4299
 Settings: effective_cache_size = '36GB', random_page_cost = '1'
 Planning Time: 1.179 ms
 Execution Time: 994.845 ms
(26 rows)

