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?

kill -9 of the procpid seems  to kill the entire server process. So
I'm not really comfortable with that.
The query was started by a webscript that was closed a long time ago.

So how do you stop them? (This is on a Linux box)

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to