Re: ToDo: log plans of cancelled queries

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: ToDo: log plans of cancelled queries
Дата
Msg-id 20130111164124.GD16126@tamriel.snowman.net
обсуждение исходный текст
Ответ на 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>:
> > We can send a 'cancel query', how about a 'report on query' which
> > returns the plan and perhaps whatever other stats are easily available?
>
> there is only one question - that POSIX signal we can use?

This would be a new protocol message, psql doesn't ever send any actual
process signals to the backend processes...

Or at least, that's how I was thinking it would be implemented, in an
ideal world.  It's possible we could have some backend helper function
which a user could call on another connection to send a signal to the
first, after figuring out the pid, blah, blah.

Of course, I haven't gone and looked at how cancel query really works
under the hood, so I have no idea if this is at all possible. :)
Thanks,
    Stephen

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Version 4.10 of buildfarm client released.
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: ToDo: log plans of cancelled queries