Re: different execution times of the same query

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: