Re: Timing of 'SELECT 1' - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Timing of 'SELECT 1'
Date
Msg-id 9258.1078949090@sss.pgh.pa.us
Whole thread Raw
In response to Re: Timing of 'SELECT 1'  (Kurt Roeckx <Q@ping.be>)
List pgsql-hackers
Kurt Roeckx <Q@ping.be> writes:
> If I do a query on localhost with lots of data, I get a small
> time in the log, if I do it over a slow link the time get higher.
> It changes from 1 second to 2 minutes or something.

> So I think it's until the client has received the data.

It'll at least be until the backend has been able to send the data.
However, for a small amount of retrieved data, I doubt the kernel
will make the backend wait at the send() --- if there even is one
before the log entry is made.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: selective statement logging
Next
From: Hannu Krosing
Date:
Subject: Re: Timing of 'SELECT 1'