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.pecsok@profinit.eu <mailto:jan.pecsok@profinit.eu>
www.profinit.eu <https://www.profinit.eu/&gt;

<https://www.profinit.eu/&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

On Tue, Oct 1, 2024 at 9:53 AM Pecsök Ján <jan.pecsok@profinit.eu> wrote:

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)

It takes an hour for Postgres to gather up 7.9 BILLION (!) rows, but then
it is going to take additional time to do something with all of those rows.
That's where the rest of your time is going. Seeing your actual query would
be a help. If this is a CTAS (Create Table As Select), then you have an
hour for the 'Select' part, and the rest of your time is in the 'Create
Table' part.

Cheers,
Greg

=?iso-8859-2?Q?Pecs=F6k_J=E1n?= <jan.pecsok@profinit.eu> writes:

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?

The time reported for the top query node is just the time taken to
compute all the rows returned by the query. It doesn't account
for what might be done with the data afterward. A normal EXPLAIN
just drops that data on the floor, so there's not much time left
unaccounted-for. But if you're writing the data into a table via
EXPLAIN CREATE TABLE AS, that I/O would be extra.

regards, tom lane

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.pecsok@profinit.eu
www.profinit.eu

-----Original Message-----
From: Adrian Klaver <adrian.klaver@aklaver.com>
Sent: Tuesday, October 1, 2024 4:16 PM
To: Pecsök Ján <jan.pecsok@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.pecsok@profinit.eu <mailto:jan.pecsok@profinit.eu> www.profinit.eu
<https://www.profinit.eu/&gt;

<https://www.profinit.eu/&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

On 10/2/24 02:37, Pecsök Ján wrote:

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;

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.

S pozdravem

*Ján Pecsők*

Tychonova 2, 160 00 Praha
Mobil: +420 775 942 871
jan.pecsok@profinit.eu <mailto:jan.pecsok@profinit.eu> www.profinit.eu
<https://www.profinit.eu/&gt;

<https://www.profinit.eu/&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Adrian Klaver
adrian.klaver@aklaver.com