"Bojan Belovic" <bbelovic(at)usa(dot)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