On Tue, Apr 20, 2010 at 2:42 PM, A B <gentosa...@gmail.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
