Re: timing != log duration - Mailing list pgsql-performance

From Albe Laurenz
Subject Re: timing != log duration
Date
Msg-id D960CB61B694CF459DCFB4B0128514C207A2B547@exadv11.host.magwien.gv.at
Whole thread Raw
In response to timing != log duration  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
List 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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: set autovacuum=off
Next
From: "Gnanakumar"
Date:
Subject: Write workload is causing severe slowdown in Production