Release Notes
The latest stable pg_exporter release is v1.6.1.
| Version | Date | Summary | GitHub |
|---|---|---|---|
| v1.6.1 | 2026-11-11 | Table statistics fixes, duplicate scalar isolation, connection fixes, systemd reload, Go 1.27.4 | v1.6.1 |
| v1.6.0 | 2026-11-09 | Decoupled health probe, bounded scrapes, progress label and container CA fixes | v1.6.0 |
| v1.5.0 | 2026-10-23 | Connection safety, discovery, health and replication fixes; Go 1.27.3 | v1.5.0 |
| v1.4.1 | 2026-07-29 | Subscription count and label validation fixes; RPM rename | v1.4.1 |
| v1.4.0 | 2026-07-18 | Snapshot histograms, pg_xact_age collector, HTTP hardening | v1.4.0 |
| v1.3.0 | 2026-06-24 | PostgreSQL 19 support, new PG19 collectors and branches | v1.3.0 |
| v1.2.2 | 2026-04-14 | Routine Go 1.26.2 refresh, no functional changes | v1.2.2 |
| v1.2.1 | 2026-03-21 | Config style cleanup, Go 1.26.1 refresh | v1.2.1 |
| v1.2.0 | 2026-02-12 | Hot reload, non-blocking startup, PG9.x legacy support | v1.2.0 |
| v1.1.2 | 2026-01-16 | fix pg_timeline conf issue, build with latest deps | v1.1.2 |
| v1.1.1 | 2025-12-30 | New pg_timeline collector, pg_sub_16 branch, bug fixes | v1.1.1 |
| v1.1.0 | 2025-12-15 | Update default metrics collectors, bump to go 1.25.5 | v1.1.0 |
| v1.0.3 | 2025-11-20 | Routine update on 1.25.4, fix unsupported libpq env | v1.0.3 |
| v1.0.2 | 2025-08-14 | Build for more os arch with goreleaser | v1.0.2 |
| v1.0.1 | 2025-07-17 | DockerHub images, Go 1.24.5, disable pg_tsdb_hypertable | v1.0.1 |
| v1.0.0 | 2025-05-06 | PostgreSQL 18 support, new WAL/checkpointer/I/O metrics | v1.0.0 |
| v0.9.0 | 2025-04-26 | TimescaleDB, Citus, pg_wait_sampling collectors | v0.9.0 |
| v0.8.1 | 2025-02-14 | Dependencies update, docker image tags | v0.8.1 |
| v0.8.0 | 2025-02-14 | PgBouncer 1.24 support, Go 1.24, logging refactor | v0.8.0 |
| v0.7.1 | 2024-12-29 | Routine update, configuration as Reader support | v0.7.1 |
| v0.7.0 | 2024-08-13 | PostgreSQL 17 support, predicate queries feature | v0.7.0 |
| v0.6.0 | 2023-10-18 | PostgreSQL 16 support, ARM64 packages, security fixes | v0.6.0 |
| v0.5.0 | 2022-04-27 | RPM/DEB builds, column scaling, metrics enhancements | v0.5.0 |
| v0.4.1 | 2022-03-08 | Collector updates, connect-timeout parameter | v0.4.1 |
| v0.4.0 | 2021-07-12 | PostgreSQL 14 support, auto-discovery feature | v0.4.0 |
| v0.3.2 | 2021-02-01 | Shadow DSN fixes, documentation updates | v0.3.2 |
| v0.3.1 | 2020-12-04 | Configuration fixes for older PostgreSQL versions | v0.3.1 |
| v0.3.0 | 2020-10-29 | PostgreSQL 13 support, REST APIs, dummy server | v0.3.0 |
| v0.2.0 | 2020-03-21 | YUM packages, configuration reload support | v0.2.0 |
| v0.1.2 | 2020-02-20 | Dynamic configuration reload, bulky mode | v0.1.2 |
| v0.1.1 | 2020-01-10 | Startup hang bug fix | v0.1.1 |
| v0.1.0 | 2020-01-08 | Initial stable release | v0.1.0 |
| v0.0.4 | 2019-12-20 | Production tested release | v0.0.4 |
| v0.0.3 | 2019-12-14 | Production environment testing | v0.0.3 |
| v0.0.2 | 2019-12-09 | Early testing release | v0.0.2 |
| v0.0.1 | 2019-12-06 | Initial release with PgBouncer mode | v0.0.1 |
v1.6.1
Released on 2026-11-11.
PG Exporter v1.6.1 is a maintenance release that corrects table statistics, isolates collector errors that could break a whole scrape, and fixes connection edge cases. The build toolchain moves to Go 1.27.4, while the PostgreSQL driver remains lib/pq 1.12.3. Built-in SQL metric names, label keys, types, buckets, CLI flags, and HTTP routes are unchanged.
Fixes and Improvements
- Isolate duplicate scalar rows: if a
GAUGEorCOUNTERquery returns multiple rows with the same labels, mark that collector as failed and discard its output before Prometheus gathers it. Other collectors continue after nonfatal failures;fatal: trueretains its semantics. Histogram-only collectors still merge same-label observations into one snapshot distribution. Cross-collector metric conflicts still require configuration fixes. - Correct partitioned and unindexed table statistics: all four
pg_tableversion branches emitage = 0forrelfrozenxid = 0, including partitioned parents, instead of2147483647.tbl_scan,tup_read, andn_tup_modindividually coalesce nulls before addition, so missing index counts no longer suppress valid sequential-scan statistics. Null live/dead/modified row estimates become zero rather than NaN. - Avoid temporary-table size failures:
pg_table_sizeexcludespg_temp*andpg_toast*, avoiding reads of other sessions’ temporary tables and separate TOAST accounting. The source tag also fixes OID 0 errors in PostgreSQL 9.1 legacy configuration for tables without TOAST, preventing loss of the entire table-size metric set. Download legacy configuration separately. - Correct activity durations and TimescaleDB identifiers:
pg_activityclamps negative durations to zero when state, transaction, or session timestamps exceed the query time reference. Disabled-by-defaultpg_tsdb_hypertablecorrectly quotes schema/table names containing uppercase or special characters. HELP text is aligned for transaction/session start, index build stages, checkpoint counts, and table main-fork sizes. - Fix connection URLs and log redaction: hostless URLs such as
postgresql://?host=/var/run/postgresqlretain//during normalization so lib/pq recognizes them. Auto-discovery removes conflictingservice=when selecting a child database. Logs also redactsslpassword=. - Improve connection-pool cleanup: after removing or replacing child targets, auto-discovery waits for active collection before closing old pools. Closing clears pool references and safely handles uninitialized or already-closed pools. Reload still reuses existing pools and clears collection plans rather than recreating all child connections.
- Strengthen validation and built-in metric handling: configuration rejects nonfinite
scale/default, and startup rejects invalid--namespace. Invalid built-in labels, such as non-UTF-8 database names, produce warnings and skip samples instead of panicking. Constant user labels cannot override reserved build fields such asversionandrevision. - Fix diagnostics and direct-call edge cases: HTML explain pages display predicate cache TTL correctly. Direct collector calls execute queries for cold caches or zero TTL even without a server scrape timestamp. Explicit
Server.Plan(...)preserves same-name versioned queries by branch key. - Update builds and service management: packaged systemd units add
ExecReloadforsystemctl reload pg_exporter. Standalone Docker builds accept version, branch, revision, and build-date arguments;make docker-buildsupplies them. Ordinary builds without arguments retainHEAD/unknownrevision/date values. The toolchain moves to Go 1.27.4 with routine dependency updates.
Upgrade Notes
- Upgrade the binary and merge collector YAML. Packages preserve locally modified
/etc/pg_exporter.ymland/etc/default/pg_exporter. Deploy the new SQL to obtain table statistics, activity duration, and TimescaleDB fixes. Default configuration still has 58 YAML files, 96 branches, 59 namespaces, and 460 deduplicated metric definitions. - Review custom collectors. Scalar queries need one row per label set;
scaleanddefaultmust be finite. Histogram-only queries can still return multiple observations per label set. Partitioned-parent freeze age is now zero, and unindexed table totals or previously NaN row estimates may change. - Update service units and restart after upgrading the binary. Run
sudo systemctl daemon-reloadafter installing the new unit, thensudo systemctl restart pg_exporterfor a new binary or process arguments. Later YAML-only changes can usesudo systemctl reload pg_exporterorPOST /reload. - Download legacy YAML separately for PostgreSQL 9.1–9.6. Use configuration from v1.6.1 or main at
282e19dor later. Binary archives and RPM/DEB packages still bundle only PostgreSQL 10+ defaults.
When upgrading from v1.5.0 or earlier, also review v1.6.0 health probes, scrape budgets, and cross-database progress labels, plus v1.5.0 subscription labels, receiver states, and PostgreSQL 10–13 privileges. See the full metric compatibility matrix.
Verification Scope
The v1.6.1 tag points to d0dead1. CI and Release workflows passed module/generated-config checks, the full race suite, Go 1.21 HTTP mux compatibility, go vet, six-target cross-compilation, container checks, and package/checksum checks. Regressions cover duplicate scalar isolation, direct cold-cache/zero-TTL collection, namespaces/build labels, hostless URLs, service= removal, sslpassword redaction, predicate HTML rendering, finite configuration values, and SQL invariants.
Release acceptance covers 12 public artifacts and checksums, amd64/arm64 Docker images, ARM64 DEB installation on Debian 12, ARM64 RPM installation on Rocky Linux 9, and real non-superuser scrapes against PostgreSQL 10–18 and 19 RC1 primaries, PostgreSQL 18 and 19 RC1 streaming replicas, PgBouncer 1.26.1, and PostgreSQL 9.1–9.6 with separate legacy configuration. Scenarios include discovery/database removal, HTTP/SIGHUP reload, pg_stat_statements, unindexed/partitioned/temporary tables, and active transactions. Legacy acceptance does not imply backporting modern pg_temp* filtering or COALESCE fixes. Windows, Linux ppc64le, and Intel macOS were covered only by builds/checksums; package container checks do not prove real systemd startup. PostgreSQL 19 evidence is limited to RC1, not all later builds or production workloads. Experimental snort is not included in v1.6.1.
SHA-256 Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter-1.6.1-1.aarch64.rpm Linuxarm64SHA-256 | d0612ad9…0277 | |
| pg-exporter-1.6.1-1.ppc64le.rpm LinuxSHA-256 | 73fe4587…b9b5 | |
| pg-exporter-1.6.1-1.x86_64.rpm Linuxamd64SHA-256 | c20c8a80…2c82 | |
| pg-exporter_1.6.1-1_amd64.deb Linuxamd64SHA-256 | 0d6fe86a…e5fc | |
| pg-exporter_1.6.1-1_arm64.deb Linuxarm64SHA-256 | a055f9a7…2ab4 | |
| pg-exporter_1.6.1-1_ppc64le.deb LinuxSHA-256 | f8500d01…8d4c | |
| pg_exporter-1.6.1.darwin-amd64.tar.gz macOSamd64SHA-256 | 496c42f3…2774 | |
| pg_exporter-1.6.1.darwin-arm64.tar.gz macOSarm64SHA-256 | 9ace0b48…c662 | |
| pg_exporter-1.6.1.linux-amd64.tar.gz Linuxamd64SHA-256 | e8fdf64c…1fdf | |
| pg_exporter-1.6.1.linux-arm64.tar.gz Linuxarm64SHA-256 | 91da5400…333b | |
| pg_exporter-1.6.1.linux-ppc64le.tar.gz LinuxSHA-256 | 769e9e56…a5fb | |
| pg_exporter-1.6.1.windows-amd64.tar.gz Windowsamd64SHA-256 | 0e118a98…1066 |
GitHub release · SHA256 checksums · Full changes · Collector documentation
v1.6.0
Release date: 2026-11-09.
PG Exporter v1.6.0 decouples health probing from metrics scrapes, bounds overlapping scrapes and waits, preserves completed bounded refreshes when a client disconnects, and fixes cross-database progress labels. It also adds container trust roots and refreshes dependencies. The release builds with Go 1.27.3 and lib/pq 1.12.3.
Fixes and Improvements
- Independent health probe: slow metrics scrapes no longer block the background probe, and finishing scrapes no longer overwrite newer reachability or role observations. After initialization, HTTP health state is written only by the probe;
pg_upandpg_in_recoverystill reflect scrape outcomes./upcan return HTTP 200 while a fatal collector setspg_upto0if the database remains reachable. - Bounded scrape admission: at most two metrics requests are admitted across collection, waiting, and response writing. Scrapes still run serially; one request can wait and reuse warm cache, and further requests receive HTTP 503. Waiting is cancelable and starts no SQL work. Request budgets default to 30 seconds and honor a valid, finite, positive Prometheus scrape-timeout header when shorter.
- Collector-boundary cancellation: after request cancellation, no further collector or database starts. An already started collector with a positive timeout keeps its shared predicate-and-query deadline and caches a successful refresh instead of poisoning shared cache for later scrapers. A negative timeout disables the collector deadline, so SQL cancels with the request.
- Separate interruption from target errors: interrupted rounds log INFO
interruptedand do not increment exporter or server scrape error counters. Availability retains its prior value, or becomes true after the current precheck succeeds. Uncanceled connection failures and fatal collector failures still count as errors. Query-level error counters and fatal-query ERROR logs keep their existing behavior. - Accurate progress labels:
pg_vacuuming,pg_indexing, andpg_clusteringremain cluster-wide and keep three queries per refresh. Relations in the connected database and shared catalogs resolve to names; user relations in other databases emit the numeric OID asrelnamewhile keepingdatnameandpid, preventing accidental local OID name collisions. Auto-discovery filters or missingCONNECTprivilege do not hide rows visible in the progress views. - Container trust bundle: both scratch image build paths include the system CA bundle and license, allowing public-CA TLS verification out of the box. Private CAs still require a mounted certificate and
sslrootcert; default TLS mode is unchanged. - Dependencies and release checks: move YAML from v3 to v4 while keeping existing collector configuration syntax, and update Prometheus common/procfs,
golang.org/x/net, and related dependencies. CI validates container file/TLS behavior and all three DEB architectures in addition to RPM compatibility and checksums. - Aligned metric help text: clarify I/O byte vs operation counts, completed checkpoints, VACUUM dead-tuple memory, and CLUSTER progress. SQL metric names, label keys, types, and units are unchanged on the same PostgreSQL version.
Upgrade Notes
- Upgrade configuration and binary together. Merge the updated
pg_exporter.ymlor split YAML files; package upgrades keep local config files. Replacing only the binary does not apply the progress SQL fix. The default bundle remains 58 YAML files, 96 branches, 59 namespaces, and 460 distinct metric definitions, including disabled collectors and two unexpanded histograms. - Review progress-label consumers. Cross-database
relnamevalues can change from an incorrect local name to a numeric OID, creating new time series; keepdatnameandpidin panels. Current-database and shared-catalog relation names remain readable. - Choose the right health signal.
/upand role endpoints reflect the latest health probe;pg_upreflects primary-target scrapes, including fatal collector failures. Inspect query and server metrics for non-fatal and child-database errors.--disable-introsuppresses all built-in metrics, includingpg_up, while keeping HTTP health checks active. - Account for the PgBouncer probe connection. The PgBouncer pool limit increases from one connection to two. PostgreSQL remains three on the main target and one per discovered database.
- Keep positive timeouts on fatal collectors. Canceling a negative-timeout fatal query caches a failure under the normal TTL. Later active scrapes can count that cached failure and report
pg_up 0until a refresh succeeds. Zero TTL or--disable-cachestill forces refresh on every scrape. - Review concurrency and budgets. Excess concurrent scrapes or interrupted scrapes can return 503. An already started bounded collector can overrun the request budget by roughly its own timeout; network stalls can extend longer, and neither deadline is a hard wall-clock cap. Configure a sensible
connect_timeoutin the DSN for connection handshakes.
A real failure that overlaps request cancellation can be omitted from the two round error counters because classification checks both scrape error and request context; query-level failure counters remain visible. If the first scrape is interrupted before precheck succeeds, pg_up stays 0 until a later scrape recovers. Failure TTL, reload, and immediate SIGTERM exit semantics are unchanged; this release adds no background refresh or graceful shutdown.
When upgrading from v1.4.1 or earlier, also apply the v1.5.0 migration notes, including subscription labels, receiver state mappings, and the PostgreSQL 10–13 monitoring grant. For the full runtime contract, see Compatibility, HTTP API, and Scrape Lifetime.
Verification Scope
Release verification covered the full race test suite, both HTTP mux modes, module and generated-config consistency, static analysis, six-platform builds, container TLS/file checks, and package validation. Three cancellation regressions also passed 200 consecutive race-enabled iterations; a negative control with the interruption fix removed failed earlier. On PostgreSQL 18.6, a client disconnecting during a 0.8s bounded fatal query left both round error counters at 0, and the next scrape returned pg_up 1 with cached metrics without re-running SQL.
Local acceptance against the release artifacts also covered PostgreSQL 9.2–9.6 (legacy config), 10–18 and 19 RC1 (default config), and PgBouncer 1.26.1. Linux amd64/arm64/ppc64le tarballs and RPM/DEB packages passed runtime and install checks; ARM64 package upgrades from 1.5.0 preserved local configuration. Docker Hub 1.6.0 and latest point to the same amd64/arm64 multi-arch manifest; pulled public images passed CA, file, and TLS checks, and their binaries matched the corresponding release tarballs byte-for-byte. All 24 functional test groups passed on Darwin ARM64, including HTTPS auth, reload overlap, standby promotion, and disconnect recovery. Windows and Intel macOS received static binary checks only; container package tests did not exercise real systemd service startup.
Progress SQL branches were verified with the monitoring role on PostgreSQL 12, 17, and 18, with supplementary shared-catalog cases and a live cross-database VACUUM checked on 18.6. These are bounded acceptance results, not a complete re-audit of every PostgreSQL version, extension, dashboard, or production workload. Composite, Patroni, pgBackRest, and PostgreSQL-log components remain on the separate snort line and are not part of v1.6.0.
SHA-256 Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter-1.6.0-1.aarch64.rpm Linuxarm64SHA-256 | dd81e485…1ed9 | |
| pg-exporter-1.6.0-1.ppc64le.rpm LinuxSHA-256 | 413f64b2…48ae | |
| pg-exporter-1.6.0-1.x86_64.rpm Linuxamd64SHA-256 | c25e5707…c64a | |
| pg-exporter_1.6.0-1_amd64.deb Linuxamd64SHA-256 | 46f03078…17b3 | |
| pg-exporter_1.6.0-1_arm64.deb Linuxarm64SHA-256 | d24dea8e…2a0f | |
| pg-exporter_1.6.0-1_ppc64le.deb LinuxSHA-256 | 5cc839bc…3ae0 | |
| pg_exporter-1.6.0.darwin-amd64.tar.gz macOSamd64SHA-256 | ddefa112…ea47 | |
| pg_exporter-1.6.0.darwin-arm64.tar.gz macOSarm64SHA-256 | a62d9474…4d85 | |
| pg_exporter-1.6.0.linux-amd64.tar.gz Linuxamd64SHA-256 | 296a26bf…719a | |
| pg_exporter-1.6.0.linux-arm64.tar.gz Linuxarm64SHA-256 | ea6d1dbe…7ce7 | |
| pg_exporter-1.6.0.linux-ppc64le.tar.gz LinuxSHA-256 | b720183a…155a | |
| pg_exporter-1.6.0.windows-amd64.tar.gz Windowsamd64SHA-256 | 29909ef6…bb25 |
GitHub release · SHA256 checksums · Full changelog · Complete collector reference
v1.5.0
Release date: 2026-10-23. This release improves connection security, collection accuracy, and runtime state consistency, and upgrades the build toolchain to Go 1.27.3.
Fixes and Improvements
- Validate PostgreSQL URLs and query parameters strictly. Reject malformed escapes and parameter names containing whitespace or
=. Safe diagnostics prevent malformed connection strings from leaking passwords into logs or silently discarding explicit TLS settings. An empty or whitespace-only file selected throughPG_EXPORTER_URL_FILEnow prevents startup. - Resolve database identities with
lib/pq. Auto-discovery removes conflictingdbname/databasequery parameters when replacing a database name and preserves special characters, fixing duplicate collection and HTTP 500 responses caused by duplicate metrics. - Generate each health response’s HTTP status and body from one atomic state snapshot, fixing contradictory responses during concurrent state transitions. Health checks still use background cached state.
- Replan after a successful precheck detects changes to the username, schemas, or extensions. Unchanged metadata preserves plans and caches. Adding or removing a schema or extension no longer requires manual reload.
- Reject NaN, infinities, and overflowing TTLs or positive timeouts during configuration loading. Preserve the existing meanings of zero TTL (disable caching), zero timeout (use the default), and finite negative timeout (disable the deadline).
- Verify at startup that the active HTTP mux routes the metrics path to the metrics handler. Reject escaped paths that would return the landing page or a redirect under the legacy mux.
- Add the owning database’s
datnamelabel topg_sub_*, preventing collisions between identically named subscriptions in different databases. Correctpg_recv_statecodes in the current and legacy bundles, and fix receiver address extraction on PostgreSQL 9.6. - Clarify
pg_originpermissions, the table scope ofpg_pubrel_count, synchronization states and PostgreSQL 19 sequence semantics inpg_subrel_count, and thepg_backenddescription.
Metric and dashboard compatibility
Compared with v1.4.1 on the same PostgreSQL version, v1.5.0 does not add, remove, or rename bundled SQL metric names. Types and units remain unchanged, but labels and state mappings do change. PostgreSQL 19 support first shipped in v1.3.0; upgrading the database can also change the selected SQL branch and a metric’s meaning.
| Scope | Metrics | Compatibility action |
|---|---|---|
| v1.5.0 configuration | pg_sub_* | Adds datname to every sample. Keep database and subscription identity in joins and aggregations; new label sets create new time series. |
| v1.5.0 configuration | pg_recv_state | Real receiver states starting, waiting, restarting, and stopped now map to 6–9 instead of -1. Update value mappings and state alerts; codes 1–3 are reserved. |
| PG18 → PG19 | Existing PG18 metric names | None are removed or renamed by the PG19 branches in this bundle. This does not guarantee unchanged semantics or labels from PostgreSQL itself. |
| PG19 | pg_sub_sync_error_count | Keeps the name but becomes the sum of table and sequence synchronization errors. For table-only alerts, use pg_sub_sync_table_error_count; pg_sub_sync_seq_error_count reports the sequence component. Do not double-count the components and their sum. |
| PG19 | pg_sub_has_worker, pg_sub_reset_time, pg_sub_confl_* | Adds worker presence, reset time, and eight conflict counters. The subscription row can remain without an apply worker; metric presence alone is not a worker-health check. |
| PG19 | pg_subrel_count | Includes sequences as well as tables; pg_pubrel_count still counts tables only. Review panel labels and count comparisons. |
| PG19 | pg_wal_fpi_bytes, pg_lock_stat_*, pg_recovery_state_*, pg_vacuum_score_* | Additive metrics. Recovery state is replica-only; autovacuum scores are primary-only. Existing WAL, lock-distribution, and recovery families remain. |
Users upgrading from PG17 or earlier must also migrate older names: checkpoint metrics left pg_bgwriter_* in PG17, and pg_wal_write, pg_wal_sync, pg_wal_write_time, and pg_wal_sync_time are absent from PG18 onward. The full compatibility guide lists each replacement, label/aggregation differences, and mixed-version PromQL.
Before rollout, evaluate the actual dashboard and alert expressions and test missing-series input. A successful scrape does not ensure every expected metric exists; an empty alert expression can silently stop firing. The missing-metric checks include a per-target rule and explain when absence is expected. The full PG19 metric table links to the tagged collector definitions; PostgreSQL validation remains scoped to 19 RC1.
Upgrade Notes
- On PostgreSQL 10–13, an administrator must run
GRANT SELECT (oid) ON pg_catalog.pg_subscription TO monitor;in the exporter’s main connection database, substituting the actual monitoring role. This does not exposesubconninfo. PostgreSQL 14+ needs no extra grant under standard catalog ACLs. - The new
datnamelabel onpg_sub_*creates new time series. Review PromQL joins, aggregations, and alerts that match these labels. Thepg_sub_idgauge is retained. pg_recv_stateuses the following codes; 1–3 remain reserved. No receiver row means no sample. PostgreSQL 9.6 still hides receiver details from ordinary monitoring roles, resulting in an unknown state; the exporter does not expand database privileges.
| State | Code | State | Code |
|---|---|---|---|
| streaming | 0 | starting | 6 |
| stopping | 4 | waiting | 7 |
| connecting (PG19+) | 5 | restarting | 8 |
| unknown / NULL | -1 | stopped | 9 |
- Upgrade both the binary and collector configuration. Packages preserve local configuration changes: merge the new
pg_exporter.yml, then check query error counters in/metrics. HTTP 200 alone does not establish a successful scrape. - Reloading empty YAML still clears collectors, and directory loading still permits valid files to load when others fail. SIGTERM retains immediate process termination; it does not wait for active scrapes to complete.
Toolchain and Validation
Retain lib/pq 1.12.3 and upgrade Prometheus client_golang to 1.25.0, common to 0.72.1, and exporter-toolkit to 0.20.0. YAML uses go.yaml.in/yaml/v3 3.0.5. The PostgreSQL driver remains lib/pq.
The default bundle still contains 58 YAML files, 96 branches, 59 namespaces, and 460 distinct metric definitions, including two unexpanded histograms. Validation covered non-superuser collection on PostgreSQL 9.1–9.6, 10–18, 19 RC1, and PgBouncer 1.26.1; physical standby promotion, reloads, disconnect recovery, races, both HTTP mux modes, six-platform builds, ARM64 RPM/DEB installation, and Docker images. PostgreSQL 19 testing used RC1; this does not cover every extension or production workload.
Go and Dependency Security Updates
Go 1.27.3 adds a blocklist for untrusted intermediate certificates in crypto/x509, addressing CVE-2026-111943. It also includes security fixes accumulated since the previous Go 1.26.5 build, including TLS issues CVE-2026-56862 and CVE-2026-97031, HTTP issues CVE-2026-56853 and CVE-2026-94439, and template, ASN.1, and multipart fixes. See the complete upstream scope in the Go 1.26.6, Go 1.27.2, and Go 1.27.3 announcements.
golang.org/x/net moves from 0.57.0 to 0.61.0, including five HTTP/2 fixes introduced in 0.60.0:
| CVE | Fix |
|---|---|
| CVE-2026-78659 | Memory amplification through Trailer headers |
| CVE-2026-78669 | CPU consumption through window updates |
| CVE-2026-78663 | Duplicate flow-control credit refunds |
| CVE-2026-97032 | HPACK encoder race and crash |
| CVE-2026-78660 | Malformed framing response headers |
x/crypto 0.58.0 also crosses the fixes for SSH issues CVE-2026-56854, CVE-2026-56855, and CVE-2026-78662. x/text 0.43.0 includes the precis fix CVE-2026-56851. The exporter does not import these SSH/precis packages; these are dependency-version updates, not confirmed exporter runtime vulnerabilities.
Comparative govulncheck runs on 2026-10-23 found no known symbol-level or imported-package-level vulnerabilities in the new candidate for Darwin, Linux, or Windows. The unimported OpenPGP package retains a module-level advisory, GO-2026-5932. Static symbol matches are not exploit reproductions, and including upstream fixes does not establish that every issue was exploitable in the exporter. Other dependency upgrades are maintenance updates. Install the rebuilt release binary; upgrading Go on the host does not change an existing binary.
For the full CVE table, first fixed versions, and scan levels, see the security update verification.
SHA-256 Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter-1.5.0-1.aarch64.rpm Linuxarm64SHA-256 | 4cb1dfbb…b980 | |
| pg-exporter-1.5.0-1.ppc64le.rpm LinuxSHA-256 | c7efed8a…f7eb | |
| pg-exporter-1.5.0-1.x86_64.rpm Linuxamd64SHA-256 | 6788c7cb…e1b3 | |
| pg-exporter_1.5.0-1_amd64.deb Linuxamd64SHA-256 | 91f705bb…e28f | |
| pg-exporter_1.5.0-1_arm64.deb Linuxarm64SHA-256 | 75dd27cd…47bd | |
| pg-exporter_1.5.0-1_ppc64le.deb LinuxSHA-256 | f41acf76…faf1 | |
| pg_exporter-1.5.0.darwin-amd64.tar.gz macOSamd64SHA-256 | f3e5d03d…6975 | |
| pg_exporter-1.5.0.darwin-arm64.tar.gz macOSarm64SHA-256 | 3fb47e28…0e8d | |
| pg_exporter-1.5.0.linux-amd64.tar.gz Linuxamd64SHA-256 | e372f6de…ef56 | |
| pg_exporter-1.5.0.linux-arm64.tar.gz Linuxarm64SHA-256 | 19f34db9…1cde | |
| pg_exporter-1.5.0.linux-ppc64le.tar.gz LinuxSHA-256 | aef7e910…5ac2 | |
| pg_exporter-1.5.0.windows-amd64.tar.gz Windowsamd64SHA-256 | cf39b3ec…1d9f |
GitHub release · SHA256 checksums · Full changelog · Complete collector reference
v1.4.1
v1.4.1 is a maintenance release focused on metric accuracy and RPM upgrade compatibility.
Highlights:
- Fix
pg_subrel_countovercounting with parallel logical replication apply workers. Deduplicatepg_stat_subscriptionby subscription ID and name before aggregating subscription relation states. - If a query result omits a configured
LABELcolumn, fail the entire collector scrape. Do not emit an empty label or keep stale results. Other non-fatal collectors continue normally. - Rename the official RPM package and artifact prefix from
pg_exportertopg-exporter. The new package provides and obsoletes the legacy name to support direct upgrades. - Update version and standalone package metadata. Add regression tests for missing labels. Validate RPM configuration, artifact names, and compatibility metadata in CI.
Upgrade Notes:
- Custom collector SQL must return every
LABELcolumn. The result schema must be complete even if the query returns zero rows. - If automation matches GitHub RPM file names directly, change
pg_exporter-*.rpmtopg-exporter-*.rpm.
Checksums
https://github.com/pgsty/pg_exporter/releases/download/v1.4.1/checksums.txt
| File | Checksum | |
|---|---|---|
| pg-exporter-1.4.1-1.aarch64.rpm Linuxarm64SHA-256 | 7648f185…2f13 | |
| pg-exporter-1.4.1-1.ppc64le.rpm LinuxSHA-256 | 09037731…6631 | |
| pg-exporter-1.4.1-1.x86_64.rpm Linuxamd64SHA-256 | 8dbf85ff…1a93 | |
| pg-exporter_1.4.1-1_amd64.deb Linuxamd64SHA-256 | cbe06eb1…1f38 | |
| pg-exporter_1.4.1-1_arm64.deb Linuxarm64SHA-256 | 36bc07ef…5cff | |
| pg-exporter_1.4.1-1_ppc64le.deb LinuxSHA-256 | 8228e6a9…7aad | |
| pg_exporter-1.4.1.darwin-amd64.tar.gz macOSamd64SHA-256 | e6de4c89…76f4 | |
| pg_exporter-1.4.1.darwin-arm64.tar.gz macOSarm64SHA-256 | 6fe0b193…a79f | |
| pg_exporter-1.4.1.linux-amd64.tar.gz Linuxamd64SHA-256 | f2f952db…a340 | |
| pg_exporter-1.4.1.linux-arm64.tar.gz Linuxarm64SHA-256 | e111974a…e8b4 | |
| pg_exporter-1.4.1.linux-ppc64le.tar.gz LinuxSHA-256 | 7b8679de…4469 | |
| pg_exporter-1.4.1.windows-amd64.tar.gz Windowsamd64SHA-256 | 93c0231f…1db4 |
https://github.com/pgsty/pg_exporter/releases/tag/v1.4.1
v1.4.0
v1.4.0 adds Snapshot Histogram metrics and the pg_xact_age transaction age collector.
It also improves HTTP routing, packaging, and the build toolchain.
New Features:
- Add the
HISTOGRAMcolumn type. It aggregates SQL snapshots by label group into classic Prometheus histograms with_bucket/_count/_sumseries. Configuration loading validates finite bucket bounds in strictly increasing order and appends+Infautomatically. Thelelabel is reserved. Hot reload is supported. - Add the
pg_xact_agecollector. It returns open transaction age (pg_xact_age_seconds) and idle-in-transaction age (pg_xact_age_idle_seconds) as histograms. It collects cluster-level data from client backends only, with a 10s TTL. - Increase the default bundle from 57 to 58 definition files. Assign
pg_xact_ageto slot0450. Renumberpg_lock/pg_lock_stat/pg_queryto0460/0470/0480without content changes.
Fixes & Improvements:
- Register HTTP routes in a private ServeMux instead of the global
DefaultServeMux. This prevents accidental exposure of endpoints from third-party libraries. - Validate
--web.telemetry-pathat startup. Reject empty paths, paths without a leading/, paths with?#{}, and conflicts with built-in endpoints. Also reject non-canonical paths such as//metrics, which cannot match requests. Each failure returns a clear error immediately. - Escape the telemetry path in the landing page HTML.
- Close the primary connection pool if the
--fail-fastpre-check fails. - Fix RPM / DEB packaging (#105). Set the
prometheususer’s HOME to/var/lib/prometheus, where libpq looks for~/.pgpass. Add/postgresto the packaged default URL. This prevents libpq from using a database named after the OS user. - Use the
vversion prefix consistently. Official release binaries reportv1.4.0in--version,/version, andpg_exporter_build_info{version=...}. GoReleaser artifacts previously reported1.3.0without the prefix. Artifact file names, package versions, and Docker image tag conventions do not change. - Apply the same value conversion rules to histograms and scalar columns. Exclude timestamps and booleans from
scale. - Correct GoReleaser package metadata to show support for PostgreSQL
9.x - 19+and pgBouncer1.8 - 1.25+. - Restore
GOPROXY/GOSUMDBbuild-argument passthrough inmake docker.
Engineering & Build:
- Update the build toolchain to Go
1.26.5, exporter-toolkitv0.17.1, and prometheus/commonv0.70.0. - Add regular CI checks for module tidy, generated configuration, race tests, and six-platform cross-builds. The
make confoutput must matchconfig/*.yml. - Remove the
docker/scripts andmake docker-release. Use GoReleaser to build multi-architecture release images. - Remove assumptions about specific collectors from configuration coverage tests. This makes smaller custom bundles easier to maintain.
Upgrade Notes:
- A non-canonical telemetry path, such as
//metrics, now prevents startup. Previously, the process started but the metrics endpoint was unreachable. - Update automation that parses the
versionlabel ofpg_exporter_build_infoor the--versionoutput to accept thevprefix. - If any collector uses
HISTOGRAM, do not useleas a constant label.
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.4.0-1_amd64.deb Linuxamd64SHA-256 | c6af4ae6…a724 | |
| pg-exporter_1.4.0-1_arm64.deb Linuxarm64SHA-256 | ff0360f6…40d6 | |
| pg-exporter_1.4.0-1_ppc64le.deb LinuxSHA-256 | 4fbadd4e…68a1 | |
| pg_exporter-1.4.0-1.aarch64.rpm Linuxarm64SHA-256 | 5ce106d2…43fd | |
| pg_exporter-1.4.0-1.ppc64le.rpm LinuxSHA-256 | 870b434e…0600 | |
| pg_exporter-1.4.0-1.x86_64.rpm Linuxamd64SHA-256 | c550d16c…8488 | |
| pg_exporter-1.4.0.darwin-amd64.tar.gz macOSamd64SHA-256 | 11a34e53…6749 | |
| pg_exporter-1.4.0.darwin-arm64.tar.gz macOSarm64SHA-256 | 49d8d3a5…e26e | |
| pg_exporter-1.4.0.linux-amd64.tar.gz Linuxamd64SHA-256 | 113dfe70…333b | |
| pg_exporter-1.4.0.linux-arm64.tar.gz Linuxarm64SHA-256 | 68b4630a…2e18 | |
| pg_exporter-1.4.0.linux-ppc64le.tar.gz LinuxSHA-256 | 72710625…0979 | |
| pg_exporter-1.4.0.windows-amd64.tar.gz Windowsamd64SHA-256 | 14a0cf6f…db0b |
https://github.com/pgsty/pg_exporter/releases/tag/v1.4.0
v1.3.0
v1.3.0 adds PostgreSQL 19 support.
It also updates the default collectors, build toolchain, and configuration coverage tests.
Highlights:
- Default support range extended from PostgreSQL 10-18+ to 10-19+
- Default config bundle includes 57
config/*.ymldefinition files - Build dependencies updated to Go
1.26.4,lib/pq v1.12.3, Prometheus clientv1.23.2, and exporter-toolkitv0.16.0 pg_recovery_state: collectpg_stat_recoveryon recovery nodes, exposing promotion trigger status, replay LSN, timeline, recovery transaction time, and pause statepg_lock_stat: collect PG19pg_stat_lock, exposing waits, wait time, and fast-path overflow counts bylocktypepg_vacuum_score: collect the current-database summary frompg_stat_autovacuum_scores, exposing max autovacuum score and candidate table countpg_wal_19: exposewal_fpi_byteson PG19 aspg_wal_fpi_bytespg_sub_19: adapt sequence sync and logical replication conflict stats frompg_stat_subscription_stats, while keepingsync_error_countfor legacy dashboardspg_recv: recognize the PG13+ WAL receiverconnectingstate on PG19pg_slot: recognize the PG19 replication slot invalidation reasonidle_timeoutpg_db_confl: switch to an explicit column list to avoid accidentally exporting future view columnspg_backup,pg_vacuuming, andpg_clusteringcontinue reusing stable existing branches instead of changing the metric surface for low-value PG19 fields
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.3.0-1_amd64.deb Linuxamd64SHA-256 | dfc6d517…5569 | |
| pg-exporter_1.3.0-1_arm64.deb Linuxarm64SHA-256 | 3d2ff642…8092 | |
| pg-exporter_1.3.0-1_ppc64le.deb LinuxSHA-256 | 4cfe043e…6b5a | |
| pg_exporter-1.3.0-1.aarch64.rpm Linuxarm64SHA-256 | 3ae4f8c5…6faf | |
| pg_exporter-1.3.0-1.ppc64le.rpm LinuxSHA-256 | 71a00233…26ec | |
| pg_exporter-1.3.0-1.x86_64.rpm Linuxamd64SHA-256 | 316a97cc…2496 | |
| pg_exporter-1.3.0.darwin-amd64.tar.gz macOSamd64SHA-256 | 4ab312f2…4ccd | |
| pg_exporter-1.3.0.darwin-arm64.tar.gz macOSarm64SHA-256 | 2b20eb7b…d6bb | |
| pg_exporter-1.3.0.linux-amd64.tar.gz Linuxamd64SHA-256 | 7a2a8ce8…3ad7 | |
| pg_exporter-1.3.0.linux-arm64.tar.gz Linuxarm64SHA-256 | 696619d1…066d | |
| pg_exporter-1.3.0.linux-ppc64le.tar.gz LinuxSHA-256 | 0c16ac4a…475e | |
| pg_exporter-1.3.0.windows-amd64.tar.gz Windowsamd64SHA-256 | aa3724f4…b10d |
https://github.com/pgsty/pg_exporter/releases/tag/v1.3.0
v1.2.2
v1.2.2 updates the release toolchain to Go 1.26.2.
This maintenance release has no changes to collectors, configuration behavior, or runtime behavior.
Highlights
- Refresh the release toolchain: bump release builds to Go
1.26.2 - No functional changes: collector behavior, default configs, metric definitions, and runtime semantics remain unchanged
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.2.2-1_amd64.deb Linuxamd64SHA-256 | 273dfd45…dcc6 | |
| pg-exporter_1.2.2-1_arm64.deb Linuxarm64SHA-256 | 5e83c844…7f40 | |
| pg-exporter_1.2.2-1_ppc64le.deb LinuxSHA-256 | 97bb804b…a3b2 | |
| pg_exporter-1.2.2-1.aarch64.rpm Linuxarm64SHA-256 | b2f76799…0120 | |
| pg_exporter-1.2.2-1.ppc64le.rpm LinuxSHA-256 | f0ab3890…87e6 | |
| pg_exporter-1.2.2-1.x86_64.rpm Linuxamd64SHA-256 | 2000593d…c800 | |
| pg_exporter-1.2.2.darwin-amd64.tar.gz macOSamd64SHA-256 | e8a71704…0386 | |
| pg_exporter-1.2.2.darwin-arm64.tar.gz macOSarm64SHA-256 | e648d944…ec9c | |
| pg_exporter-1.2.2.linux-amd64.tar.gz Linuxamd64SHA-256 | f278aba9…9ede | |
| pg_exporter-1.2.2.linux-arm64.tar.gz Linuxarm64SHA-256 | bbeef564…0801 | |
| pg_exporter-1.2.2.linux-ppc64le.tar.gz LinuxSHA-256 | ad238527…dbe2 | |
| pg_exporter-1.2.2.windows-amd64.tar.gz Windowsamd64SHA-256 | 2ac53298…caf4 |
https://github.com/pgsty/pg_exporter/releases/tag/v1.2.2
v1.2.1
v1.2.1 is a maintenance release for release engineering, configuration package consistency, documentation, and metadata.
It has no changes to collector or runtime behavior.
Highlights
- Refresh the build toolchain: bump both release workflows and Docker build images to Go
1.26.1 - Standardize config style: switch inline
descriptionvalues in both current and legacy configs to double-quoted form, and regenerate mergedpg_exporter.yml/legacy/pg_exporter.yml - Add config consistency tests: verify split and merged configs remain equivalent, and check inline metric description style to reduce configuration drift
- Refresh packaging metadata: update RPM / DEB support descriptions to PostgreSQL
9.x - 18+and pgBouncer1.8 - 1.25+, and refresh Pigsty documentation links
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.2.1-1_amd64.deb Linuxamd64SHA-256 | 2cbe7a78…4649 | |
| pg-exporter_1.2.1-1_arm64.deb Linuxarm64SHA-256 | e70e0997…2585 | |
| pg-exporter_1.2.1-1_ppc64le.deb LinuxSHA-256 | 4e6c7fae…3d87 | |
| pg_exporter-1.2.1-1.aarch64.rpm Linuxarm64SHA-256 | 30103629…2a47 | |
| pg_exporter-1.2.1-1.ppc64le.rpm LinuxSHA-256 | 01b4dd32…b517 | |
| pg_exporter-1.2.1-1.x86_64.rpm Linuxamd64SHA-256 | 5afb4f14…de50 | |
| pg_exporter-1.2.1.darwin-amd64.tar.gz macOSamd64SHA-256 | 45e71c60…bcf5 | |
| pg_exporter-1.2.1.darwin-arm64.tar.gz macOSarm64SHA-256 | d3035cc6…6259 | |
| pg_exporter-1.2.1.linux-amd64.tar.gz Linuxamd64SHA-256 | 14d3f83d…a340 | |
| pg_exporter-1.2.1.linux-arm64.tar.gz Linuxarm64SHA-256 | 71082081…4fe1 | |
| pg_exporter-1.2.1.linux-ppc64le.tar.gz LinuxSHA-256 | cba30919…09e7 | |
| pg_exporter-1.2.1.windows-amd64.tar.gz Windowsamd64SHA-256 | 6fe528a2…38e9 |
https://github.com/pgsty/pg_exporter/releases/tag/v1.2.1
v1.2.0
v1.2.0 improves stability and compatibility for startup, hot reload, health probes, configuration validation, and legacy support.
New Features:
- Improve hot reload. Support platform-specific signals (
SIGHUP/SIGUSR1) and improvePOST /reloadto update configuration and query plans without a restart. - Use non-blocking startup. HTTP endpoints start even if the target precheck fails. This improves recovery and monitoring integration.
- Add a legacy configuration bundle for PostgreSQL 9.1-9.6. Use
legacy/and themake conf9target to configure monitoring for EOL versions. - Use cached health snapshots with periodic probes. This improves consistency for role-based health endpoints and reloads.
- Add
go testandgo vetto release workflows. Update the build toolchain to Go 1.26.0.
Bug Fixes:
- Fix configuration parsing cases. Reject malformed metric entries, return explicit errors if a configuration directory has no valid YAML, and improve runtime fallbacks.
- Fix CLI boolean parsing for arguments such as
--flag=false. - Fix
/explainoutput with corrected content types and safer template rendering. - Improve predicate queries and PG URL handling. Improve BOOL/BOOLEAN support, row resource handling, and
dbnamequery-parameter parsing and redaction. - Close connections asynchronously when auto-discovery removes a target.
- Fix metric and label validation. Check constant-label conflicts, scaled default values, and Prometheus naming rules.
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.2.0-1_amd64.deb Linuxamd64SHA-256 | 26e7a052…5f64 | |
| pg-exporter_1.2.0-1_arm64.deb Linuxarm64SHA-256 | 4ec21913…fafe | |
| pg-exporter_1.2.0-1_ppc64le.deb LinuxSHA-256 | 5b2cc00e…283e | |
| pg_exporter-1.2.0-1.aarch64.rpm Linuxarm64SHA-256 | d536d41a…e0d4 | |
| pg_exporter-1.2.0-1.ppc64le.rpm LinuxSHA-256 | b7a1daa2…e35c | |
| pg_exporter-1.2.0-1.x86_64.rpm Linuxamd64SHA-256 | 28bf7d85…99b5 | |
| pg_exporter-1.2.0.darwin-amd64.tar.gz macOSamd64SHA-256 | 51c3b3d1…db8c | |
| pg_exporter-1.2.0.darwin-arm64.tar.gz macOSarm64SHA-256 | 3ba1c7ad…b077 | |
| pg_exporter-1.2.0.linux-amd64.tar.gz Linuxamd64SHA-256 | 9e1ec6c1…843e | |
| pg_exporter-1.2.0.linux-arm64.tar.gz Linuxarm64SHA-256 | 9e188496…b809 | |
| pg_exporter-1.2.0.linux-ppc64le.tar.gz LinuxSHA-256 | 6e284896…465f | |
| pg_exporter-1.2.0.windows-amd64.tar.gz Windowsamd64SHA-256 | 9e9beac6…52d9 |
https://github.com/pgsty/pg_exporter/releases/tag/v1.2.0
v1.1.2
This minor release fixes the pg_timeline configuration and builds with the latest Go dependencies.
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.1.2-1_amd64.deb Linuxamd64SHA-256 | 8cddd57a…6236 | |
| pg-exporter_1.1.2-1_arm64.deb Linuxarm64SHA-256 | f5b25a8a…4f04 | |
| pg-exporter_1.1.2-1_ppc64le.deb LinuxSHA-256 | 4da2c287…c83c | |
| pg_exporter-1.1.2-1.aarch64.rpm Linuxarm64SHA-256 | b26355f3…a5e8 | |
| pg_exporter-1.1.2-1.ppc64le.rpm LinuxSHA-256 | 42ef8971…cca5 | |
| pg_exporter-1.1.2-1.x86_64.rpm Linuxamd64SHA-256 | a8f4a2d5…675d | |
| pg_exporter-1.1.2.darwin-amd64.tar.gz macOSamd64SHA-256 | 775f5ea3…4750 | |
| pg_exporter-1.1.2.darwin-arm64.tar.gz macOSarm64SHA-256 | 7f2bbcc2…1003 | |
| pg_exporter-1.1.2.linux-amd64.tar.gz Linuxamd64SHA-256 | 33c34b1f…2b98 | |
| pg_exporter-1.1.2.linux-arm64.tar.gz Linuxarm64SHA-256 | 2b91a581…bdd8 | |
| pg_exporter-1.1.2.linux-ppc64le.tar.gz LinuxSHA-256 | adcb5f22…27ee | |
| pg_exporter-1.1.2.windows-amd64.tar.gz Windowsamd64SHA-256 | 90b7c7e4…5a4a |
https://github.com/pgsty/pg_exporter/releases/tag/v1.1.2
v1.1.1
Minor release with new collectors and bug fixes.
New Features:
- New
pg_timelinecollector for timeline monitoring - New
pg_sub_16collector branch to exclude parallel operations in subscriptions (PostgreSQL 16+ compatibility)
Bug Fixes:
- Fix: Add coalesce for slotname in
pg_recvcollector to handle NULL values
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.1.1-1_amd64.deb Linuxamd64SHA-256 | fd5ee965…a278 | |
| pg-exporter_1.1.1-1_arm64.deb Linuxarm64SHA-256 | b90a08d1…aa27 | |
| pg-exporter_1.1.1-1_ppc64le.deb LinuxSHA-256 | 163955f5…6d3a | |
| pg_exporter-1.1.1-1.aarch64.rpm Linuxarm64SHA-256 | cf4f8bc1…e6c8 | |
| pg_exporter-1.1.1-1.ppc64le.rpm LinuxSHA-256 | 5a425b2f…4a2e | |
| pg_exporter-1.1.1-1.x86_64.rpm Linuxamd64SHA-256 | 23606cce…1a16 | |
| pg_exporter-1.1.1.darwin-amd64.tar.gz macOSamd64SHA-256 | ce74624e…6188 | |
| pg_exporter-1.1.1.darwin-arm64.tar.gz macOSarm64SHA-256 | 35fba125…4ae3 | |
| pg_exporter-1.1.1.linux-amd64.tar.gz Linuxamd64SHA-256 | 7699bdef…0bef | |
| pg_exporter-1.1.1.linux-arm64.tar.gz Linuxarm64SHA-256 | f4baba59…71c6 | |
| pg_exporter-1.1.1.linux-ppc64le.tar.gz LinuxSHA-256 | 810c3817…a781 | |
| pg_exporter-1.1.1.windows-amd64.tar.gz Windowsamd64SHA-256 | 3f6df693…5f93 |
https://github.com/pgsty/pg_exporter/releases/tag/v1.1.1
v1.1.0
Build with Go 1.25.5 and latest dependencies, collector updates:
Collector Changes:
pg_setting: update PG10-18 compatibility and addmissing_oksupport.- 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_sizetowork_mem. - Change min_version from 9.6 to 10. Use explicit
::inttype conversion.
- Add 13 new metrics:
pg_size: fix log directory size detection. Checklogging_collectorinstead of matching path patterns.pg_table: replace LATERAL subqueries with JOIN to improve performance. Changetuplesandfrozenxidfrom COUNTER to GAUGE. Increase the timeout from 1s to 2s.pg_vacuuming: add a PG17 branch withindexes_total,indexes_processed, anddead_tuple_bytesto track index vacuum progress.pg_query: increase the timeout from 1s to 2s for high-load conditions.pg_io: correct thereusesdescription from “in reused” to “is reused”.pg_checkpointer: correct the pg_checkpointer_10 description from “9.4+” to “9.4-17”.pg_db_confl: correct the pg_db_confl_15 description from “9.1 - 16” to “9.1 - 15”.- Correct format alignment for
pg_db,pg_indexing,pg_clustering, andpg_backup.
Other Changes:
- Fix release year by @anayrat
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.1.0-1_amd64.deb Linuxamd64SHA-256 | 9c65f43e…5ca2 | |
| pg-exporter_1.1.0-1_arm64.deb Linuxarm64SHA-256 | bcd2cacb…972d | |
| pg-exporter_1.1.0-1_ppc64le.deb LinuxSHA-256 | 2c9d4a9c…71b1 | |
| pg_exporter-1.1.0-1.aarch64.rpm Linuxarm64SHA-256 | 2934ab5b…f7b8 | |
| pg_exporter-1.1.0-1.ppc64le.rpm LinuxSHA-256 | 3c9955f3…ab43 | |
| pg_exporter-1.1.0-1.x86_64.rpm Linuxamd64SHA-256 | 9fdefbd8…ea05 | |
| pg_exporter-1.1.0.darwin-amd64.tar.gz macOSamd64SHA-256 | 71590020…90cc | |
| pg_exporter-1.1.0.darwin-arm64.tar.gz macOSarm64SHA-256 | 7d55ac5c…6d65 | |
| pg_exporter-1.1.0.linux-amd64.tar.gz Linuxamd64SHA-256 | 8211ec24…f02f | |
| pg_exporter-1.1.0.linux-arm64.tar.gz Linuxarm64SHA-256 | d17ab7f9…b3ae | |
| pg_exporter-1.1.0.linux-ppc64le.tar.gz LinuxSHA-256 | c074aeb3…40b6 | |
| pg_exporter-1.1.0.windows-amd64.tar.gz Windowsamd64SHA-256 | 13d653e2…fcb7 |
https://github.com/pgsty/pg_exporter/releases/tag/v1.1.0
v1.0.3
- Build with Go 1.25.4 and latest dependencies
- Fix #80 Conflict with libpq env variables
- Change default value of
auto-discoverytotrueby @kadaffy
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.0.3-1_amd64.deb Linuxamd64SHA-256 | 7efa1a77…d015 | |
| pg-exporter_1.0.3-1_arm64.deb Linuxarm64SHA-256 | 41e18bf1…3b07 | |
| pg-exporter_1.0.3-1_ppc64le.deb LinuxSHA-256 | 7da8ed73…3a43 | |
| pg_exporter-1.0.3-1.aarch64.rpm Linuxarm64SHA-256 | a214b555…d6b4 | |
| pg_exporter-1.0.3-1.ppc64le.rpm LinuxSHA-256 | d876fc66…1413 | |
| pg_exporter-1.0.3-1.x86_64.rpm Linuxamd64SHA-256 | 75f62d31…75b4 | |
| pg_exporter-1.0.3.darwin-amd64.tar.gz macOSamd64SHA-256 | 47829a19…2769 | |
| pg_exporter-1.0.3.darwin-arm64.tar.gz macOSarm64SHA-256 | 38b6ccb7…af6b | |
| pg_exporter-1.0.3.linux-amd64.tar.gz Linuxamd64SHA-256 | 36e8dff8…919a | |
| pg_exporter-1.0.3.linux-arm64.tar.gz Linuxarm64SHA-256 | 6477e8ef…8791 | |
| pg_exporter-1.0.3.linux-ppc64le.tar.gz LinuxSHA-256 | a083b51e…820c | |
| pg_exporter-1.0.3.windows-amd64.tar.gz Windowsamd64SHA-256 | a1f9b27b…a588 |
https://github.com/pgsty/pg_exporter/releases/tag/v1.0.3
v1.0.2
- Build with Go 1.25.0 and the latest dependencies.
- Add a dedicated website and homepage: https://exp.pgsty.com
- Use GoReleaser and CI/CD to release for more operating systems and architectures:
- Add Windows amd64 support.
- Add Linux ppc64le support.
Checksums
| File | Checksum | |
|---|---|---|
| pg-exporter_1.0.2-1_amd64.deb Linuxamd64SHA-256 | 683bf97f…44c5 | |
| pg-exporter_1.0.2-1_arm64.deb Linuxarm64SHA-256 | f62d479a…ccb5 | |
| pg-exporter_1.0.2-1_ppc64le.deb LinuxSHA-256 | e1bbfc5a…4c7a | |
| pg_exporter-1.0.2-1.aarch64.rpm Linuxarm64SHA-256 | f51d5b45…039c | |
| pg_exporter-1.0.2-1.ppc64le.rpm LinuxSHA-256 | 18380011…939e | |
| pg_exporter-1.0.2-1.x86_64.rpm Linuxamd64SHA-256 | 198372d8…f2bb | |
| pg_exporter-1.0.2.darwin-amd64.tar.gz macOSamd64SHA-256 | cbe7e07d…477d | |
| pg_exporter-1.0.2.darwin-arm64.tar.gz macOSarm64SHA-256 | 20c4a35f…4b97 | |
| pg_exporter-1.0.2.linux-amd64.tar.gz Linuxamd64SHA-256 | d7421111…eff1 | |
| pg_exporter-1.0.2.linux-arm64.tar.gz Linuxarm64SHA-256 | 0b1f4c97…054f | |
| pg_exporter-1.0.2.linux-ppc64le.tar.gz LinuxSHA-256 | 895083fd…dcc3 | |
| pg_exporter-1.0.2.windows-amd64.tar.gz Windowsamd64SHA-256 | 5f751228…10aa |
https://github.com/pgsty/pg_exporter/releases/tag/v1.0.2
v1.0.1
- Add dockerhub images: pgsty/pg_exporter
- Update Go dependencies to the latest version. Build with Go 1.24.5
- Disable
pg_tsdb_hypertableby default because thetimescaledbcatalog has changed.
Checksums
| File | Checksum | |
|---|---|---|
| pg_exporter-1.0.1-1.aarch64.rpm Linuxarm64MD5 | d5e2d6a6…9773 | |
| pg_exporter-1.0.1-1.x86_64.rpm Linuxamd64MD5 | cb01bb78…3cb3 | |
| pg_exporter-v1.0.1.darwin-amd64.tar.gz macOSamd64MD5 | 67093a75…8e81 | |
| pg_exporter-v1.0.1.darwin-arm64.tar.gz macOSarm64MD5 | 2d3fdc10…f127 | |
| pg_exporter-v1.0.1.linux-amd64.tar.gz Linuxamd64MD5 | e2423144…8ab0 | |
| pg_exporter-v1.0.1.linux-arm64.tar.gz Linuxarm64MD5 | 63de91da…82a6 | |
| pg-exporter_1.0.1_amd64.deb Linuxamd64MD5 | 718f6afc…9ba5 | |
| pg-exporter_1.0.1_arm64.deb Linuxarm64MD5 | 57da7a80…7367 |
https://github.com/pgsty/pg_exporter/releases/tag/v1.0.1
v1.0.0
Add PostgreSQL 18 metrics support
- new collector branch
pg_wal_18:- remove
write,sync,write_time,sync_timemetrics - move to
pg_stat_io
- remove
- new collector branch
pg_checkpointer_18:- new metric
num_done - new metric
slru_written
- new metric
- new collector branch
pg_db_18:- new metric
parallel_workers_to_launch - new metric
parallel_workers_launched
- new metric
- new collector branch
pg_table_18:table_parallel_workers_to_launchtable_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_bytesdue to fixed value
- new collector branch
pg_vacuuming_18:- new metric
delay_time
- new metric
| File | Checksum | |
|---|---|---|
| pg_exporter-1.0.0-1.aarch64.rpm Linuxarm64MD5 | 33fe4dd8…bbc9 | |
| pg_exporter-1.0.0-1.x86_64.rpm Linuxamd64MD5 | eba8426b…004a | |
| pg_exporter-v1.0.0.darwin-amd64.tar.gz macOSamd64MD5 | f6912822…da11 | |
| pg_exporter-v1.0.0.darwin-arm64.tar.gz macOSarm64MD5 | c133c607…c438 | |
| pg_exporter-v1.0.0.linux-amd64.tar.gz Linuxamd64MD5 | 3875487d…7ee0 | |
| pg_exporter-v1.0.0.linux-arm64.tar.gz Linuxarm64MD5 | 395715fb…babd | |
| pg-exporter_1.0.0_amd64.deb Linuxamd64MD5 | f3b23e59…2ef3 | |
| pg-exporter_1.0.0_arm64.deb Linuxarm64MD5 | a7305b9c…1dfe |
https://github.com/pgsty/pg_exporter/releases/tag/v1.0.0
v0.9.0
Default Collectors
- new metrics collector for
timescaledbhypertable - new metrics collector for
citusdist node - new metrics collector for
pg_wait_samplingwait event profile pg_slotoverhaul: Add 16/17 pg_replication_slot metrics- allow
pg_slotcollector run on replica since 16/17 - refactor
pg_waitcollector to agg from all processes - restrict pg_clustering, pg_indexing, pg_vacuuming run on primary
- mark all
reset_timeasGAUGErather thanCOUNTER - fix
pg_recovery_prefetch_skip_fpwtype fromGAUGEtoCOUNTER - fix
pg_recv.statetype fromLABELtoGAUGE - Format collector in compact mode
- new default metric
pg_exporter_build_info/pgbouncer_exporter_build_info - add
server_encodingtopg_metacollector - add 12 new setting metrics to
pg_settingcollector:- 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 Codebase
- normalize collector branch name with min pg ver suffix
- Add license file to binary packages
- move
pgsty/pg_exporterrepo topgsty/pg_exporter - refactor
server.goto reduceCompatibleandPostgresPrecheckcomplexity - 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
https://github.com/pgsty/pg_exporter/releases/tag/v0.9.0
v0.8.1
- 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
https://github.com/pgsty/pg_exporter/releases/tag/v0.8.1
v0.8.0
- Add PgBouncer 1.24 new metrics support (stat, pool, database)
- Fix:
310-pg_size.ymlfails 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/sloginstead ofgo-kit - Full Changelog: https://github.com/pgsty/pg_exporter/compare/v0.7.1...v0.8.0
https://github.com/pgsty/pg_exporter/releases/tag/v0.8.0
v0.7.1
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: https://github.com/pgsty/pg_exporter/compare/v0.7.0...v0.7.1
https://github.com/pgsty/pg_exporter/releases/tag/v0.7.1
v0.7.0
Refactor the codebase for the latest Go version.
- 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 @ringerc
- pg_exporter: fix /stat endpoint formatting by @ringerc
- pg_exporter: omit default query properties on yaml export by @ringerc
- Exclude template DBs from discovery and schema-qualify discovery query by @ringerc
- Fix some typos and some metric description mistakes by @ringerc
- Switch from unmaintained lib/pq driver to pgx with stdlib wrapper by @ringerc
https://github.com/pgsty/pg_exporter/releases/tag/v0.7.0
v0.6.0
Fix Dependabot security issues.
Add pg16 collectors.
Add
arm64&aarch64packages.Remove the
monitorschema requirement forpg_querycollectors. Set search_path to findpg_stat_statements, or install it in the defaultpublicschema.Change the pgBouncer version parsing message level from info to debug.
Fix the missing
relidin thepg_table_10_12collector.Recognize the files with yml suffix in config directory by @Japin Li
https://github.com/pgsty/pg_exporter/releases/tag/v0.6.0
v0.5.0
Exporter Enhancement
- Build rpm & deb with
nfpm - Add
column.default, replace when metric value is NULL - Add
column.scaleto multiply float/int values by a scale factor, such as conversion from µs to seconds - Fix
/statendpoint output - Add docker container
pgsty/pg_exporter
Metrics Collector
- scale bgwriter & pg_wal time unit to second
- remove pg_class collector and move it to pg_table & pg_index
- add pg_class metrics to pg_table
- add pg_class metrics to pg_index
- enable pg_table_size by default
- scale pg_query pg_db pg_bgwriter pg_ssl pgbouncer_stat time metrics to second
https://github.com/pgsty/pg_exporter/releases/tag/v0.5.0
v0.4.1
- Update default collectors:
- Exclude citus & timescaledb schemas from object monitoring.
- Prevent duplicate pg_statio tuples.
- Support pgBouncer v1.16.
- Fix overlapping
pg_replcollectors on pg 12.
- Add the
-Tconnect-timeoutPG_EXPORTER_CONNECT_TIMEOUTparameter for remote PostgreSQL monitoring. - Rename
pg_exporter.yamltopg_exporter.ymlin the RPM package.
https://github.com/pgsty/pg_exporter/releases/tag/v0.4.1
v0.4.0
- Add PG 14 support
- Update the default metrics configuration. The old configuration remains supported
- add
auto-discovery,include-databaseandexclude-databaseoption - Add multiple database monitoring implementations (with
auto-discovery = on)
https://github.com/pgsty/pg_exporter/releases/tag/v0.4.0
v0.3.2
- fix shadow DSN corner case
- fix typo & docs
https://github.com/pgsty/pg_exporter/releases/tag/v0.3.2
v0.3.1
Fix default configuration errors, particularly for versions before 13.
- Account for the
primary_conninfosetting being available only from PG13. - Add the
funcidlabel topg_functo prevent duplicate labels from function names. - Fix the version string to
pg_exporter.
https://github.com/pgsty/pg_exporter/releases/tag/v0.3.1
v0.3.0
https://github.com/pgsty/pg_exporter/releases/tag/v0.3.0
- Update the default configuration to support PostgreSQL 13 metrics, including
pg_slru,pg_shmem,pg_query13, andpg_backup. - Add REST APIs for health and recovery status checks.
- Add a dummy server that returns
pg_up 0before PgExporter initialization. - Add
sslmode=disableto the URL ifsslmodeis absent. - Fix typos and bugs.
v0.2.0
- add yum package and linux service definition
- add a ‘skip’ flag into query config
- fix
pgbouncer_upmetrics - add conf reload support
https://github.com/pgsty/pg_exporter/releases/tag/v0.2.0
v0.1.2
- fix pgbouncer_up metrics
- add dynamic configuration reload
- remove ‘shard’ related logic
- add a ‘bulky’ mode to default settings
https://github.com/pgsty/pg_exporter/releases/tag/v0.1.2
v0.1.1
Fix a startup hang that occurs if any query fails.
https://github.com/pgsty/pg_exporter/releases/tag/v0.1.1
v0.1.0
This is the first stable release.
https://github.com/pgsty/pg_exporter/releases/tag/v0.1.0
v0.0.4
This release passed production tests on 200+ nodes for about 2 weeks.
https://github.com/pgsty/pg_exporter/releases/tag/v0.0.4
v0.0.3
v0.0.3 passed production tests.
This version is already tested in a production environment.
The project changes rapidly. Use this version with caution in production.
https://github.com/pgsty/pg_exporter/releases/tag/v0.0.3
v0.0.2
This version is ready for testing.
https://github.com/pgsty/pg_exporter/releases/tag/v0.0.2
v0.0.1
Add pgBouncer mode
https://github.com/pgsty/pg_exporter/releases/tag/v0.0.1
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)