Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group