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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

  From Date Subject
Next Message Fernando Hevia 2008-07-22 20:45:18 Re: Strange query duration
Previous Message Stephan Szabo 2008-07-22 20:18:16 Re: Strange query duration