SET
SET
SET
                                                                                     QUERY PLAN                                                                                      
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=23792.74..65970.73 rows=138972 width=265) (actual time=529.799..1016.839 rows=138972 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   Buffers: shared hit=13691, temp read=11835 written=11844
   ->  Hash Join  (cost=22792.74..51073.53 rows=57905 width=265) (actual time=440.268..848.196 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.015..111.050 rows=168415 loops=3)
               Buffers: shared hit=9187
         ->  Hash  (cost=19833.59..19833.59 rows=138972 width=46) (actual time=439.476..439.477 rows=138972 loops=3)
               Buckets: 65536  Batches: 4  Memory Usage: 3195kB
               Buffers: shared hit=4318, temp read=2889 written=5430
               ->  Group  (cost=17749.01..18443.87 rows=138972 width=46) (actual time=247.387..369.873 rows=138972 loops=3)
                     Group Key: jtemp1c37l3b_baseline_windows_with_collections.uuid
                     Buffers: shared hit=4318, temp read=2889 written=2898
                     ->  Sort  (cost=17749.01..18096.44 rows=138972 width=46) (actual time=247.383..314.147 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.924 rows=138972 loops=3)
                                 Buffers: shared hit=4299
 Settings: effective_cache_size = '36GB', random_page_cost = '2'
 Planning Time: 1.068 ms
 Execution Time: 1033.455 ms
(26 rows)

