pg_exporter v1.0.0 Released – Next-Level PostgreSQL Observability

We’re delighted to announce pg_exporter v1.0.0, an advanced open-source Prometheus exporter that takes PostgreSQL observability to the next level.

Built for DBAs and developers who need deep insight, pg_exporter exposes 600 + metrics—roughly 3 K – 20 K time series per instance — covering core PostgreSQL internals, popular extensions such as TimescaleDB, Citus, pg_stat_statements, pg_wait_sampling, and even pgBouncer, all through a single, fully customizable exporter.

Unlike other exporters, pg_exporter values customizability: every metric lives in a YAML definition, so you can add, modify, or extend metrics without recompiling. The configuration allows fine-grained control over collection logic — PostgreSQL version branching, caching, timeouts, pre-condition queries, a health-check API, and live reload & replanning are all built in.

Battle-tested for more than six years in production clusters exceeding 25K+ CPU cores, pg_exporter also powers the Pigsty observability stack — see it in action in the live demo.

Version 1.0.0 brings a host of new features, including early support for PostgreSQL 18 — ready even before PG 18 beta release. Explore 50 + pre-defined collectors, or create your own (including app-specific metrics via SQL) simply by adding new configs.

Enjoy next-level insight into your PostgreSQL ecosystem with pg_exporter v1.0.0!


Features

  • Highly Customizable: Define almost all metrics through declarative YAML configs
  • Full Coverage: Monitor both PostgreSQL (10-18+) and pgBouncer (1.8-1.24+) in single exporter
  • Fine-grained Control: Configure timeout, caching, skip conditions, and fatality per collector
  • Dynamic Planning: Define multiple query branches based on different conditions
  • Self-monitoring: Rich metrics about pg_exporter itself for complete observability
  • Production-Ready: Battle-tested in real-world environments across 12K+ cores for 6+ years
  • Auto-discovery: Automatically discover and monitor multiple databases within an instance
  • Health Check APIs: Comprehensive HTTP endpoints for service health and traffic routing
  • Extension Support: timescaledb, citus, pg_stat_statements, pg_wait_sampling,…