Daily Hack #day44 - Postgres Trick: Find Idle/Blocked Processes

This query looks at the pg_stat_activity view for processes that are active but have a wait_event or wait_event_type that are non-NULL. SELECT pid, datname, usename, application_name, client_addr, clien...