Re: EXPLAIN EXECUTE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: EXPLAIN EXECUTE
Date
Msg-id 15671.1042149205@sss.pgh.pa.us
Whole thread Raw
In response to EXPLAIN EXECUTE  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: EXPLAIN EXECUTE  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dollar in identifiers
Next
From: Bruce Momjian
Date:
Subject: Re: IPv6 patch