Re: explain with placeholders?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: explain with placeholders?
Дата
Msg-id 532.1094567984@sss.pgh.pa.us
обсуждение исходный текст
Ответ на explain with placeholders?  (Dan Sugalski <dan@sidhe.org>)
Ответы Re: explain with placeholders?
Список pgsql-general
Дерево обсуждения 
Dan Sugalski <dan@sidhe.org> writes:
> Is there any way to convince explain to go do its thing when given a
> query with placeholders in it?

    PREPARE foo(...) AS SELECT ...

    EXPLAIN EXECUTE foo(...)

EXPLAIN EXECUTE is a relatively recent addition, but I'm sure it's in
7.4 at least.

            regards, tom lane

В списке pgsql-general по дате отправления: