Re: Killing a child process

"Bojan Belovic" <bbelovic@usa.net> writes:
> Every once in a while I'll spot a query that is taking unusually long time
> to run (a chiled process that keeps the processor at 100% for like 3
> minutes). Is there a way to see the queries currently executing

ps, top?  Also see the stats views, if you are running 7.2.

> and/or kill
> a single process without affecting the operation of the server

kill -INT to a backend will issue a query cancel, which is pretty safe.

            regards, tom lane