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?  (Dan Sugalski <dan@sidhe.org>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: restricting non superuser from accessing other
Следующее
От: Mr Pink
Дата:
Сообщение: Re: ERROR: canceling query due to user request