Thread: EXPLAIN EXECUTE

EXPLAIN EXECUTE

From
Peter Eisentraut
Date:
I notice that you can't explain stored plans, i.e., EXPLAIN EXECUTE.
Might be handy to have.

-- 
Peter Eisentraut   peter_e@gmx.net



Re: EXPLAIN EXECUTE

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.net> writes:
> I notice that you can't explain stored plans, i.e., EXPLAIN EXECUTE.
> Might be handy to have.

Yeah, that was on my to-fix list also.  There is more reason to have
this than just completeness: as things stand, EXPLAIN cannot teach you
anything about what the planner does with parameterized queries ---
which arise not only in PREPARE, but in SQL and plpgsql functions.
EXPLAIN EXECUTE would make it possible to look at parameterized plans.
        regards, tom lane


Re: EXPLAIN EXECUTE

From
Neil Conway
Date:
On Thu, 2003-01-09 at 16:53, Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > I notice that you can't explain stored plans, i.e., EXPLAIN EXECUTE.
> > Might be handy to have.
> 
> Yeah, that was on my to-fix list also.

Heh, I too was planning to implement this. Would you like to take a
crack it at, or should I?

Cheers,

Neil



Re: EXPLAIN EXECUTE

From
Tom Lane
Date:
Neil Conway <neilc@samurai.com> writes:
> On Thu, 2003-01-09 at 16:53, Tom Lane wrote:
>> Yeah, that was on my to-fix list also.

> Heh, I too was planning to implement this. Would you like to take a
> crack it at, or should I?

Go for it...
        regards, tom lane