Re: URGENT HELP about 'duration' stats

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Camilo Porto <camiloporto(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: URGENT HELP about 'duration' stats
Date: 2007-10-27 03:06:22
Message-ID: 6193.1193454382@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Camilo Porto <camiloporto(at)hotmail(dot)com> writes:
> The problem I have encountered is that the sum of executor's
> duration time is, *sometimes*, bigger than the total time interval in
> which the statements had been executed!! And this makes no sense!

Umm ... why not? If you have, say, two queries executing in parallel
for 1 second, they'll each report a duration: of 1 second, thus summing
to 2 seconds, but the elapsed time was only 1 second.

If you don't see that always, then your benchmark program isn't trying
very hard to run more than one query in parallel ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Anton 2007-10-27 04:26:21 Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Previous Message Camilo Porto 2007-10-27 02:46:42 URGENT HELP about 'duration' stats