Hi,
I suppose the same is true for the time logged with log_duration, i.e.
it does not include the time needed to transfer the data to the client?
Or is it more like \timing in that respect?
Cheers,
Viktor
Craig Ringer wrote:
> EXPLAIN ANALYZE measures the time taken to execute the query. It doesn't
> include time required to transfer results to the client, possibly write
> them to disk, etc. It's really only for examining query plans as
> compared to actual execution of that plan.
>
> If you're more interested in *total* query execution time, including
> planning, execution, and transfer of results, you should usually use
> psql's \timing command, possibly along with output redirection. eg: