Re: Timing of 'SELECT 1'

From: Kurt Roeckx <Q(at)ping(dot)be>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Timing of 'SELECT 1'
Date: 2004-03-10 19:47:54
Message-ID: 20040310194754.GA10352@ping.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-03-10 20:04:50 Re: Timing of 'SELECT 1'
Previous Message Josh Berkus 2004-03-10 19:25:07 Default Stats Revisited