=?iso-8859-2?Q?Pecs=F6k_J=E1n?= <jan.pec...@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
