Re: ToDo: log plans of cancelled queries

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: ToDo: log plans of cancelled queries
Дата
Msg-id 20130111161513.GA16126@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: ToDo: log plans of cancelled queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: ToDo: log plans of cancelled queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: ToDo: log plans of cancelled queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
* Pavel Stehule (pavel.stehule@gmail.com) wrote:
> 2013/1/11 Stephen Frost <sfrost@snowman.net>:
> > Why not an option to auto_explain (or whatever) to log an execution plan
> > right before actually executing it?  If that was something which could
> > be set with a GUC or similar, you could just do that before running
> > whatever queries you're interested in capturing the plans for.
>
> for our OLAP usage it is probably possible, but it can be slow for OLTP usage..

If it was a GUC, you could turn it on/off at appropriate places in the
OLTP scenario.
Thanks,
    Stephen

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ToDo: log plans of cancelled queries
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ToDo: log plans of cancelled queries