pg_exporter-v1.2.0

v1.2.0 is a stability-and-compatibility focused minor release across startup flow, hot reload, health probing, config validation, and legacy support.

New Features

• Add robust hot reload workflow: support platform-specific reload signals (SIGHUP / SIGUSR1) and strengthen POST /reload to refresh configs and query plans without process restart
• Switch startup to non-blocking mode: HTTP endpoints come up first even when target precheck fails, making recovery and monitoring integration smoother
• Add PostgreSQL 9.1-9.6 legacy config bundle: provide legacy/ configs and a make conf9 target for easier onboarding of EOL PostgreSQL versions
• Rework health probing architecture: use cached health snapshots with periodic probes for more consistent role-based health endpoints and smoother reload behavior
• Improve release engineering baseline: run go test and go vet in release workflows and bump build toolchain to Go 1.26.0

Bug Fixes

• Fix multiple config parsing edge cases: reject malformed metrics entries, return explicit errors when config dirs fail to load valid YAML, and harden runtime fallbacks
• Fix CLI bool flag parsing to correctly handle --flag=false style arguments
• Fix /explain output/rendering behavior by adjusting content type handling and using safer template rendering
• Fix predicate query and PG URL handling details: better BOOL/BOOLEAN predicate support, safer row lifecycle handling, and improved dbname query-parameter parsing/redaction
• Fix resource cleanup when auto-discovered targets are removed by closing dropped server connections asynchronously
• Fix metric/label validation details including const-label conflict checks, scaled default-value handling, and Prometheus naming/rule checks

Changelog

• 8c7f61c Document PgBouncer health probing pitfalls
• 9a7acf7 Fix PgBouncer health probe (avoid lib/pq Ping ';')
• d33fc4e bump golang to 1.26.0
• 6c8b1a8 chore(go): bump to go1.25.7 for CVE fixes
• 3aea941 ci: run go test and go vet in release workflows
• d3ab676 config: clarify version splits and add PG10-18 coverage test
• 5af178b exporter: harden predicate queries and PGURL handling
• c78c081 exporter: make health checks cached and reload safe
• d89ed88 feat: add PostgreSQL 9.0-9.6 legacy collectors
• feda9bb feat: enable hot reload and non-blocking startup
• 0770d69 fix(cli): normalize kingpin bool flags passed as --flag=false
• abfdab2 fix(pgbouncer): harden precheck and health probe
• 01d0619 fix: add conf9 target and harden PG9 legacy collectors
• 90b5e0f fix: allow startup when target precheck fails
• 755101b fix: close removed servers asynchronously
• 262d8d9 fix: harden config parsing and runtime fallbacks
• 692d282 fix: make PG9.0 collectors and precheck work
• c42c07a fix: normalize config parsing and harden exporter runtime
• 6b65601 fix: serve /explain as text and reject conflicting const labels
• 491c214 fix: tighten config loading and metric helpers
• 6b5f7c2 fix: use html/template for Query HTML rendering
• 01ca8d9 release: bump metadata and docs to v1.2.0
• dd95ad6 remove pg_exporter docs page ci
• 5d3d506 update copyright year to 2026
• c75dd09 v1.2.0 release
• 8df9d7c v1.2.0 release candidate

pg_exporter-v1.1.2

Changelog

• de193f3 bug fix, resolve #91
• 108c800 bump golang deps to the latest version
• 38b9df0 bump version to 1.1.2
• 873ca35 doc: update pgsty to pigsty.io

pg_exporter-v1.1.1

Changelog

• 2e8da44 add new collector pg_timeline
• 28843e6 add pg_sub_16 branch to filter out parallel works in subscription
• 0fa5dde bump version string to 1.1.1
• 8ac3d4f fix: add coalesce slotname for pg_recv collector
• b77905f update release checksums

pg_exporter-v1.1.0

Build with Go 1.25.5 and latest dependencies, collector updates:

Collector Changes:

• pg_setting: Major refactor for PG10-18 compatibility with missing_ok support
  • Add 13 new metrics: max_parallel_workers, max_parallel_workers_per_gather, max_parallel_maintenance_workers, shared_buffers, maintenance_work_mem, effective_cache_size, fsync, full_page_writes, autovacuum, autovacuum_max_workers, checkpoint_timeout, checkpoint_completion_target, hot_standby, synchronous_commit, io_method
  • Rename work_memory_size to work_mem
  • Change min_version from 9.6 to 10, explicit ::int type casting
• pg_size: Fix log directory size detection, use logging_collector check instead of path pattern matching
• pg_table: Performance optimization, replace LATERAL subqueries with JOIN for better query performance; fix tuples and frozenxid metric type from COUNTER to GAUGE; increase timeout from 1s to 2s
• pg_vacuuming: Add PG17 collector branch with new metrics indexes_total, indexes_processed, dead_tuple_bytes for index vacuum progress tracking
• pg_query: Increase timeout from 1s to 2s for high-load scenarios
• pg_io: Fix typo in reuses description ("in reused" -> "is reused")
• pg_checkpointer: Fix description for pg_checkpointer_10 ("9.4+" -> "9.4-17")
• pg_db_confl: Fix description for pg_db_confl_15 ("9.1 - 16" -> "9.1 - 15")
• Format alignment fixes for pg_db, pg_indexing, pg_clustering, pg_backup

Other Changes:

• Fix release year by @anayrat

Changelog

• 81988cd Fix release year
• 17b7fa4 Update release.md
• 85dd1e2 adjust config fix typos and version descriptions
• 4caa7e2 adjust config format alignment for multiple collectors
• faf10f0 adjust config/0130-pg_setting refactor for PG10-18 compatibility
• 2b102da adjust config/0310-pg_size fix log directory size detection
• a388f85 adjust config/0460-pg_query increase timeout for high-load scenarios
• 9e46236 adjust config/0510-pg_vacuuming add PG17 index progress tracking
• 9da884b adjust config/0700-pg_table performance optimization and type fixes
• ca164e4 bump go and deps to the latest version
• 8d030ce bump version string to 1.1.0
• 39bc426 fix config/0270-pg_origin column name typo and metric types
• 17e8b41 fix config/0440-pg_xact xmax query bug
• cea3f44 fix config/2000-pg_heartbeat comment and lsn type
• a497260 refactor: update the default collector config

pg_exporter-v1.0.3

• Build with Go 1.25.4 and latest dependencies
• Fix #80 Conflict with libpq env variables
• Chanage default value of auto-discovery to true by @kadaffy

Checksums

https://github.com/pgsty/pg_exporter/releases/download/v1.0.3/checksums.txt

7efa1a77dfd5b94813c32c7ac015b1d479b1f04fb958f6b1ed5af333e354d015  pg-exporter_1.0.3-1_amd64.deb
41e18bf18eba2ab90ac371bfb46e9152da9fe628ebd8e26766cac08325eb3b07  pg-exporter_1.0.3-1_arm64.deb
7da8ed738d254c120d42aa51d6137f84e7f4e3188bc764d4f9a1438220363a43  pg-exporter_1.0.3-1_ppc64le.deb
a214b555981156da7b7d248b1f728f8ac88a07ac8f77a66c5d8e43b40670d6b4  pg_exporter-1.0.3-1.aarch64.rpm
d876fc66e208612ebffe3c43dabce88b088d915f92584260d710b85a3a131413  pg_exporter-1.0.3-1.ppc64le.rpm
75f62d314fec50c836c534996c884d25ecea77810ab33e7ba0e9c4b783e775b4  pg_exporter-1.0.3-1.x86_64.rpm
47829a19707284bcee1b8dc47cc7d0172398bb533e6b4043950f787486712769  pg_exporter-1.0.3.darwin-amd64.tar.gz
38b6ccb72315cadea542b1f2a7b7022d0e8d48ffd4ab177bb69a0a909b99af6b  pg_exporter-1.0.3.darwin-arm64.tar.gz
36e8dff84d61a7593ff1fcec567ca4ffeaecd0be2f9eabd227ceac71b12a919a  pg_exporter-1.0.3.linux-amd64.tar.gz
6477e8ef873773a09c4f39a29444f21b5b2c71e717e52ca425bcc8e8e5448791  pg_exporter-1.0.3.linux-arm64.tar.gz
a083b51ebed2b280e2eaa0f19558494e7fa6f122a0a86a1d117206fcd090820c  pg_exporter-1.0.3.linux-ppc64le.tar.gz
a1f9b27b7190f478726d96f270a72d9dc4d3f2bcc3b0326b7c4a2607e62ea588  pg_exporter-1.0.3.windows-amd64.tar.gz

Changelog

• c93b0e8 Bump golang.org/x/crypto from 0.41.0 to 0.45.0
• fedf763 bump version string to 1.0.3
• bc0ea84 fix: Change the autodiscovery default value to be in sync with the documentation
• 0ca63fe ignore certain unsupported libpq env var to avoid driver panic

pg_exporter-v1.0.2

• Build with Go 1.25.0 and latest dependencies
• Dedicate website and homepage: https://exp.pgsty.com
• Release with goreleaser for more os/arch with CI/CD pipeline:
  • add windows amd64 support
  • add linux ppc64le support

Changelog

• 603273e add ci pages to github
• 9cbc553 add doc site for pg_exporter
• 2eeb824 add docker build script
• e59988e add github ci/cd work flow
• d42965d add release number to deb packages
• 0282ae5 bump dependencies to the latest version

v1.0.1

v1.0.1

• Add dockerhub images: pgsty/pg_exporter
• Bump go dependencies to the latest version, build with go 1.24.5
• Disable pg_tsdb_hypertable collector by default, since timescaledb catalog is changed.

Docker

You can find pre-built amd64/arm64 docker images here: pgsty/pg_exporter

Checksums

67093a756b04845f69ad333b6d458e81  pg_exporter-v1.0.1.darwin-amd64.tar.gz
2d3fdc10045d1cf494b9c1ee7f94f127  pg_exporter-v1.0.1.darwin-arm64.tar.gz
e242314461becfa99c3978ae72838ab0  pg_exporter-v1.0.1.linux-amd64.tar.gz
63de91da9ef711a53718bc60b89c82a6  pg_exporter-v1.0.1.linux-arm64.tar.gz
d5e2d6a656eef0ae1b29cd49695f9773  pg_exporter-1.0.1-1.aarch64.rpm
cb01bb78d7b216a235363e9342803cb3  pg_exporter-1.0.1-1.x86_64.rpm
718f6afc004089f12c1ca6553f9b9ba5  pg-exporter_1.0.1_amd64.deb
57da7a8005cdf91ba8c1fb348e0d7367  pg-exporter_1.0.1_arm64.deb

v1.0.0

Add PostgreSQL 18 metrics support

• new collector branch pg_wal_18:
  • remove write, sync, write_time, sync_time metrics
  • move to pg_stat_io
• new collector branch pg_checkpointer_18:
  • new metric num_done
  • new metric slru_written
• new collector branch pg_db_18:
  • new metric parallel_workers_to_launch
  • new metric parallel_workers_launched
• new collector branch pg_table_18:
  • table_parallel_workers_to_launch
  • table_parallel_workers_launched
• new collector branch pg_io_18:
  • new series about WAL statistics
  • new metric read_bytes
  • new metric write_bytes
  • new metric extend_bytes
  • remove op_bytes due to fixed value
• new collector branch pg_vacuuming_18
  • new metric delay_time

https://github.com/pgsty/pg_exporter/releases/tag/v1.0.0

Checksums

33fe4dd8c5af56bef9b78fbf8f4fbbc9  pg_exporter-1.0.0-1.aarch64.rpm
eba8426b2cf50a58db5353562727004a  pg_exporter-1.0.0-1.x86_64.rpm
f691282245f9ef7e712b88985ca0da11  pg_exporter-v1.0.0.darwin-amd64.tar.gz
c133c6077857edd500ab325bad4dc438  pg_exporter-v1.0.0.darwin-arm64.tar.gz
3875487d26bcf9e9ec2e4dcb0c477ee0  pg_exporter-v1.0.0.linux-amd64.tar.gz
395715fbee8894baf0e9c173f8e1babd  pg_exporter-v1.0.0.linux-arm64.tar.gz
f3b23e592f33587d0055984a6d9c2ef3  pg-exporter_1.0.0_amd64.deb
a7305b9c46f8a0d476c9835cc8f01dfe  pg-exporter_1.0.0_arm64.deb

v0.9.0

Default Metrics Collector

• 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 collector run on replica since 16/17
• refactor pg_wait collector to agg from all processes
• restrict pg_clustering, pg_indexing, pg_vacuuming run on primary
• mark all reset_time as GAUGE rather than COUNTER
• fix pg_recovery_prefetch_skip_fpw type from GAUGE to COUNTER
• fix pg_recv.state type from LABEL to GAUGE
• Format collector in compact mode
• new default metric pg_exporter_build_info / pgbouncer_exporter_build_info
• add server_encoding to pg_meta collector
• add 12 new setting metrics to pg_setting collector
  • wal_block_size
  • segment_size
  • wal_segment_size
  • wal_level
  • wal_log_hints
  • work_mem
  • hugepage_count
  • hugepage_status
  • max_wal_size
  • min_wal_size
  • max_slot_wal_keep_size

Exporter Enhancement

• normalize collector branch name with min pg ver suffix
• Add license file to binary packages
• move pgsty/pg_exporter repo to pgsty/pg_exporter
• refactor server.go to reduce Compatible and PostgresPrecheck complexity
• rename metrics collector with extra number prefix for better sorting
• bump dependencies to the latest version
• execute fatal collectors ahead of all non-fatal collectors, and fail fast

New Logo

What's Changed

• Bump golang.org/x/net from 0.35.0 to 0.36.0 by @dependabot in #67
• Bump golang.org/x/net from 0.36.0 to 0.38.0 by @dependabot in #69

Full Changelog: v0.8.0...v0.9.0

Checksums

d16ab74dc1660edbc5ffbf0ebf288d7f  pg-exporter_0.9.0_amd64.deb
544e1d25adda2d848820981a0e0ee278  pg-exporter_0.9.0_arm64.deb
f3a94fcfbf740fe184f23b6df5baa2df  pg_exporter-0.9.0-1.aarch64.rpm
8a7b16c104f05c04b81ca5aaf41852d8  pg_exporter-0.9.0-1.x86_64.rpm
129889eca0473b576e7eda81e4ee9325  pg_exporter-v0.9.0.darwin-amd64.tar.gz
92cd952348557f73d805b7e3acc485a3  pg_exporter-v0.9.0.darwin-arm64.tar.gz
1a1b92836fb31350c767436604364bf9  pg_exporter-v0.9.0.linux-amd64.tar.gz
66687fe9549226ffc35ca72697e2efef  pg_exporter-v0.9.0.linux-arm64.tar.gz

v0.8.1 routine update

• Bump dependencies to the latest version
• Bump golang.org/x/net from 0.35.0 to 0.36.0 #67
• Update docker images building tags

456f4341bad658f5f2c90803f82e521e  pg-exporter_0.8.1_amd64.deb
38f834ff4397e46f09f2efce6310fe19  pg-exporter_0.8.1_arm64.deb
7093648d70e2828456e781e5d07cfde4  pg_exporter-0.8.1-1.aarch64.rpm
df6b0d2c108c402c18477fe4cb6844c8  pg_exporter-0.8.1-1.x86_64.rpm
2f837aab8aae8860b532829669b4f785  pg_exporter-v0.8.1.darwin-amd64.tar.gz
5d83791bd136d833b4c94847b02c814f  pg_exporter-v0.8.1.darwin-arm64.tar.gz
3052b34327305f0fe3095423e4b30d92  pg_exporter-v0.8.1.linux-amd64.tar.gz
d639561b1c8a41b6d899d102ca40f64a  pg_exporter-v0.8.1.linux-arm64.tar.gz