PostgreSQL: quick active connection check
When a database is busy, inspect state, wait_event, and query age first.
psql -d appdb -c "select pid, usename, state, wait_event, now()-query_start age, left(query,120) from pg_stat_activity order by query_start nulls last limit 20;"
Verify the result
Long active or idle-in-transaction queries need separate review.