"Couldn't you just use pg_activity? — staking out one corner of Postgres incident triage"

is a top-style activity viewer written in Python. It's been around a long time, it's mature, and if you're SSH'd into a production host it's still first-rate. Instead of re-typing pg_stat_activity by hand, the running queries line up sorted by duration and refresh on their own. Part of what I said I "wanted" in the last article has been sitting right here all along.

is on GitHub.