Re: Statement duration reporting - Mailing list pgsql-admin

From Tom Lane
Subject Re: Statement duration reporting
Date
Msg-id 8267.1139675019@sss.pgh.pa.us
Whole thread Raw
In response to Statement duration reporting  ("Erik G. Burrows" <erik@erikburrows.com>)
List pgsql-admin
"Erik G. Burrows" <erik@erikburrows.com> writes:
> So, my question is: What does the duration time in the serverlog
> reflect? Is it just the time the server took to execute the statement,
> or does it reflect also query receive and response transmit time?

The former.  The server has no way to measure transit times.

> Any other ideas as to why I'm seeing these odd and contradictory times?

There's a current thread in the pgsql-odbc list about similar issues
seen with ODBC.  I doubt its the same problem, because it's different
client software on a different OS, but maybe it'd be worth comparing
notes.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Ancient messages regurgitated into pgsql-admin, again
Next
From: lst_hoe01@kwsoft.de
Date:
Subject: Re: Postgresql performance and tuning questions