pgmetrics - Comprehensive PostgreSQL Metrics Collection Tool

pgmetrics is an open-source, zero-dependency tool designed for efficiently collecting and reporting over 350 metrics from PostgreSQL servers. It simplifies performance monitoring, automation, and troubleshooting by providing outputs in user-friendly text, JSON, or CSV formats for seamless integration into scripting workflows.

pgmetrics - Comprehensive PostgreSQL Metrics Collection Tool screenshot

Features

Collects extensive PostgreSQL metrics including WAL archiving, replication, database sizes, and transaction statistics.

Zero-dependency, single-binary tool that requires no installation of PostgreSQL extensions.

Compatible with various ecosystems including AWS RDS, Azure, and Google Cloud SQL.

Extracts valuable insights from PostgreSQL log files, including query execution plans and autovacuum information.

Easy-to-use command-line interface with familiar flags and environment variables.