PG Exporter Blog

PG Exporter v1.5.0 updates the Go toolchain and dependencies, fixes replication collector identity and state mappings, and closes six runtime defects around target URLs, discovery, health, collector planning, durations, and HTTP routing. The bundle …

Status: Shipped in v1.5.0. Decision and last verification: 2026-10-23. Scope: v1.5.0 at source 1891254 (fix baseline 9b378cb). This decision covers target URL handling and database identity, metadata-driven collector selection, HTTP health …

Status: Shipped in v1.5.0. Decision date / last verified: 2026-10-22 / 2026-10-23. Scope: Collector corrections in pg_exporter main commit d97ba38fc8390984df994b2f9ea58b43ecfc8b89, based on 72f00a4fa4e6eb7524174f2122b3fe1e1d608db4; PostgreSQL …

PostgreSQL logs record events that SQL snapshots can miss: deadlocks, authentication failures, canceled autovacuum workers, checkpoints, temporary-file removals, and client disconnects. They can also report statement duration, according to the …

pgbackrest info --output=json reports backup state. The command can contact remote repositories and wait for storage. Running it during a Prometheus request would add that delay to database monitoring. Status: Implemented but unreleased. Decision …

We first considered a local PostgreSQL incident workbench. It would read structured logs, reconstruct session timelines, provide interactive filters and a terminal interface, and later run as an agent. Status: Superseded on 2026-08-24 by PostgreSQL …

Composite mode combines PostgreSQL, PgBouncer, Patroni, pgBackRest, and PostgreSQL log metrics in one /metrics endpoint. It reduces the number of processes and scrape targets for a database node. PostgreSQL remains the primary source; each optional …

v1.4.1 is a maintenance release focused on metric accuracy and RPM upgrade compatibility. Highlights Fix pg_subrel_count overcounting when parallel logical replication apply workers are active: deduplicate pg_stat_subscription by subscription ID and …

v1.4.0 introduces the Snapshot Histogram metric type and the new pg_xact_age transaction age collector, along with a round of systematic hardening across HTTP routing, packaging, and the build toolchain. New Features New HISTOGRAM column type: SQL …

A scalar metric cannot describe the distribution of a changing population. One 30-minute transaction and one hundred 18-second transactions have the same total age, but different counts, maxima, and operational effects. Status: Shipped in v1.4.0. …

v1.3.0 adds PostgreSQL 19 support, and refreshes the default collector bundle, build toolchain, and config coverage tests. Highlights Default support range extended from PostgreSQL 10-18+ to 10-19+ Default config bundle includes 57 config/*.yml …

v1.2.2 updates release builds to Go 1.26.2. Exporter features and configuration are unchanged. Checksums SHA256 checksums 273dfd45ac367f71044998d19171ee27d7deb094ec9410d4b31aef7caacfdcc6 pg-exporter_1.2.2-1_amd64.deb …

v1.2.1 updates the build toolchain, standardizes configuration formatting, and adds configuration consistency tests. Collector behavior is unchanged. Highlights Refresh the build toolchain: bump both release workflows and Docker build images to Go …

v1.2.0 updates startup, hot reload, health checks, and configuration validation. It also adds a configuration bundle for PostgreSQL 9.1–9.6. New Features Add robust hot reload workflow: support platform-specific reload signals (SIGHUP / SIGUSR1) and …

Fixed the pg_timeline configuration and updated Go dependencies. Checksums SHA256 checksums 8cddd57a843914a3145a80a3220bc875047b9bcac0664357c01ba86485436236 pg-exporter_1.1.2-1_amd64.deb …

Minor release with new collectors and bug fixes. New Features New pg_timeline collector for timeline monitoring New pg_sub_16 collector branch to exclude parallel operations in subscriptions (PostgreSQL 16+ compatibility) Bug Fixes Fix: Add coalesce …

This article describes the Pigsty v4 beta in December 2025. While preparing Pigsty v4.0, I replaced the default Prometheus and Loki services with VictoriaMetrics and VictoriaLogs. I also added VictoriaTraces. The aim was to reduce storage and memory …

Updated dependencies and built with Go 1.25.5. Collector Changes pg_setting: Major refactor for PG10-18 compatibility with missing_ok support Add 15 new metrics: max_parallel_workers, max_parallel_workers_per_gather, max_parallel_maintenance_workers, …

Updated dependencies and built with Go 1.25.4. Fix #80 Conflict with libpq env variables Change default value of auto-discovery to true by @kadaffy Checksums SHA256 checksums 7efa1a77dfd5b94813c32c7ac015b1d479b1f04fb958f6b1ed5af333e354d015 …

Updated dependencies and built with Go 1.25.0. Added the PG Exporter website. Release with GoReleaser for more operating systems and architectures with CI/CD pipeline: add windows amd64 support add linux ppc64le support Checksums SHA256 checksums …

Add Docker Hub images: pgsty/pg_exporter Updated Go dependencies and built with Go 1.24.5. Disable pg_tsdb_hypertable collector by default, since timescaledb catalog is changed. Checksums d5e2d6a656eef0ae1b29cd49695f9773 …

Changes Added PostgreSQL 18 collector branches: Branch Changes pg_wal_18 Removed write, sync, write_time, and sync_time; PostgreSQL moved these statistics to pg_stat_io pg_checkpointer_18 Added num_done and slru_written pg_db_18 Added …

Default Collectors new metrics collector for timescaledb hypertable new metrics collector for citus dist node new metrics collector for pg_wait_sampling wait event profile pg_slot overhaul: Add 16/17 pg_replication_slot metrics allow pg_slot …

Changes Updated dependencies. Bump golang.org/x/net from 0.35.0 to 0.36.0 #67 Update docker images building tags v0.8.1 Released 2025-03-29 View release Source · tar.gz Source · zip pgsty/pg_exporter

Changes Add PgBouncer 1.24 new metrics support (stat, pool, database) Fix: 310-pg_size.yml fails if log dir not set properly #64 by @Süleyman Vurucu Build with the latest Go 1.24 and bump all dependencies Refactor logging with the standard log/slog …

Changes Routine update with dependabot Feat: support specifying configuration as Reader by @ringerc in #62 Bump golang.org/x/crypto from 0.21.0 to 0.31.0 by @dependabot in #63 Fix some typos Full changelog v0.7.1 Released 2024-12-29 View release …

Changes Updated the codebase for Go 1.22.4. PostgreSQL 17 Metrics Support by @Vonng pg_exporter: predicate queries feature by @ringerc Do a clean build in the dockerfile by @ringerc pg_exporter: don’t panic after “bind: address already in use” by …

This is a June 2024 conference report. Roles, package counts, and proposals reflect that event. PGCon, the predecessor to PGCon.Dev, was held in Ottawa from 2007 through 2023. It brought PostgreSQL developers together to discuss the project’s …

Changes Updated golang.org/x/net from v0.10.0 to v0.17.0 and golang.org/x/crypto to v0.17.0 for security fixes (#38 covers x/crypto) Fix connect-timeout propagation (#37), contributed by @mouchar Checksums The original release published MD5 checksums …

This article describes the monitoring approach used in 2023. Its examples use PostgreSQL 15 fields and the dashboards available at that time. Slow queries increase response times and consume database resources. They can also prolong lock contention …

Changes Updated dependencies to address reported vulnerabilities. Added PostgreSQL 16 collectors and PostgreSQL 15 compatibility fixes (#35, @japinli). Added ARM64 packages. Removed the fixed monitor schema from pg_query queries. pg_stat_statements …

This tutorial describes Pigsty and Alibaba Cloud services as used in September 2023. Commands, prices, and dashboard details reflect that period. Pigsty is a PostgreSQL distribution. You can also use it solely to monitor PostgreSQL and hosts. This …

Exporter changes Used nFPM to build RPM and DEB packages. Added column.default to substitute a value for NULL. Added column.scale to scale numeric values, such as microseconds to seconds. Fixed /stat output. Added the pgsty/pg_exporter Docker image. …

Changes Excluded Citus and TimescaleDB internal schemas from object monitoring. Removed duplicate pg_statio rows. Added PgBouncer 1.16 support. Fixed overlapping pg_repl collector branches on PostgreSQL 12. Added -T, --connect-timeout, and …

Changes Added PostgreSQL 14 support. Revised the default metric configuration while preserving support for older configuration files. Added --auto-discovery, --include-database, and --exclude-database. Added multi-database collection through …

This walkthrough uses the Pigsty sandbox and dashboards from February 2021. Slow queries occupy connections, hold locks, and consume CPU and I/O. On a standby, a long query can conflict with WAL replay. PostgreSQL can delay replay or cancel the …

Changes Fixed an edge case in redacted connection strings. Corrected documentation and spelling errors. v0.3.2 Released 2021-02-01 View release Source · tar.gz Source · zip pgsty/pg_exporter

This article describes Pigsty at its January 2021 release. Today, I released Pigsty. Official website: pigsty.cc What is Pigsty? Pigsty monitors large PostgreSQL fleets and automates the deployment of highly available clusters. It is free, …

Changes Fixed default-configuration errors, especially on PostgreSQL versions below 13: Restricted primary_conninfo collection to the supported collector branch. Added funcid to pg_func labels to distinguish functions with the same name. Corrected …

Written in 2020. The metric counts and examples describe the deployment at that time. Preface Operating a database is like driving a car: both require attention to a dashboard. Metrics show the current state and help you decide when to act. Cars …

Changes Updated the default configuration for PostgreSQL 13 metrics, including pg_slru, pg_shmem, pg_query13, and pg_backup. Added HTTP endpoints for health and recovery-state checks. Added a startup HTTP server that reports pg_up 0 until …

This article presents Pigsty as it stood in May 2020. Metric counts and dashboard names describe that system. I recently built a database monitoring system called Pigsty. This article describes its architecture, dashboards, and metrics. Pigsty uses …

Written in 2020. This article develops a load indicator from PgBouncer transaction time. PG Load measures accumulated transaction time per second, divided by a chosen concurrency value. It combines the amount of work a database handles with the time …

Changes Added RPM packages for YUM and a Linux service definition. Added the skip option to query configuration. Fixed pgbouncer_up. Added configuration reload support. v0.2.0 Released 2020-03-21 View release Source · tar.gz Source · zip …

Changes Fixed pgbouncer_up. Added dynamic configuration reload. Removed shard-related logic. Added a bulky mode to the default configuration. v0.1.2 Released 2020-02-20 View release Source · tar.gz Source · zip pgsty/pg_exporter

Changes Fixed a startup hang when a query failed. v0.1.1 Released 2020-01-10 View release Source · tar.gz Source · zip pgsty/pg_exporter

Changes The first stable release. v0.1.0 Released 2020-01-08 View release Source · tar.gz Source · zip pgsty/pg_exporter

This is an early repository tag without a separate GitHub Release object. This archival note is based on the tag commit and historical release summary. Changes Add per-collector query timeouts Replace the earlier skip_error behavior with the fatal …

Changes Tested across more than 200 production nodes for about two weeks. v0.0.4 Released 2019-12-20 View release Source · tar.gz Source · zip pgsty/pg_exporter

Changes Passed production testing while the project remained under active development. v0.0.3 Released 2019-12-14 View release Source · tar.gz Source · zip pgsty/pg_exporter

Changes An early version made available for trial use. v0.0.2 Released 2019-12-09 View release Source · tar.gz Source · zip pgsty/pg_exporter

This early version has a Git tag but no separate GitHub Release. The note is based on the tag and historical release summary. Changes Added PgBouncer mode. v0.0.1 Released 2019-12-09 View release Source · tar.gz Source · zip pgsty/pg_exporter

This article describes a monitoring system from December 2018. Its dashboard layout and statistics-collector details belong to that period. Using monitoring to manage PostgreSQL Managing PostgreSQL requires an understanding of its operating state. …

This article was written in 2018. It explains statistics-based bloat estimates and maintenance practices from that period. PostgreSQL uses MVCC to let transactions work with different row versions. Old versions can leave tables and indexes larger …

This 2018 article explains physical storage for ordinary PostgreSQL tables. Table Storage Layout An ordinary table has its own storage and may also have a TOAST table: Main table: stores row data, relkind='r'. TOAST table: stores out-of-line values …

This article was written in 2018. The table definitions below use the 23-column PostgreSQL 10 CSV format, and the Filebeat example uses the legacy prospectors configuration. CSV logs can be imported into PostgreSQL tables or queried through file_fdw …