SET
SET
SET
                                                                                     QUERY PLAN                                                                                      
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=23181.74..65359.73 rows=138972 width=265) (actual time=521.690..968.660 rows=138972 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   Buffers: shared hit=13691, temp read=11837 written=11846
   ->  Hash Join  (cost=22181.74..50462.53 rows=57905 width=265) (actual time=521.335..916.623 rows=46324 loops=3)
         Hash Cond: (jtemp1c37l3b_baseline_windows_after_inclusion.uuid = jtemp1c37l3b_baseline_windows_with_collections.uuid)
         Buffers: shared hit=13691, temp read=11837 written=11846
         ->  Parallel Seq Scan on jtemp1c37l3b_baseline_windows_after_inclusion  (cost=0.00..11292.18 rows=210518 width=265) (actual time=0.018..109.555 rows=168415 loops=3)
               Buffers: shared hit=9187
         ->  Hash  (cost=19222.59..19222.59 rows=138972 width=46) (actual time=520.388..520.388 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=294.859..439.427 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=294.855..373.642 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.825 rows=138972 loops=3)
                                 Buffers: shared hit=4299
 Settings: effective_cache_size = '36GB', random_page_cost = '1'
 Planning Time: 1.101 ms
 Execution Time: 981.195 ms
(26 rows)

