pg-top

PostgreSQL real-time activity monitor. Show running queries, locks, blocking chains, and per-database stats. Use when debugging slow queries, investigating locks, or monitoring database load.