While debugging some very long running queries in PostgreSQL (processing geographic data) is great, I find myself sometimes cancelling the query. However, in analytics the query is still running, even though it’s client app has ended.
Fetching a list of running queries:
SELECT pid, age(clock_timestamp(), query_start), usename, query FROM pg_stat_activity ORDER BY query_start desc;
Asking a query to end (or killing it):
SELECT pg_cancel_backend(pid);
or for “those stubborn stains”:
SELECT pg_terminate_backend(pid);
