SET
SET
SET
                                                                              QUERY PLAN                                                                               
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Seq Scan on jtemp1c37l3b_baseline_windows_after_inclusion  (cost=0.00..1601719821.59 rows=252622 width=265) (actual time=721.931..5424987.346 rows=138972 loops=1)
   Filter: (SubPlan 1)
   Rows Removed by Filter: 366272
   Buffers: shared hit=624493395
   SubPlan 1
     ->  Subquery Scan on r  (cost=0.00..3170.16 rows=1 width=0) (actual time=10.731..10.731 rows=0 loops=505244)
           Buffers: shared hit=624484208
           ->  Group  (cost=0.00..3170.15 rows=1 width=46) (actual time=10.730..10.730 rows=0 loops=505244)
                 Group Key: jtemp1c37l3b_baseline_windows_with_collections.uuid
                 Buffers: shared hit=624484208
                 ->  Seq Scan on jtemp1c37l3b_baseline_windows_with_collections  (cost=0.00..3170.15 rows=1 width=46) (actual time=10.724..10.724 rows=0 loops=505244)
                       Filter: (jtemp1c37l3b_baseline_windows_after_inclusion.uuid = uuid)
                       Rows Removed by Filter: 119859
                       Buffers: shared hit=624484208
 Settings: effective_cache_size = '36GB', random_page_cost = '1', work_mem = '4GB'
 Planning Time: 0.872 ms
 JIT:
   Functions: 12
   Options: Inlining true, Optimization true, Expressions true, Deforming true
   Timing: Generation 3.531 ms, Inlining 113.077 ms, Optimization 408.591 ms, Emission 160.142 ms, Total 685.341 ms
 Execution Time: 5425095.601 ms
(21 rows)

