Postgres Pro
Downloads
Home   >   mailing lists

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

From Kurt Roeckx
Subject Re: Timing of 'SELECT 1'
Date
Msg-id 20040310194754.GA10352@ping.be
Whole thread Raw
In response to Re: Timing of 'SELECT 1'  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Timing of 'SELECT 1'  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Wed, Mar 10, 2004 at 11:42:12AM -0500, Bruce Momjian wrote:
> 
> I am using log_duration, so this isn't measuring network time, just time
> in the backend (at least I think so).

I don't think it is.

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.


Kurt

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Shouldn't B'1' = 1::bit be true?
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: PITR Functional Design v2 for 7.5