dedunumax · February 6, 2020 09:23
diff --git a/slow_postgres.sql b/slow_postgres.sql
 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' 
 ORDER BY duration DESC;
	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'
	ORDER BY duration DESC;