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