pg_exporter v1.0.0 Released – Next-Level PG Observability

We’re delighted to announce [pg_exporter](https://github.com/pgsty/pg_exporter) [v1.0](https://github.com/pgsty/pg_exporter/releases/tag/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](https://pigsty.io/) observability stack — see it in action in the [live demo](https://demo.pigsty.io/).

Version 1.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](https://github.com/pgsty/pg_exporter/tree/main/config), 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**!

--------

## 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](https://demo.pigsty.cc/d/pgsql-exporter) 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`,...