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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Rafael Martinez wrote:
> I am wondering why the time reported by \timing in psql is not the
> 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
> this in the documentation.

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

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-2017 The PostgreSQL Global Development Group