Re: total execution time as reported by auto_explain - Mailing list pgsql-hackers

From Tom Lane
Subject Re: total execution time as reported by auto_explain
Date
Msg-id 5609.1257950850@sss.pgh.pa.us
Whole thread Raw
In response to total execution time as reported by auto_explain  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-hackers
Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> I was using auto_explain to log plans (with analyze option on) from
> queries that take more than 500ms, something i found i little odd is
> that the duration says 779ms but actual time says 269ms (almost 3
> times lower), maybe some kind of instrumentation cleanup can explain
> this?

Client slow about absorbing the rows, perhaps?  The actual data output
process isn't counted as part of the plan tree's runtime ... but it
would be included in the total elapsed time.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot Standby status
Next
From: Tom Lane
Date:
Subject: Re: Deadlock on the same object?