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: -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
