Re: ToDo: log plans of cancelled queries - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: ToDo: log plans of cancelled queries
Date
Msg-id 20130111164124.GD16126@tamriel.snowman.net
Whole thread Raw
In response to Re: ToDo: log plans of cancelled queries  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Version 4.10 of buildfarm client released.
Next
From: Simon Riggs
Date:
Subject: Re: ToDo: log plans of cancelled queries