Re: ToDo: log plans of cancelled queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ToDo: log plans of cancelled queries
Дата
Msg-id 9944.1357921223@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ToDo: log plans of cancelled queries  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: ToDo: log plans of cancelled queries  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> An even better feature would be to be able to send a signal to a
> running query to log its currently executing plan. That way you can
> ask "Why so slow?" before deciding to kill it.

That could conceivably work.  At least it wouldn't require running
EXPLAIN in a failed transaction.
        regards, tom lane



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

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