Re: EXPLAIN EXECUTE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: EXPLAIN EXECUTE
Дата
Msg-id 15671.1042149205@sss.pgh.pa.us
обсуждение исходный текст
Ответ на EXPLAIN EXECUTE  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: EXPLAIN EXECUTE  (Neil Conway <neilc@samurai.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Dollar in identifiers
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: IPv6 patch