1 2 3 4 5 6 7 8 9 10 11 12 13
-- show running queries (9.2) SELECT pid, age(query_start, clock_timestamp()), usename, query FROM pg_stat_activity WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' ORDER BY query_start desc; -- kill running query SELECT pg_cancel_backend(procpid); -- kill idle query SELECT pg_terminate_backend(procpid); --https://gist.github.com/rgreenjr/3637525
You can clone a snippet to your computer for local editing. Learn more.