Troubleshooting PostgreSQL Performance SELECT pid, now() – query_start AS duration, queryFROM pg_stat_activityWHERE now() – query_start > interval ‘5 minutes’ORDER BY duration DESC; This script uses the pg_stat_activity view to find all queries that have been … Continue reading Troubleshooting PostgreSQL Performance