On Tue, Apr 20, 2010 at 2:42 PM, A B <gentosaker(at)gmail(dot)com> wrote:
> Hi there!
>
> select * from pg_stat_activity;
> shows me a
> select my_function(....)
> query that has been running for too long.
> How do I kill it?
select pg_cancel_backend(pid);
will kill a running query.
> kill -9 of the procpid seems to kill the entire server process. So
kill -9 is NOT recommended.
Sometimes cancel_backend fails because there's no point where the code
checks for a cancel.