Skip to content

Instantly share code, notes, and snippets.

@dapi

dapi/list_queries.sql

Created June 7, 2017 11:45
Show Gist options
  • Save dapi/2ac868d605416921e251163a9955ce3a to your computer and use it in GitHub Desktop.
Save dapi/2ac868d605416921e251163a9955ce3a to your computer and use it in GitHub Desktop.
Download ZIP
Finding and killing long running queries on PostgreSQL
Raw
list_queries.sql
SELECT pid, now() - query_start as duration, query, state FROM pg_stat_activity WHERE now() - query_start > interval '5 minutes';
;; cancel
SELECT pg_cancel_backend(__pid__);
;; kill stucked
SELECT pg_terminate_backend(__pid__);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment