EXPLAIN EXECUTE

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

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

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