Subsystem Info
Collects information about WAL archiving, BG writer, backends (waiting, idling, transaction too long), vacuum progress, replication (primary, standby, publications, subscriptions), replication slots (physical, logical)
Database Info
Gathers stats about tablespaces (location, disk and inode usage), database sizes, transaction ID wraparound age, commit ratios, bloat, deadlocks, conflicts, cache hit ratio, installed extensions, disabled triggers, pg_stat_statements, blocked queries
Table & Index Info
Collects stats about last vacuum and analyze runs, changes since last vacuum, HOT update ratio, ins/upd/del ratios, seq and idx scan efficiency, table size and bloat, index hit ratio, inheritance, partition; index scans, size, bloat, definition
Log Files
Extracts query execution plans, autovacuum and deadlock information from PostgreSQL log files, including from AWS RDS instances.
Ecosystem Support
Gets metrics from AWS RDS PostgreSQL, AWS RDS Aurora, Microsoft Azure, Citus, PgBouncer and Pgpool. Also supports Google GCP SQL and Odyssey.
Easy To Use
Same command-line flags and env. vars. as psql. No need to install any PostgreSQL extension. Zero-dependency, statically linked binaries.