Snippets

Realhub Systems Find long running processes in Postgres

Created by Accounts Realhub
snippet.txt
Raw 
1
2
3
4
5
6
7
8
9
SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';

SELECT pg_cancel_backend(__pid__)

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.