Find long running queries in postgres
This article details a straightforward SQL query to identify active, long-running queries in PostgreSQL by inspecting `pg_stat_activity`. It's a quick way to pinpoint performance bottlenecks and offers basic steps to further diagnose and terminate rogue processes.