unavailabl3 · September 13, 2019 09:06
diff --git a/Postgresql query to show hard requests (active or idle) b/Postgresql query to show hard requests (active or idle)
 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
	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';