Re: 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