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

-- 
Peter Eisentraut   peter_e@gmx.net


Thu, 9 Jan 2003 22:50:55 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
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

Thu, 09 Jan 2003 16:53:25 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: EXPLAIN EXECUTE 
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


09 Jan 2003 23:51:04 -0500
Neil Conway <neilc@samurai.com>
Re: EXPLAIN EXECUTE
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

Thu, 09 Jan 2003 23:55:51 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: EXPLAIN EXECUTE 