Re: That EXPLAIN ANALYZE patch still needs work - Mailing list pgsql-hackers

From Tom Lane
Subject Re: That EXPLAIN ANALYZE patch still needs work
Date
Msg-id 17628.1149715701@sss.pgh.pa.us
Whole thread Raw
In response to Re: That EXPLAIN ANALYZE patch still needs work  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: That EXPLAIN ANALYZE patch still needs work
Ending EXPLAIN ANALYZE early (was Re: That EXPLAIN ANALYZE patch still needs work)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Wed, 2006-06-07 at 16:56 -0400, Tom Lane wrote:
>> Certainly the removal of timing
>> is not going to convert an intolerable EXPLAIN ANALYZE runtime into an
>> acceptable one; 

> I disagree, as have others.

The overhead seems to be on the order of a couple tens of percent usually.
I don't see how that makes the difference between an EXPLAIN ANALYZE you
can run and one you can't.

> A full EXPLAIN ANALYZE is always desirable - we agree on that. The
> question is what we do when one is not available.

The least bad alternative I've heard is to let EXPLAIN ANALYZE print
out stats-so-far if the query is canceled by control-C or statement
timeout.  The objection to this is you may mistake startup transients
for full query behavior ... but at least the numbers will be good as
far as they go.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: ADD/DROP INHERITS
Next
From: "Jim C. Nasby"
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work