Skip site navigation (1) Skip section navigation (2)

Re: Strange query duration

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Strange query duration
Date: 2008-07-22 20:19:08
Message-ID: 396486430807221319p7ba3a338ha38989b809b7d96@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Tue, Jul 22, 2008 at 12:10 PM, Fernando Hevia <fhevia(at)ip-tel(dot)com(dot)ar> wrote:

>Nevertheless in the LOG
> duration entry it shows a statement duration of over 36 secs.
> ┬┐What is going on? ┬┐Where come those 36 seconds from?

> 2008-07-22 15:52:37 ART|postgres| LOG:  duration: 38.154 ms

:o) You might be encountering a bit of parallax. This shows both 38
and 36 *milliseconds*.


-- 
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

Responses

pgsql-sql by date

Next:From: Fernando HeviaDate: 2008-07-22 20:45:18
Subject: Re: Strange query duration
Previous:From: Stephan SzaboDate: 2008-07-22 20:18:16
Subject: Re: Strange query duration

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group