Subject: RE: Reading execution plan - first row time vs last row time

From: Pecsök Ján <[email-masked]>
Date: Wed, 2 Oct 2024 09:37:07 +0000

Ok, I replaced names of tables and columns and here is the query 

explain (analyze, verbose, settings, format text) create table dm.v_Table6_T_111111111  with (fillfactor = 100, parallel_workers = 20, autovacuum_enabled = false, toast.autovacuum_enabled = false) as select
      VHS.df_v_Table2_key
    , df_Table3_key
    , df_Table4
    , null::varchar as ID3Table5
    , EH.IDTable5
    , EH.ID2Table5
from dm.v_Table1_KT as VHS
left outer join dm.v_Table5 as EH using (df_v_Table5_key, df_Table3_key, df_Table4)
where VHS.df_Table4 = any ('{T}')
    and VHS.df_Table4 = 'T' and VHS.df_Table3_key = 111111111;

Here is the whole explain analyze output

Gather  (cost=1038.49..257627100.42 rows=7943222226 width=104) (actual time=531.925..3673159.806 rows=7943221053 loops=1)
  Output: d_v_Table1.df_v_Table2_key, d_v_Table1.df_Table3_key, ((d_v_Table1.df_Table4)::text), NULL::character varying, d_v_Table5.IDTable5, d_v_Table5.ID2Table5
  Workers Planned: 20
  Workers Launched: 19
  ->  Parallel Hash Left Join  (cost=38.49..158335822.59 rows=397161111 width=104) (actual time=518.375..821507.905 rows=397161053 loops=20)
        Output: d_v_Table1.df_v_Table2_key, d_v_Table1.df_Table3_key, (d_v_Table1.df_Table4)::text, NULL::character varying, d_v_Table5.IDTable5, d_v_Table5.ID2Table5
        Hash Cond: ((d_v_Table1.df_Table3_key = d_v_Table5.df_Table3_key) AND ((d_v_Table1.df_Table4)::text = (d_v_Table5.df_Table4)::text) AND (d_v_Table1.df_v_Table5_key = d_v_Table5.df_v_Table5_key))
        Worker 0:  actual time=479.232..994825.090 rows=483549329 loops=1
        Worker 1:  actual time=511.319..915482.692 rows=438973357 loops=1
        Worker 2:  actual time=490.026..884166.396 rows=423783274 loops=1
        Worker 3:  actual time=505.446..853760.405 rows=416740827 loops=1
        Worker 4:  actual time=495.666..610957.691 rows=308493508 loops=1
        Worker 5:  actual time=493.286..805251.756 rows=391590847 loops=1
        Worker 6:  actual time=484.996..870623.647 rows=423495770 loops=1
        Worker 7:  actual time=491.372..869772.251 rows=409543751 loops=1
        Worker 8:  actual time=509.778..975673.057 rows=466240557 loops=1
        Worker 9:  actual time=487.497..784084.767 rows=384952613 loops=1
        Worker 10:  actual time=482.364..935913.468 rows=452849913 loops=1
        Worker 11:  actual time=486.084..1015666.135 rows=484017539 loops=1
        Worker 12:  actual time=973.434..978876.855 rows=474565720 loops=1
        Worker 13:  actual time=488.912..765758.744 rows=378988284 loops=1
        Worker 14:  actual time=492.144..668396.602 rows=327623246 loops=1
        Worker 15:  actual time=488.074..755495.224 rows=370513041 loops=1
        Worker 16:  actual time=484.712..892311.793 rows=424321105 loops=1
        Worker 17:  actual time=495.549..917640.790 rows=440464209 loops=1
        Worker 18:  actual time=499.909..927038.259 rows=442512512 loops=1
        ->  Parallel Append  (cost=0.00..153854806.14 rows=397161112 width=22) (actual time=32.764..468874.933 rows=397161053 loops=20)
              Worker 0:  actual time=1.017..557603.321 rows=483549329 loops=1
              Worker 1:  actual time=22.316..525244.352 rows=438973357 loops=1
              Worker 2:  actual time=8.004..505384.160 rows=423783274 loops=1
              Worker 3:  actual time=11.854..485209.970 rows=416740827 loops=1
              Worker 4:  actual time=15.772..346323.294 rows=308493508 loops=1
              Worker 5:  actual time=10.130..461740.908 rows=391590847 loops=1
              Worker 6:  actual time=3.192..494021.369 rows=423495770 loops=1
              Worker 7:  actual time=10.595..506258.460 rows=409543751 loops=1
              Worker 8:  actual time=9.525..559266.475 rows=466240557 loops=1
              Worker 9:  actual time=7.371..447430.127 rows=384952613 loops=1
              Worker 10:  actual time=1.121..531411.059 rows=452849913 loops=1
              Worker 11:  actual time=5.568..581573.882 rows=484017539 loops=1
              Worker 12:  actual time=494.225..555150.695 rows=474565720 loops=1
              Worker 13:  actual time=11.255..437012.527 rows=378988284 loops=1
              Worker 14:  actual time=6.550..384785.470 rows=327623246 loops=1
              Worker 15:  actual time=9.602..430096.810 rows=370513041 loops=1
              Worker 16:  actual time=4.222..511054.730 rows=424321105 loops=1
              Worker 17:  actual time=6.008..519756.076 rows=440464209 loops=1
              Worker 18:  actual time=16.147..530241.523 rows=442512512 loops=1
              ->  Parallel Index Scan using d_v_Table1_default_pkey on stage.d_v_Table1_default d_v_Table1_49  (cost=0.15..1.74 rows=1 width=22) (actual time=0.053..0.053 rows=0 loops=1)
                    Output: d_v_Table1_49.df_v_Table2_key, d_v_Table1_49.df_Table3_key, d_v_Table1_49.df_Table4, d_v_Table1_49.df_v_Table5_key
                    Index Cond: ((d_v_Table1_49.df_Table3_key = 111111111) AND ((d_v_Table1_49.df_Table4)::text = 'T'::text))
                    Filter: d_v_Table1_49.IsCorrect
                    Worker 9:  actual time=0.053..0.053 rows=0 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2303 d_v_Table1_30  (cost=0.00..5537826.78 rows=14482282 width=22) (actual time=10.577..286836.183 rows=289645566 loops=1)
                    Output: d_v_Table1_30.df_v_Table2_key, d_v_Table1_30.df_Table3_key, d_v_Table1_30.df_Table4, d_v_Table1_30.df_v_Table5_key
                    Filter: (d_v_Table1_30.IsCorrect AND ((d_v_Table1_30.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_30.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_30.df_Table3_key = 111111111) AND ((d_v_Table1_30.df_Table4)::text = 'T'::text))
                    Worker 7:  actual time=10.577..286836.183 rows=289645566 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2308 d_v_Table1_35  (cost=0.00..5262927.30 rows=13763376 width=22) (actual time=9.521..266724.522 rows=275267488 loops=1)
                    Output: d_v_Table1_35.df_v_Table2_key, d_v_Table1_35.df_Table3_key, d_v_Table1_35.df_Table4, d_v_Table1_35.df_v_Table5_key
                    Filter: (d_v_Table1_35.IsCorrect AND ((d_v_Table1_35.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_35.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_35.df_Table3_key = 111111111) AND ((d_v_Table1_35.df_Table4)::text = 'T'::text))
                    Worker 8:  actual time=9.521..266724.522 rows=275267488 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2311 d_v_Table1_38  (cost=0.00..5042480.89 rows=13186874 width=22) (actual time=4.219..264046.619 rows=263737476 loops=1)
                    Output: d_v_Table1_38.df_v_Table2_key, d_v_Table1_38.df_Table3_key, d_v_Table1_38.df_Table4, d_v_Table1_38.df_v_Table5_key
                    Filter: (d_v_Table1_38.IsCorrect AND ((d_v_Table1_38.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_38.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_38.df_Table3_key = 111111111) AND ((d_v_Table1_38.df_Table4)::text = 'T'::text))
                    Worker 16:  actual time=4.219..264046.619 rows=263737476 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2408 d_v_Table1_47  (cost=0.00..5038619.55 rows=13176776 width=22) (actual time=1.103..246218.685 rows=263535513 loops=1)
                    Output: d_v_Table1_47.df_v_Table2_key, d_v_Table1_47.df_Table3_key, d_v_Table1_47.df_Table4, d_v_Table1_47.df_v_Table5_key
                    Filter: (d_v_Table1_47.IsCorrect AND ((d_v_Table1_47.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_47.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_47.df_Table3_key = 111111111) AND ((d_v_Table1_47.df_Table4)::text = 'T'::text))
                    Worker 10:  actual time=1.103..246218.685 rows=263535513 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2312 d_v_Table1_39  (cost=0.00..4971943.13 rows=13002407 width=22) (actual time=7.998..248848.066 rows=260048130 loops=1)
                    Output: d_v_Table1_39.df_v_Table2_key, d_v_Table1_39.df_Table3_key, d_v_Table1_39.df_Table4, d_v_Table1_39.df_v_Table5_key
                    Filter: (d_v_Table1_39.IsCorrect AND ((d_v_Table1_39.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_39.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_39.df_Table3_key = 111111111) AND ((d_v_Table1_39.df_Table4)::text = 'T'::text))
                    Worker 2:  actual time=7.998..248848.066 rows=260048130 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2405 d_v_Table1_44  (cost=0.00..4951229.46 rows=12948238 width=22) (actual time=3.168..246867.880 rows=258964736 loops=1)
                    Output: d_v_Table1_44.df_v_Table2_key, d_v_Table1_44.df_Table3_key, d_v_Table1_44.df_Table4, d_v_Table1_44.df_v_Table5_key
                    Filter: (d_v_Table1_44.IsCorrect AND ((d_v_Table1_44.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_44.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_44.df_Table3_key = 111111111) AND ((d_v_Table1_44.df_Table4)::text = 'T'::text))
                    Worker 6:  actual time=3.168..246867.880 rows=258964736 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2406 d_v_Table1_45  (cost=0.00..4690689.08 rows=12266884 width=22) (actual time=9.594..229138.653 rows=245337661 loops=1)
                    Output: d_v_Table1_45.df_v_Table2_key, d_v_Table1_45.df_Table3_key, d_v_Table1_45.df_Table4, d_v_Table1_45.df_v_Table5_key
                    Filter: (d_v_Table1_45.IsCorrect AND ((d_v_Table1_45.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_45.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_45.df_Table3_key = 111111111) AND ((d_v_Table1_45.df_Table4)::text = 'T'::text))
                    Worker 15:  actual time=9.594..229138.653 rows=245337661 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2403 d_v_Table1_42  (cost=0.00..4530542.41 rows=11848075 width=22) (actual time=494.221..226923.011 rows=236961461 loops=1)
                    Output: d_v_Table1_42.df_v_Table2_key, d_v_Table1_42.df_Table3_key, d_v_Table1_42.df_Table4, d_v_Table1_42.df_v_Table5_key
                    Filter: (d_v_Table1_42.IsCorrect AND ((d_v_Table1_42.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_42.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_42.df_Table3_key = 111111111) AND ((d_v_Table1_42.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=494.221..226923.011 rows=236961461 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2407 d_v_Table1_46  (cost=0.00..4517621.87 rows=11814286 width=22) (actual time=1.015..222192.674 rows=236285670 loops=1)
                    Output: d_v_Table1_46.df_v_Table2_key, d_v_Table1_46.df_Table3_key, d_v_Table1_46.df_Table4, d_v_Table1_46.df_v_Table5_key
                    Filter: (d_v_Table1_46.IsCorrect AND ((d_v_Table1_46.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_46.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_46.df_Table3_key = 111111111) AND ((d_v_Table1_46.df_Table4)::text = 'T'::text))
                    Worker 0:  actual time=1.015..222192.674 rows=236285670 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2305 d_v_Table1_32  (cost=0.00..4450178.85 rows=11637912 width=22) (actual time=5.564..221383.834 rows=232758188 loops=1)
                    Output: d_v_Table1_32.df_v_Table2_key, d_v_Table1_32.df_Table3_key, d_v_Table1_32.df_Table4, d_v_Table1_32.df_v_Table5_key
                    Filter: (d_v_Table1_32.IsCorrect AND ((d_v_Table1_32.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_32.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_32.df_Table3_key = 111111111) AND ((d_v_Table1_32.df_Table4)::text = 'T'::text))
                    Worker 11:  actual time=5.564..221383.834 rows=232758188 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2205 d_v_Table1_20  (cost=0.00..4399312.67 rows=11504889 width=22) (actual time=6.545..210528.491 rows=230097741 loops=1)
                    Output: d_v_Table1_20.df_v_Table2_key, d_v_Table1_20.df_Table3_key, d_v_Table1_20.df_Table4, d_v_Table1_20.df_v_Table5_key
                    Filter: (d_v_Table1_20.IsCorrect AND ((d_v_Table1_20.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_20.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_20.df_Table3_key = 111111111) AND ((d_v_Table1_20.df_Table4)::text = 'T'::text))
                    Worker 14:  actual time=6.545..210528.491 rows=230097741 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2212 d_v_Table1_27  (cost=0.00..4303496.39 rows=11254314 width=22) (actual time=7.313..213353.614 rows=225086262 loops=1)
                    Output: d_v_Table1_27.df_v_Table2_key, d_v_Table1_27.df_Table3_key, d_v_Table1_27.df_Table4, d_v_Table1_27.df_v_Table5_key
                    Filter: (d_v_Table1_27.IsCorrect AND ((d_v_Table1_27.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_27.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_27.df_Table3_key = 111111111) AND ((d_v_Table1_27.df_Table4)::text = 'T'::text))
                    Worker 9:  actual time=7.313..213353.614 rows=225086262 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2404 d_v_Table1_43  (cost=0.00..4288859.71 rows=11216038 width=22) (actual time=22.313..220879.358 rows=224320732 loops=1)
                    Output: d_v_Table1_43.df_v_Table2_key, d_v_Table1_43.df_Table3_key, d_v_Table1_43.df_Table4, d_v_Table1_43.df_v_Table5_key
                    Filter: (d_v_Table1_43.IsCorrect AND ((d_v_Table1_43.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_43.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_43.df_Table3_key = 111111111) AND ((d_v_Table1_43.df_Table4)::text = 'T'::text))
                    Worker 1:  actual time=22.313..220879.358 rows=224320732 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2402 d_v_Table1_41  (cost=0.00..4262563.28 rows=11147268 width=22) (actual time=16.145..218020.378 rows=222945307 loops=1)
                    Output: d_v_Table1_41.df_v_Table2_key, d_v_Table1_41.df_Table3_key, d_v_Table1_41.df_Table4, d_v_Table1_41.df_v_Table5_key
                    Filter: (d_v_Table1_41.IsCorrect AND ((d_v_Table1_41.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_41.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_41.df_Table3_key = 111111111) AND ((d_v_Table1_41.df_Table4)::text = 'T'::text))
                    Worker 18:  actual time=16.145..218020.378 rows=222945307 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2401 d_v_Table1_40  (cost=0.00..4217661.56 rows=11029843 width=22) (actual time=11.852..208934.383 rows=220596825 loops=1)
                    Output: d_v_Table1_40.df_v_Table2_key, d_v_Table1_40.df_Table3_key, d_v_Table1_40.df_Table4, d_v_Table1_40.df_v_Table5_key
                    Filter: (d_v_Table1_40.IsCorrect AND ((d_v_Table1_40.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_40.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_40.df_Table3_key = 111111111) AND ((d_v_Table1_40.df_Table4)::text = 'T'::text))
                    Worker 3:  actual time=11.852..208934.383 rows=220596825 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2304 d_v_Table1_31  (cost=0.00..4088276.25 rows=10691480 width=22) (actual time=10.039..203392.300 rows=213829582 loops=1)
                    Output: d_v_Table1_31.df_v_Table2_key, d_v_Table1_31.df_Table3_key, d_v_Table1_31.df_Table4, d_v_Table1_31.df_v_Table5_key
                    Filter: (d_v_Table1_31.IsCorrect AND ((d_v_Table1_31.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_31.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_31.df_Table3_key = 111111111) AND ((d_v_Table1_31.df_Table4)::text = 'T'::text))
                    Worker 5:  actual time=10.039..203392.300 rows=213829582 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2112 d_v_Table1_15  (cost=0.00..4012067.42 rows=10492182 width=22) (actual time=11.249..197693.029 rows=209843620 loops=1)
                    Output: d_v_Table1_15.df_v_Table2_key, d_v_Table1_15.df_Table3_key, d_v_Table1_15.df_Table4, d_v_Table1_15.df_v_Table5_key
                    Filter: (d_v_Table1_15.IsCorrect AND ((d_v_Table1_15.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_15.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_15.df_Table3_key = 111111111) AND ((d_v_Table1_15.df_Table4)::text = 'T'::text))
                    Worker 13:  actual time=11.249..197693.029 rows=209843620 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2301 d_v_Table1_28  (cost=0.00..3980435.36 rows=10409459 width=22) (actual time=6.005..205386.849 rows=208189137 loops=1)
                    Output: d_v_Table1_28.df_v_Table2_key, d_v_Table1_28.df_Table3_key, d_v_Table1_28.df_Table4, d_v_Table1_28.df_v_Table5_key
                    Filter: (d_v_Table1_28.IsCorrect AND ((d_v_Table1_28.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_28.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_28.df_Table3_key = 111111111) AND ((d_v_Table1_28.df_Table4)::text = 'T'::text))
                    Worker 17:  actual time=6.005..205386.849 rows=208189137 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2209 d_v_Table1_24  (cost=0.00..3891196.62 rows=10176086 width=22) (actual time=15.769..181280.502 rows=203521718 loops=1)
                    Output: d_v_Table1_24.df_v_Table2_key, d_v_Table1_24.df_Table3_key, d_v_Table1_24.df_Table4, d_v_Table1_24.df_v_Table5_key
                    Filter: (d_v_Table1_24.IsCorrect AND ((d_v_Table1_24.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_24.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_24.df_Table3_key = 111111111) AND ((d_v_Table1_24.df_Table4)::text = 'T'::text))
                    Worker 4:  actual time=15.769..181280.502 rows=203521718 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2211 d_v_Table1_26  (cost=0.00..3812122.27 rows=9969294 width=22) (actual time=3.813..88344.185 rows=99692936 loops=2)
                    Output: d_v_Table1_26.df_v_Table2_key, d_v_Table1_26.df_Table3_key, d_v_Table1_26.df_Table4, d_v_Table1_26.df_v_Table5_key
                    Filter: (d_v_Table1_26.IsCorrect AND ((d_v_Table1_26.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_26.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_26.df_Table3_key = 111111111) AND ((d_v_Table1_26.df_Table4)::text = 'T'::text))
                    Worker 0:  actual time=7.341..171028.794 rows=192621110 loops=1
                    Worker 12:  actual time=0.284..5659.577 rows=6764762 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2210 d_v_Table1_25  (cost=0.00..3804543.66 rows=9949475 width=22) (actual time=4.249..90017.809 rows=99494746 loops=2)
                    Output: d_v_Table1_25.df_v_Table2_key, d_v_Table1_25.df_Table3_key, d_v_Table1_25.df_Table4, d_v_Table1_25.df_v_Table5_key
                    Filter: (d_v_Table1_25.IsCorrect AND ((d_v_Table1_25.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_25.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_25.df_Table3_key = 111111111) AND ((d_v_Table1_25.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=0.244..8673.503 rows=9982280 loops=1
                    Worker 17:  actual time=8.254..171362.115 rows=189007213 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2310 d_v_Table1_37  (cost=0.00..3779177.88 rows=9883140 width=22) (actual time=3.849..94100.834 rows=98831377 loops=2)
                    Output: d_v_Table1_37.df_v_Table2_key, d_v_Table1_37.df_Table3_key, d_v_Table1_37.df_Table4, d_v_Table1_37.df_v_Table5_key
                    Filter: (d_v_Table1_37.IsCorrect AND ((d_v_Table1_37.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_37.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_37.df_Table3_key = 111111111) AND ((d_v_Table1_37.df_Table4)::text = 'T'::text))
                    Worker 0:  actual time=0.220..17331.452 rows=17774529 loops=1
                    Worker 1:  actual time=7.478..170870.215 rows=179888225 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2208 d_v_Table1_23  (cost=0.00..3718441.73 rows=9724306 width=22) (actual time=3.609..84848.748 rows=97243034 loops=2)
                    Output: d_v_Table1_23.df_v_Table2_key, d_v_Table1_23.df_Table3_key, d_v_Table1_23.df_Table4, d_v_Table1_23.df_v_Table5_key
                    Filter: (d_v_Table1_23.IsCorrect AND ((d_v_Table1_23.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_23.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_23.df_Table3_key = 111111111) AND ((d_v_Table1_23.df_Table4)::text = 'T'::text))
                    Worker 10:  actual time=6.985..150217.588 rows=171282155 loops=1
                    Worker 17:  actual time=0.234..19479.909 rows=23203914 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2207 d_v_Table1_22  (cost=0.00..3510247.08 rows=9179844 width=22) (actual time=1.917..39972.393 rows=45899210 loops=4)
                    Output: d_v_Table1_22.df_v_Table2_key, d_v_Table1_22.df_Table3_key, d_v_Table1_22.df_Table4, d_v_Table1_22.df_v_Table5_key
                    Filter: (d_v_Table1_22.IsCorrect AND ((d_v_Table1_22.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_22.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_22.df_Table3_key = 111111111) AND ((d_v_Table1_22.df_Table4)::text = 'T'::text))
                    Worker 5:  actual time=0.384..713.415 rows=755425 loops=1
                    Worker 6:  actual time=0.295..3487.063 rows=4110334 loops=1
                    Worker 12:  actual time=0.452..22146.057 rows=25575220 loops=1
                    Worker 16:  actual time=6.539..133543.038 rows=153155860 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2201 d_v_Table1_16  (cost=0.00..3502483.39 rows=9159541 width=22) (actual time=4.239..169948.919 rows=183190785 loops=1)
                    Output: d_v_Table1_16.df_v_Table2_key, d_v_Table1_16.df_Table3_key, d_v_Table1_16.df_Table4, d_v_Table1_16.df_v_Table5_key
                    Filter: (d_v_Table1_16.IsCorrect AND ((d_v_Table1_16.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_16.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_16.df_Table3_key = 111111111) AND ((d_v_Table1_16.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=4.239..169948.919 rows=183190785 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2204 d_v_Table1_19  (cost=0.00..3482682.47 rows=9107758 width=22) (actual time=6.733..82485.346 rows=91077573 loops=2)
                    Output: d_v_Table1_19.df_v_Table2_key, d_v_Table1_19.df_Table3_key, d_v_Table1_19.df_Table4, d_v_Table1_19.df_v_Table5_key
                    Filter: (d_v_Table1_19.IsCorrect AND ((d_v_Table1_19.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_19.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_19.df_Table3_key = 111111111) AND ((d_v_Table1_19.df_Table4)::text = 'T'::text))
                    Worker 0:  actual time=0.273..3886.443 rows=4614321 loops=1
                    Worker 18:  actual time=13.193..161084.249 rows=177540825 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2206 d_v_Table1_21  (cost=0.00..3453875.96 rows=9032425 width=22) (actual time=13.533..53589.912 rows=60216147 loops=3)
                    Output: d_v_Table1_21.df_v_Table2_key, d_v_Table1_21.df_Table3_key, d_v_Table1_21.df_Table4, d_v_Table1_21.df_v_Table5_key
                    Filter: (d_v_Table1_21.IsCorrect AND ((d_v_Table1_21.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_21.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_21.df_Table3_key = 111111111) AND ((d_v_Table1_21.df_Table4)::text = 'T'::text))
                    Worker 0:  actual time=0.325..1741.300 rows=1629656 loops=1
                    Worker 1:  actual time=0.318..20864.548 rows=24115410 loops=1
                    Worker 13:  actual time=39.956..138163.888 rows=154903375 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2309 d_v_Table1_36  (cost=0.00..3450262.79 rows=9022975 width=22) (actual time=3.095..79395.070 rows=90229749 loops=2)
                    Output: d_v_Table1_36.df_v_Table2_key, d_v_Table1_36.df_Table3_key, d_v_Table1_36.df_Table4, d_v_Table1_36.df_v_Table5_key
                    Filter: (d_v_Table1_36.IsCorrect AND ((d_v_Table1_36.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_36.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_36.df_Table3_key = 111111111) AND ((d_v_Table1_36.df_Table4)::text = 'T'::text))
                    Worker 0:  actual time=0.229..17397.167 rows=20229208 loops=1
                    Worker 5:  actual time=5.962..141392.974 rows=160230290 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2306 d_v_Table1_33  (cost=0.00..3416981.89 rows=8935941 width=22) (actual time=5.538..81074.372 rows=89359392 loops=2)
                    Output: d_v_Table1_33.df_v_Table2_key, d_v_Table1_33.df_Table3_key, d_v_Table1_33.df_Table4, d_v_Table1_33.df_v_Table5_key
                    Filter: (d_v_Table1_33.IsCorrect AND ((d_v_Table1_33.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_33.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_33.df_Table3_key = 111111111) AND ((d_v_Table1_33.df_Table4)::text = 'T'::text))
                    Worker 3:  actual time=10.762..155630.255 rows=171009710 loops=1
                    Worker 18:  actual time=0.313..6518.489 rows=7709075 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2111 d_v_Table1_14  (cost=0.00..3333577.21 rows=8717825 width=22) (actual time=10.318..52420.854 rows=58118823 loops=3)
                    Output: d_v_Table1_14.df_v_Table2_key, d_v_Table1_14.df_Table3_key, d_v_Table1_14.df_Table4, d_v_Table1_14.df_v_Table5_key
                    Filter: (d_v_Table1_14.IsCorrect AND ((d_v_Table1_14.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_14.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_14.df_Table3_key = 111111111) AND ((d_v_Table1_14.df_Table4)::text = 'T'::text))
                    Worker 2:  actual time=30.345..138174.615 rows=154635889 loops=1
                    Worker 3:  actual time=0.300..13597.737 rows=14810895 loops=1
                    Worker 5:  actual time=0.311..5490.212 rows=4909685 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2202 d_v_Table1_17  (cost=0.00..3117451.67 rows=8152622 width=22) (actual time=3.356..72308.126 rows=81526223 loops=2)
                    Output: d_v_Table1_17.df_v_Table2_key, d_v_Table1_17.df_Table3_key, d_v_Table1_17.df_Table4, d_v_Table1_17.df_v_Table5_key
                    Filter: (d_v_Table1_17.IsCorrect AND ((d_v_Table1_17.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_17.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_17.df_Table3_key = 111111111) AND ((d_v_Table1_17.df_Table4)::text = 'T'::text))
                    Worker 9:  actual time=6.430..129349.786 rows=146131256 loops=1
                    Worker 18:  actual time=0.282..15266.466 rows=16921190 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2302 d_v_Table1_29  (cost=0.00..3114231.78 rows=8144202 width=22) (actual time=4.653..73122.912 rows=81441999 loops=2)
                    Output: d_v_Table1_29.df_v_Table2_key, d_v_Table1_29.df_Table3_key, d_v_Table1_29.df_Table4, d_v_Table1_29.df_v_Table5_key
                    Filter: (d_v_Table1_29.IsCorrect AND ((d_v_Table1_29.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_29.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_29.df_Table3_key = 111111111) AND ((d_v_Table1_29.df_Table4)::text = 'T'::text))
                    Worker 6:  actual time=9.091..134273.168 rows=150261485 loops=1
                    Worker 8:  actual time=0.215..11972.655 rows=12622513 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2203 d_v_Table1_18  (cost=0.00..3084541.97 rows=8066558 width=22) (actual time=6.820..148462.156 rows=161331136 loops=1)
                    Output: d_v_Table1_18.df_v_Table2_key, d_v_Table1_18.df_Table3_key, d_v_Table1_18.df_Table4, d_v_Table1_18.df_v_Table5_key
                    Filter: (d_v_Table1_18.IsCorrect AND ((d_v_Table1_18.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_18.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_18.df_Table3_key = 111111111) AND ((d_v_Table1_18.df_Table4)::text = 'T'::text))
                    Worker 8:  actual time=6.820..148462.156 rows=161331136 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2409 d_v_Table1_48  (cost=0.00..3039366.85 rows=7948418 width=22) (actual time=0.919..153461.517 rows=158968346 loops=1)
                    Output: d_v_Table1_48.df_v_Table2_key, d_v_Table1_48.df_Table3_key, d_v_Table1_48.df_Table4, d_v_Table1_48.df_v_Table5_key
                    Filter: (d_v_Table1_48.IsCorrect AND ((d_v_Table1_48.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_48.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_48.df_Table3_key = 111111111) AND ((d_v_Table1_48.df_Table4)::text = 'T'::text))
                    Worker 11:  actual time=0.919..153461.517 rows=158968346 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2110 d_v_Table1_13  (cost=0.00..3011885.32 rows=7876550 width=22) (actual time=0.998..13454.780 rows=15753097 loops=10)
                    Output: d_v_Table1_13.df_v_Table2_key, d_v_Table1_13.df_Table3_key, d_v_Table1_13.df_Table4, d_v_Table1_13.df_v_Table5_key
                    Filter: (d_v_Table1_13.IsCorrect AND ((d_v_Table1_13.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_13.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_13.df_Table3_key = 111111111) AND ((d_v_Table1_13.df_Table4)::text = 'T'::text))
                    Worker 0:  actual time=0.204..8629.641 rows=10353915 loops=1
                    Worker 1:  actual time=0.223..766.859 rows=877470 loops=1
                    Worker 3:  actual time=0.278..1411.713 rows=1695320 loops=1
                    Worker 4:  actual time=7.735..90166.130 rows=104902490 loops=1
                    Worker 6:  actual time=0.215..7858.168 rows=10067860 loops=1
                    Worker 9:  actual time=0.292..198.500 rows=262845 loops=1
                    Worker 12:  actual time=0.206..3146.960 rows=3424630 loops=1
                    Worker 13:  actual time=0.302..2388.381 rows=3313449 loops=1
                    Worker 15:  actual time=0.309..2044.765 rows=2632520 loops=1
                    Worker 17:  actual time=0.214..17936.682 rows=20000475 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2108 d_v_Table1_11  (cost=0.00..2890307.87 rows=7558606 width=22) (actual time=1.520..33434.479 rows=37793030 loops=4)
                    Output: d_v_Table1_11.df_v_Table2_key, d_v_Table1_11.df_Table3_key, d_v_Table1_11.df_Table4, d_v_Table1_11.df_v_Table5_key
                    Filter: (d_v_Table1_11.IsCorrect AND ((d_v_Table1_11.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_11.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_11.df_Table3_key = 111111111) AND ((d_v_Table1_11.df_Table4)::text = 'T'::text))
                    Worker 1:  actual time=0.272..6030.151 rows=7826665 loops=1
                    Worker 10:  actual time=0.246..14039.517 rows=15868985 loops=1
                    Worker 12:  actual time=0.597..4220.619 rows=5029970 loops=1
                    Worker 15:  actual time=4.967..109447.628 rows=122446500 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2109 d_v_Table1_12  (cost=0.00..2874397.72 rows=7516998 width=22) (actual time=1.542..27741.932 rows=30067987 loops=5)
                    Output: d_v_Table1_12.df_v_Table2_key, d_v_Table1_12.df_Table3_key, d_v_Table1_12.df_Table4, d_v_Table1_12.df_v_Table5_key
                    Filter: (d_v_Table1_12.IsCorrect AND ((d_v_Table1_12.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_12.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_12.df_Table3_key = 111111111) AND ((d_v_Table1_12.df_Table4)::text = 'T'::text))
                    Worker 1:  actual time=0.250..1587.209 rows=1781175 loops=1
                    Worker 7:  actual time=6.788..111851.306 rows=118587480 loops=1
                    Worker 9:  actual time=0.243..12099.775 rows=12879515 loops=1
                    Worker 13:  actual time=0.242..8632.600 rows=10831810 loops=1
                    Worker 16:  actual time=0.188..4538.770 rows=6259954 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2107 d_v_Table1_10  (cost=0.00..2703047.71 rows=7068891 width=22) (actual time=33.308..18815.014 rows=7068889 loops=20)
                    Output: d_v_Table1_10.df_v_Table2_key, d_v_Table1_10.df_Table3_key, d_v_Table1_10.df_Table4, d_v_Table1_10.df_v_Table5_key
                    Filter: (d_v_Table1_10.IsCorrect AND ((d_v_Table1_10.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_10.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_10.df_Table3_key = 111111111) AND ((d_v_Table1_10.df_Table4)::text = 'T'::text))
                    Worker 0:  actual time=75.442..8701.086 rows=40920 loops=1
                    Worker 1:  actual time=73.878..8808.009 rows=163680 loops=1
                    Worker 2:  actual time=0.216..25508.988 rows=9099255 loops=1
                    Worker 3:  actual time=72.765..8854.902 rows=130907 loops=1
                    Worker 4:  actual time=71.159..8797.422 rows=69300 loops=1
                    Worker 5:  actual time=0.193..25846.748 rows=11865865 loops=1
                    Worker 6:  actual time=0.136..8847.719 rows=91355 loops=1
                    Worker 7:  actual time=0.237..18483.671 rows=1310705 loops=1
                    Worker 8:  actual time=0.235..16545.473 rows=431585 loops=1
                    Worker 9:  actual time=58.320..8718.077 rows=42020 loops=1
                    Worker 10:  actual time=0.295..21640.431 rows=2163260 loops=1
                    Worker 11:  actual time=163.140..21108.425 rows=308495 loops=1
                    Worker 12:  actual time=54.118..8595.217 rows=51095 loops=1
                    Worker 13:  actual time=7.717..8726.739 rows=96030 loops=1
                    Worker 14:  actual time=8.531..103068.668 rows=97525505 loops=1
                    Worker 15:  actual time=0.154..8832.626 rows=96360 loops=1
                    Worker 16:  actual time=35.043..15529.497 rows=430210 loops=1
                    Worker 17:  actual time=0.195..8784.766 rows=63470 loops=1
                    Worker 18:  actual time=0.176..32969.608 rows=17396115 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2307 d_v_Table1_34  (cost=0.00..2331389.77 rows=6096948 width=22) (actual time=2.336..17315.689 rows=20323153 loops=6)
                    Output: d_v_Table1_34.df_v_Table2_key, d_v_Table1_34.df_Table3_key, d_v_Table1_34.df_Table4, d_v_Table1_34.df_v_Table5_key
                    Filter: (d_v_Table1_34.IsCorrect AND ((d_v_Table1_34.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_34.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_34.df_Table3_key = 111111111) AND ((d_v_Table1_34.df_Table4)::text = 'T'::text))
                    Worker 3:  actual time=0.146..6553.065 rows=8497170 loops=1
                    Worker 8:  actual time=0.152..14263.244 rows=16587835 loops=1
                    Worker 9:  actual time=0.450..433.680 rows=550715 loops=1
                    Worker 11:  actual time=12.876..79143.442 rows=91982510 loops=1
                    Worker 12:  actual time=0.203..2818.874 rows=3583085 loops=1
                    Worker 16:  actual time=0.190..681.827 rows=737605 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2106 d_v_Table1_9  (cost=0.00..19.95 rows=51 width=22) (actual time=1.081..1.772 rows=1017 loops=1)
                    Output: d_v_Table1_9.df_v_Table2_key, d_v_Table1_9.df_Table3_key, d_v_Table1_9.df_Table4, d_v_Table1_9.df_v_Table5_key
                    Filter: (d_v_Table1_9.IsCorrect AND ((d_v_Table1_9.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_9.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_9.df_Table3_key = 111111111) AND ((d_v_Table1_9.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=1.081..1.772 rows=1017 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2105 d_v_Table1_8  (cost=0.00..14.71 rows=38 width=22) (actual time=0.891..1.593 rows=760 loops=1)
                    Output: d_v_Table1_8.df_v_Table2_key, d_v_Table1_8.df_Table3_key, d_v_Table1_8.df_Table4, d_v_Table1_8.df_v_Table5_key
                    Filter: (d_v_Table1_8.IsCorrect AND ((d_v_Table1_8.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_8.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_8.df_Table3_key = 111111111) AND ((d_v_Table1_8.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=0.891..1.593 rows=760 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2104 d_v_Table1_7  (cost=0.00..12.57 rows=30 width=22) (actual time=1.485..2.460 rows=610 loops=1)
                    Output: d_v_Table1_7.df_v_Table2_key, d_v_Table1_7.df_Table3_key, d_v_Table1_7.df_Table4, d_v_Table1_7.df_v_Table5_key
                    Filter: (d_v_Table1_7.IsCorrect AND ((d_v_Table1_7.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_7.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_7.df_Table3_key = 111111111) AND ((d_v_Table1_7.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=1.485..2.460 rows=610 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2103 d_v_Table1_6  (cost=0.00..1.02 rows=1 width=22) (actual time=0.487..0.509 rows=25 loops=1)
                    Output: d_v_Table1_6.df_v_Table2_key, d_v_Table1_6.df_Table3_key, d_v_Table1_6.df_Table4, d_v_Table1_6.df_v_Table5_key
                    Filter: (d_v_Table1_6.IsCorrect AND ((d_v_Table1_6.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_6.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_6.df_Table3_key = 111111111) AND ((d_v_Table1_6.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=0.487..0.509 rows=25 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2101 d_v_Table1_4  (cost=0.00..1.01 rows=1 width=22) (actual time=0.576..0.584 rows=9 loops=1)
                    Output: d_v_Table1_4.df_v_Table2_key, d_v_Table1_4.df_Table3_key, d_v_Table1_4.df_Table4, d_v_Table1_4.df_v_Table5_key
                    Filter: (d_v_Table1_4.IsCorrect AND ((d_v_Table1_4.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_4.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_4.df_Table3_key = 111111111) AND ((d_v_Table1_4.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=0.576..0.584 rows=9 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2012 d_v_Table1_3  (cost=0.00..1.01 rows=1 width=22) (actual time=0.580..0.592 rows=6 loops=1)
                    Output: d_v_Table1_3.df_v_Table2_key, d_v_Table1_3.df_Table3_key, d_v_Table1_3.df_Table4, d_v_Table1_3.df_v_Table5_key
                    Filter: (d_v_Table1_3.IsCorrect AND ((d_v_Table1_3.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_3.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_3.df_Table3_key = 111111111) AND ((d_v_Table1_3.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=0.580..0.592 rows=6 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2102 d_v_Table1_5  (cost=0.00..1.00 rows=1 width=22) (actual time=1.256..1.260 rows=4 loops=1)
                    Output: d_v_Table1_5.df_v_Table2_key, d_v_Table1_5.df_Table3_key, d_v_Table1_5.df_Table4, d_v_Table1_5.df_v_Table5_key
                    Filter: (d_v_Table1_5.IsCorrect AND ((d_v_Table1_5.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_5.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_5.df_Table3_key = 111111111) AND ((d_v_Table1_5.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=1.256..1.260 rows=4 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2009 d_v_Table1_1  (cost=0.00..1.00 rows=1 width=22) (actual time=0.673..0.674 rows=1 loops=1)
                    Output: d_v_Table1_1.df_v_Table2_key, d_v_Table1_1.df_Table3_key, d_v_Table1_1.df_Table4, d_v_Table1_1.df_v_Table5_key
                    Filter: (d_v_Table1_1.IsCorrect AND ((d_v_Table1_1.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_1.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_1.df_Table3_key = 111111111) AND ((d_v_Table1_1.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=0.673..0.674 rows=1 loops=1
              ->  Parallel Seq Scan on stage.d_v_Table1_111111111_t_2010 d_v_Table1_2  (cost=0.00..1.00 rows=1 width=22) (actual time=0.406..0.410 rows=0 loops=2)
                    Output: d_v_Table1_2.df_v_Table2_key, d_v_Table1_2.df_Table3_key, d_v_Table1_2.df_Table4, d_v_Table1_2.df_v_Table5_key
                    Filter: (d_v_Table1_2.IsCorrect AND ((d_v_Table1_2.df_Table4)::text = ANY ('{T}'::text[])) AND ((d_v_Table1_2.df_Table4)::text = ANY ('{K,T}'::text[])) AND (d_v_Table1_2.df_Table3_key = 111111111) AND ((d_v_Table1_2.df_Table4)::text = 'T'::text))
                    Worker 12:  actual time=0.002..0.002 rows=0 loops=1
        ->  Parallel Hash  (cost=37.46..37.46 rows=59 width=42) (actual time=484.910..484.922 rows=54 loops=20)
              Output: d_v_Table5.IDTable5, d_v_Table5.ID2Table5, d_v_Table5.df_v_Table5_key, d_v_Table5.df_Table3_key, d_v_Table5.df_Table4
              Buckets: 2048  Batches: 1  Memory Usage: 304kB
              Worker 0:  actual time=477.822..477.832 rows=0 loops=1
              Worker 1:  actual time=488.629..488.652 rows=49 loops=1
              Worker 2:  actual time=479.473..479.482 rows=0 loops=1
              Worker 3:  actual time=493.190..493.197 rows=107 loops=1
              Worker 4:  actual time=479.315..479.321 rows=0 loops=1
              Worker 5:  actual time=482.154..482.161 rows=3 loops=1
              Worker 6:  actual time=479.966..479.975 rows=0 loops=1
              Worker 7:  actual time=480.318..480.325 rows=0 loops=1
              Worker 8:  actual time=499.900..499.947 rows=565 loops=1
              Worker 9:  actual time=479.739..479.752 rows=0 loops=1
              Worker 10:  actual time=480.196..480.206 rows=0 loops=1
              Worker 11:  actual time=479.541..479.553 rows=0 loops=1
              Worker 12:  actual time=478.854..478.863 rows=0 loops=1
              Worker 13:  actual time=477.244..477.258 rows=0 loops=1
              Worker 14:  actual time=485.217..485.230 rows=26 loops=1
              Worker 15:  actual time=478.057..478.064 rows=0 loops=1
              Worker 16:  actual time=479.832..479.841 rows=0 loops=1
              Worker 17:  actual time=489.008..489.018 rows=292 loops=1
              Worker 18:  actual time=483.298..483.310 rows=9 loops=1
              ->  Parallel Append  (cost=0.00..37.46 rows=59 width=42) (actual time=2.475..31.282 rows=54 loops=20)
                    Worker 0:  actual time=0.001..0.011 rows=0 loops=1
                    Worker 1:  actual time=11.764..11.828 rows=49 loops=1
                    Worker 2:  actual time=0.000..0.009 rows=0 loops=1
                    Worker 3:  actual time=7.568..22.880 rows=107 loops=1
                    Worker 4:  actual time=0.001..0.007 rows=0 loops=1
                    Worker 5:  actual time=1.890..1.900 rows=3 loops=1
                    Worker 6:  actual time=0.001..0.009 rows=0 loops=1
                    Worker 7:  actual time=0.001..0.006 rows=0 loops=1
                    Worker 8:  actual time=0.664..19.227 rows=565 loops=1
                    Worker 9:  actual time=0.001..0.012 rows=0 loops=1
                    Worker 10:  actual time=0.001..0.010 rows=0 loops=1
                    Worker 11:  actual time=0.001..0.012 rows=0 loops=1
                    Worker 12:  actual time=0.000..0.008 rows=0 loops=1
                    Worker 13:  actual time=0.002..0.015 rows=0 loops=1
                    Worker 14:  actual time=19.475..19.512 rows=26 loops=1
                    Worker 15:  actual time=0.001..0.007 rows=0 loops=1
                    Worker 16:  actual time=0.001..0.009 rows=0 loops=1
                    Worker 17:  actual time=0.570..17.023 rows=292 loops=1
                    Worker 18:  actual time=6.866..6.886 rows=9 loops=1
                    ->  Parallel Index Scan using d_v_Table5_default_pkey on stage.d_v_Table5_default d_v_Table5_24  (cost=0.15..2.36 rows=1 width=54) (actual time=0.012..0.012 rows=0 loops=1)
                          Output: d_v_Table5_24.IDTable5, d_v_Table5_24.ID2Table5, d_v_Table5_24.df_v_Table5_key, d_v_Table5_24.df_Table3_key, d_v_Table5_24.df_Table4
                          Index Cond: ((d_v_Table5_24.df_Table3_key = 111111111) AND ((d_v_Table5_24.df_Table4)::text = 'T'::text))
                          Filter: d_v_Table5_24.IsCorrect
                          Worker 8:  actual time=0.012..0.012 rows=0 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_1906 d_v_Table5_1  (cost=0.00..5.18 rows=12 width=42) (actual time=0.650..0.747 rows=235 loops=1)
                          Output: d_v_Table5_1.IDTable5, d_v_Table5_1.ID2Table5, d_v_Table5_1.df_v_Table5_key, d_v_Table5_1.df_Table3_key, d_v_Table5_1.df_Table4
                          Filter: (d_v_Table5_1.IsCorrect AND (d_v_Table5_1.df_Table3_key = 111111111) AND ((d_v_Table5_1.df_Table4)::text = 'T'::text))
                          Worker 8:  actual time=0.650..0.747 rows=235 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2003 d_v_Table5_3  (cost=0.00..4.14 rows=10 width=41) (actual time=0.578..0.713 rows=192 loops=1)
                          Output: d_v_Table5_3.IDTable5, d_v_Table5_3.ID2Table5, d_v_Table5_3.df_v_Table5_key, d_v_Table5_3.df_Table3_key, d_v_Table5_3.df_Table4
                          Filter: (d_v_Table5_3.IsCorrect AND (d_v_Table5_3.df_Table3_key = 111111111) AND ((d_v_Table5_3.df_Table4)::text = 'T'::text))
                          Worker 8:  actual time=0.578..0.713 rows=192 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2205 d_v_Table5_9  (cost=0.00..2.06 rows=4 width=41) (actual time=4.896..4.954 rows=82 loops=1)
                          Output: d_v_Table5_9.IDTable5, d_v_Table5_9.ID2Table5, d_v_Table5_9.df_v_Table5_key, d_v_Table5_9.df_Table3_key, d_v_Table5_9.df_Table4
                          Filter: (d_v_Table5_9.IsCorrect AND (d_v_Table5_9.df_Table3_key = 111111111) AND ((d_v_Table5_9.df_Table4)::text = 'T'::text))
                          Worker 8:  actual time=4.896..4.954 rows=82 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2403 d_v_Table5_17  (cost=0.00..2.04 rows=3 width=43) (actual time=7.565..7.610 rows=59 loops=1)
                          Output: d_v_Table5_17.IDTable5, d_v_Table5_17.ID2Table5, d_v_Table5_17.df_v_Table5_key, d_v_Table5_17.df_Table3_key, d_v_Table5_17.df_Table4
                          Filter: (d_v_Table5_17.IsCorrect AND (d_v_Table5_17.df_Table3_key = 111111111) AND ((d_v_Table5_17.df_Table4)::text = 'T'::text))
                          Worker 3:  actual time=7.565..7.610 rows=59 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2405 d_v_Table5_19  (cost=0.00..2.04 rows=3 width=42) (actual time=7.242..7.262 rows=30 loops=2)
                          Output: d_v_Table5_19.IDTable5, d_v_Table5_19.ID2Table5, d_v_Table5_19.df_v_Table5_key, d_v_Table5_19.df_Table3_key, d_v_Table5_19.df_Table4
                          Filter: (d_v_Table5_19.IsCorrect AND (d_v_Table5_19.df_Table3_key = 111111111) AND ((d_v_Table5_19.df_Table4)::text = 'T'::text))
                          Worker 5:  actual time=1.887..1.890 rows=3 loops=1
                          Worker 8:  actual time=12.597..12.633 rows=56 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2209 d_v_Table5_10  (cost=0.00..2.04 rows=3 width=41) (actual time=0.568..0.608 rows=57 loops=1)
                          Output: d_v_Table5_10.IDTable5, d_v_Table5_10.ID2Table5, d_v_Table5_10.df_v_Table5_key, d_v_Table5_10.df_Table3_key, d_v_Table5_10.df_Table4
                          Filter: (d_v_Table5_10.IsCorrect AND (d_v_Table5_10.df_Table3_key = 111111111) AND ((d_v_Table5_10.df_Table4)::text = 'T'::text))
                          Worker 17:  actual time=0.568..0.608 rows=57 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2404 d_v_Table5_18  (cost=0.00..1.04 rows=2 width=41) (actual time=5.881..5.897 rows=24 loops=2)
                          Output: d_v_Table5_18.IDTable5, d_v_Table5_18.ID2Table5, d_v_Table5_18.df_v_Table5_key, d_v_Table5_18.df_Table3_key, d_v_Table5_18.df_Table4
                          Filter: (d_v_Table5_18.IsCorrect AND (d_v_Table5_18.df_Table3_key = 111111111) AND ((d_v_Table5_18.df_Table4)::text = 'T'::text))
                          Worker 1:  actual time=11.762..11.792 rows=49 loops=1
                          Worker 8:  actual time=0.001..0.002 rows=0 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_1911 d_v_Table5_2  (cost=0.00..1.04 rows=2 width=40) (actual time=0.608..0.622 rows=47 loops=1)
                          Output: d_v_Table5_2.IDTable5, d_v_Table5_2.ID2Table5, d_v_Table5_2.df_v_Table5_key, d_v_Table5_2.df_Table3_key, d_v_Table5_2.df_Table4
                          Filter: (d_v_Table5_2.IsCorrect AND (d_v_Table5_2.df_Table3_key = 111111111) AND ((d_v_Table5_2.df_Table4)::text = 'T'::text))
                          Worker 17:  actual time=0.608..0.622 rows=47 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2011 d_v_Table5_6  (cost=0.00..1.03 rows=2 width=43) (actual time=0.899..0.913 rows=46 loops=1)
                          Output: d_v_Table5_6.IDTable5, d_v_Table5_6.ID2Table5, d_v_Table5_6.df_v_Table5_key, d_v_Table5_6.df_Table3_key, d_v_Table5_6.df_Table4
                          Filter: (d_v_Table5_6.IsCorrect AND (d_v_Table5_6.df_Table3_key = 111111111) AND ((d_v_Table5_6.df_Table4)::text = 'T'::text))
                          Worker 17:  actual time=0.899..0.913 rows=46 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2006 d_v_Table5_4  (cost=0.00..1.03 rows=2 width=41) (actual time=0.677..0.695 rows=44 loops=1)
                          Output: d_v_Table5_4.IDTable5, d_v_Table5_4.ID2Table5, d_v_Table5_4.df_v_Table5_key, d_v_Table5_4.df_Table3_key, d_v_Table5_4.df_Table4
                          Filter: (d_v_Table5_4.IsCorrect AND (d_v_Table5_4.df_Table3_key = 111111111) AND ((d_v_Table5_4.df_Table4)::text = 'T'::text))
                          Worker 17:  actual time=0.677..0.695 rows=44 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2108 d_v_Table5_7  (cost=0.00..1.03 rows=2 width=41) (actual time=0.341..0.364 rows=40 loops=1)
                          Output: d_v_Table5_7.IDTable5, d_v_Table5_7.ID2Table5, d_v_Table5_7.df_v_Table5_key, d_v_Table5_7.df_Table3_key, d_v_Table5_7.df_Table4
                          Filter: (d_v_Table5_7.IsCorrect AND (d_v_Table5_7.df_Table3_key = 111111111) AND ((d_v_Table5_7.df_Table4)::text = 'T'::text))
                          Worker 17:  actual time=0.341..0.364 rows=40 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2408 d_v_Table5_22  (cost=0.00..1.02 rows=2 width=40) (actual time=1.151..1.172 rows=31 loops=1)
                          Output: d_v_Table5_22.IDTable5, d_v_Table5_22.ID2Table5, d_v_Table5_22.df_v_Table5_key, d_v_Table5_22.df_Table3_key, d_v_Table5_22.df_Table4
                          Filter: (d_v_Table5_22.IsCorrect AND (d_v_Table5_22.df_Table3_key = 111111111) AND ((d_v_Table5_22.df_Table4)::text = 'T'::text))
                          Worker 17:  actual time=1.151..1.172 rows=31 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2406 d_v_Table5_20  (cost=0.00..1.02 rows=1 width=42) (actual time=0.527..0.546 rows=28 loops=1)
                          Output: d_v_Table5_20.IDTable5, d_v_Table5_20.ID2Table5, d_v_Table5_20.df_v_Table5_key, d_v_Table5_20.df_Table3_key, d_v_Table5_20.df_Table4
                          Filter: (d_v_Table5_20.IsCorrect AND (d_v_Table5_20.df_Table3_key = 111111111) AND ((d_v_Table5_20.df_Table4)::text = 'T'::text))
                          Worker 3:  actual time=0.527..0.546 rows=28 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2204 d_v_Table5_8  (cost=0.00..1.02 rows=1 width=42) (actual time=9.737..9.746 rows=13 loops=2)
                          Output: d_v_Table5_8.IDTable5, d_v_Table5_8.ID2Table5, d_v_Table5_8.df_v_Table5_key, d_v_Table5_8.df_Table3_key, d_v_Table5_8.df_Table4
                          Filter: (d_v_Table5_8.IsCorrect AND (d_v_Table5_8.df_Table3_key = 111111111) AND ((d_v_Table5_8.df_Table4)::text = 'T'::text))
                          Worker 8:  actual time=0.001..0.002 rows=0 loops=1
                          Worker 14:  actual time=19.472..19.490 rows=26 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2308 d_v_Table5_14  (cost=0.00..1.01 rows=1 width=44) (actual time=7.337..7.344 rows=10 loops=2)
                          Output: d_v_Table5_14.IDTable5, d_v_Table5_14.ID2Table5, d_v_Table5_14.df_v_Table5_key, d_v_Table5_14.df_Table3_key, d_v_Table5_14.df_Table4
                          Filter: (d_v_Table5_14.IsCorrect AND (d_v_Table5_14.df_Table3_key = 111111111) AND ((d_v_Table5_14.df_Table4)::text = 'T'::text))
                          Worker 3:  actual time=14.673..14.685 rows=20 loops=1
                          Worker 8:  actual time=0.001..0.002 rows=0 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2409 d_v_Table5_23  (cost=0.00..1.01 rows=1 width=40) (actual time=0.431..0.441 rows=15 loops=1)
                          Output: d_v_Table5_23.IDTable5, d_v_Table5_23.ID2Table5, d_v_Table5_23.df_v_Table5_key, d_v_Table5_23.df_Table3_key, d_v_Table5_23.df_Table4
                          Filter: (d_v_Table5_23.IsCorrect AND (d_v_Table5_23.df_Table3_key = 111111111) AND ((d_v_Table5_23.df_Table4)::text = 'T'::text))
                          Worker 17:  actual time=0.431..0.441 rows=15 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2402 d_v_Table5_16  (cost=0.00..1.01 rows=1 width=41) (actual time=6.062..6.067 rows=6 loops=2)
                          Output: d_v_Table5_16.IDTable5, d_v_Table5_16.ID2Table5, d_v_Table5_16.df_v_Table5_key, d_v_Table5_16.df_Table3_key, d_v_Table5_16.df_Table4
                          Filter: (d_v_Table5_16.IsCorrect AND (d_v_Table5_16.df_Table3_key = 111111111) AND ((d_v_Table5_16.df_Table4)::text = 'T'::text))
                          Worker 8:  actual time=0.002..0.003 rows=0 loops=1
                          Worker 17:  actual time=12.122..12.131 rows=12 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2306 d_v_Table5_13  (cost=0.00..1.01 rows=1 width=40) (actual time=3.432..3.437 rows=4 loops=2)
                          Output: d_v_Table5_13.IDTable5, d_v_Table5_13.ID2Table5, d_v_Table5_13.df_v_Table5_key, d_v_Table5_13.df_Table3_key, d_v_Table5_13.df_Table4
                          Filter: (d_v_Table5_13.IsCorrect AND (d_v_Table5_13.df_Table3_key = 111111111) AND ((d_v_Table5_13.df_Table4)::text = 'T'::text))
                          Worker 8:  actual time=0.001..0.002 rows=0 loops=1
                          Worker 18:  actual time=6.864..6.871 rows=9 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2309 d_v_Table5_15  (cost=0.00..1.01 rows=1 width=48) (actual time=247.863..247.866 rows=4 loops=2)
                          Output: d_v_Table5_15.IDTable5, d_v_Table5_15.ID2Table5, d_v_Table5_15.df_v_Table5_key, d_v_Table5_15.df_Table3_key, d_v_Table5_15.df_Table4
                          Filter: (d_v_Table5_15.IsCorrect AND (d_v_Table5_15.df_Table3_key = 111111111) AND ((d_v_Table5_15.df_Table4)::text = 'T'::text))
                          Worker 5:  actual time=0.001..0.001 rows=0 loops=1
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2304 d_v_Table5_11  (cost=0.00..1.00 rows=1 width=39) (actual time=21.855..21.861 rows=5 loops=1)
                          Output: d_v_Table5_11.IDTable5, d_v_Table5_11.ID2Table5, d_v_Table5_11.df_v_Table5_key, d_v_Table5_11.df_Table3_key, d_v_Table5_11.df_Table4
                          Filter: (d_v_Table5_11.IsCorrect AND (d_v_Table5_11.df_Table3_key = 111111111) AND ((d_v_Table5_11.df_Table4)::text = 'T'::text))
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2305 d_v_Table5_12  (cost=0.00..1.00 rows=1 width=40) (actual time=7.018..7.032 rows=5 loops=1)
                          Output: d_v_Table5_12.IDTable5, d_v_Table5_12.ID2Table5, d_v_Table5_12.df_v_Table5_key, d_v_Table5_12.df_Table3_key, d_v_Table5_12.df_Table4
                          Filter: (d_v_Table5_12.IsCorrect AND (d_v_Table5_12.df_Table3_key = 111111111) AND ((d_v_Table5_12.df_Table4)::text = 'T'::text))
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2407 d_v_Table5_21  (cost=0.00..1.00 rows=1 width=44) (actual time=0.882..0.887 rows=5 loops=1)
                          Output: d_v_Table5_21.IDTable5, d_v_Table5_21.ID2Table5, d_v_Table5_21.df_v_Table5_key, d_v_Table5_21.df_Table3_key, d_v_Table5_21.df_Table4
                          Filter: (d_v_Table5_21.IsCorrect AND (d_v_Table5_21.df_Table3_key = 111111111) AND ((d_v_Table5_21.df_Table4)::text = 'T'::text))
                    ->  Parallel Seq Scan on stage.d_v_Table5_111111111_t_2008 d_v_Table5_5  (cost=0.00..1.00 rows=1 width=46) (actual time=0.682..0.684 rows=1 loops=1)
                          Output: d_v_Table5_5.IDTable5, d_v_Table5_5.ID2Table5, d_v_Table5_5.df_v_Table5_key, d_v_Table5_5.df_Table3_key, d_v_Table5_5.df_Table4
                          Filter: (d_v_Table5_5.IsCorrect AND (d_v_Table5_5.df_Table3_key = 111111111) AND ((d_v_Table5_5.df_Table4)::text = 'T'::text))
Settings: effective_cache_size = '300GB', effective_io_concurrency = '300', max_parallel_workers = '20', max_parallel_workers_per_gather = '20', parallel_tuple_cost = '0.0125', random_page_cost = '1.1', search_path = '"$user", public, extensions', work_mem = '3GB'
Planning Time: 3000.399 ms
Execution Time: 21208130.602 ms

S pozdravem
Ján Pecsők

Tychonova 2, 160 00 Praha
Mobil: +420 775 942 871
[email-masked]
www.profinit.eu

-----Original Message-----
From: Adrian Klaver <[email-masked]> 
Sent: Tuesday, October 1, 2024 4:16 PM
To: Pecsök Ján <[email-masked]>; [email-masked]
Subject: Re: Reading execution plan - first row time vs last row time

On 10/1/24 06:53, Pecsök Ján wrote:
> Dear community,
> 
> We see significant difference in explain analyze Actual time in the 
> first line of execution plan and Execution time in the last line of 
> execution plan. What can be the reason?
> 
> For example, first line of execution plan:
> 
> Gather  (cost=1038.49..257627100.42 rows=7943222226 width=104) (actual
> time=531.925..3673159.806 rows=7943221053 loops=1)
> 
> This is 3673159/1000/60 = 61 minutes
> 
> And last 2 lines of execution plan:
> 
> Planning Time: 3000.399 ms
> 
> Execution Time: 21208130.602 ms
> 
> This is : 21208130/1000/60= 353 minutes
> 
> What happened in 353 – 61 = 292 minutes? We speculate that disk writes. 
> Query possibly written cca 0,75TB of data, by create table as select query.

You will need to show the complete EXPLAIN ANALYZE output as well as query.

> 
> 
> S pozdravem
> 
> *Ján Pecsők*
> 
> Tychonova 2, 160 00 Praha
> Mobil: +420 775 942 871
> [email-masked] <mailto:[email-masked]> www.profinit.eu 
> <https://www.profinit.eu/>
> 
> <https://www.profinit.eu/>
> 

--
Adrian Klaver
[email-masked]

---

From: Adrian Klaver <[email-masked]>
Date: Wed, 2 Oct 2024 11:32:39 -0700

>      and VHS.df_Table4 = 'T' and VHS.df_Table3_key = 111111111;

I'm thinking it would be better to do something like:

create table dm.v_Table6_T_111111111 as select ... with no data

to create the table structure.

Then use COPY or batch INSERT to move the data into the table.