public inbox for [email protected]
help / color / mirror / Atom feedFrom: =?iso-8859-2?Q?Pecs=F6k_J=E1n?= <[email protected]>
To: [email protected] <[email protected]>
Subject: Reading execution plan - first row time vs last row time
Date: Tue, 1 Oct 2024 13:53:18 +0000
Message-ID: <AS1PR05MB91059DA7056B7C30EAE61AA59F772@AS1PR05MB9105.eurprd05.prod.outlook.com> (raw)
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.
S pozdravem
Ján Pecsők
Tychonova 2, 160 00 Praha
Mobil: +420 775 942 871
[email protected]<mailto:[email protected]>
www.profinit.eu<https://www.profinit.eu/;
[cid:[email protected]]<https://www.profinit.eu/;
Attachments:
[image/png] image001.png (5.0K, 3-image001.png)
download | view image
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Reading execution plan - first row time vs last row time
In-Reply-To: <AS1PR05MB91059DA7056B7C30EAE61AA59F772@AS1PR05MB9105.eurprd05.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox