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
jan.pec...@profinit.eu
www.profinit.eu
-----Original Message-----
From: Adrian Klaver <adrian.kla...@aklaver.com>
Sent: Tuesday, October 1, 2024 4:16 PM
To: Pecsök Ján <jan.pec...@profinit.eu>; pgsql-general@lists.postgresql.org
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
> jan.pec...@profinit.eu <mailto:jan.pec...@profinit.eu> www.profinit.eu
> <https://www.profinit.eu/>
>
> <https://www.profinit.eu/>
>
--
Adrian Klaver
adrian.kla...@aklaver.com
