Re: URGENT HELP about 'duration' stats - Mailing list pgsql-hackers

From Tom Lane
Subject Re: URGENT HELP about 'duration' stats
Date
Msg-id 6193.1193454382@sss.pgh.pa.us
Whole thread Raw
In response to URGENT HELP about 'duration' stats  (Camilo Porto <camiloporto@hotmail.com>)
Responses Re: URGENT HELP about 'duration' stats
List pgsql-hackers
Camilo Porto <camiloporto@hotmail.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


pgsql-hackers by date:

Previous
From: Camilo Porto
Date:
Subject: URGENT HELP about 'duration' stats
Next
From: Gregory Stark
Date:
Subject: Re: Avoiding planning redundant backwards merges