Re: timing != log duration

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Rafael Martinez *EXTERN*" <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: timing != log duration
Date: 2012-03-21 14:48:09
Message-ID: D960CB61B694CF459DCFB4B0128514C207A2B547@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Rafael Martinez wrote:
> I am wondering why the time reported by \timing in psql is not the
same
> as the time reported by duration in the log file when log_duration or
> log_min_duration_statement are on?. I can not find any information
about
> this in the documentation.

\timing measures the time on the client, while the log contains the
duration
on the server side. The client time includes the overhead for
transferring
data to and from the server.

Yours,
Laurenz Albe

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gnanakumar 2012-03-22 07:27:13 Write workload is causing severe slowdown in Production
Previous Message Robert Haas 2012-03-21 14:32:26 Re: set autovacuum=off