steviesteve
9/11/2017 - 2:55 PM

Postgres running queries

Show postgres queries running longer than a minute

SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE now() - pg_stat_activity.query_start > interval '1 minutes';