PG Exporter Blog

Decision status: Implemented in a development line; not present in main, a tag, or a published package as of 2026-08-28. Decision date: 2026-08-24. Applies to: the default-off PostgreSQL 14+ CSV log collector inside the Composite exporter. …

Decision status: Implemented in a development line; not present in main, a tag, or a published package as of 2026-08-28. Decision date: 2026-08-23. Applies to: the optional --pgbackrest cached component inside the Composite exporter. Release …

Decision status: Superseded on 2026-08-24 by the in-process PostgreSQL CSV log metrics decision. Research date: 2026-08-13. What remains valid: CSV framing, rotation, SQLSTATE, privacy, and bounded-cardinality findings. What no longer applies: a new …

Decision status: Implemented in a development line; not present in main, a tag, or a published package as of 2026-08-28. Decision date: 2026-08-11; extended by cached components on 2026-08-23 and 2026-08-24. Applies to: the optional Composite …

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 …

Decision status: Shipped in v1.4.0. Decision date: 2026-07-11; amended on 2026-07-17 before release. Applies to: HISTOGRAM columns and the bundled pg_xact_age collector in PG Exporter v1.4.0 and later. Release boundary: this article describes a …

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 is a routine maintenance release that only refreshes the release toolchain to Go 1.26.2. It does not introduce new collectors, config semantics, or runtime behavior changes. Highlights Refresh the release toolchain: bump release builds to Go …

v1.2.1 is a lightweight maintenance release focused on release engineering, config package consistency, and documentation/metadata refresh. It does not introduce new collector semantics or runtime behavior changes. Highlights Refresh the build …

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 / …

Minor release fixing pg_timeline configuration issue and building with latest go deps Checksums https://github.com/pgsty/pg_exporter/releases/download/v1.1.2/checksums.txt 8cddd57a843914a3145a80a3220bc875047b9bcac0664357c01ba86485436236 …

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 …

I’ve spent the last few weeks preparing Pigsty v4.0. The headliner: ripping out Prometheus + Loki and dropping in the full Victoria stack. VictoriaMetrics is no-frills brute force—it just works and it’s ridiculous. The observability portion is done, …

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, …

Build with Go 1.25.4 and latest dependencies Fix #80 Conflict with libpq env variables Change default value of auto-discovery to true by @kadaffy Checksums https://github.com/pgsty/pg_exporter/releases/download/v1.0.3/checksums.txt …

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 Checksums …

Add Docker Hub 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. Checksums d5e2d6a656eef0ae1b29cd49695f9773 …

Changes 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 …

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 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 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: …

Changes Refactor 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 by @ringerc pg_exporter: don’t panic after “bind: address …

PGCon.Dev, once known as PGCon—the annual must-attend gathering for PostgreSQL hackers and key forum for its future direction, has been held in Ottawa since its inception in 2007. This year marks a new chapter as the original organizer, Dan, hands …

Changes Update golang.org/x/net from v0.10.0 to v0.17.0 to pick up security fixes (#38) Fix connect-timeout propagation (#37), contributed by @mouchar Recognize both .yaml and .yml files in a configuration directory (#34), contributed by @japinli …

In production online databases, slow queries not only affect end-user experience but also waste system resources, increase resource saturation, cause deadlocks and transaction conflicts, increase database connection pressure, and lead to master-slave …

Changes Security enhancement: update dependencies to address reported vulnerabilities Add pg16 collectors Add arm64 & aarch64 packages Remove the monitor schema requirement for pg_query collectors (you have to ensure it with search_path or just …

Pigsty 是一个开箱即用的 PostgreSQL 发行版，与本地优先的 RDS 开源替代。但它也可以单独作为一个 PostgreSQL/主机监控系统来使用。本文以阿里云为例，介绍了用一台 ECS 安装部署 Pigsty，并用于监控云上的 PolarDB 与 RDS for PostgreSQL，为现有数据库带来极致的观测能力。 嵌入媒体 快速上手 使用 Pigsty 教程分为四个步骤： 1.申请用于部署 Pigsty 的 ECS 服务器2.在 ECS 服务器上完整单机安装 Pigsty3.配 …

Exporter Enhancement Build rpm & deb with nfpm Add column.default, replace when metric value is NULL Add column.scale, multiply scale factor when metric value is float/int (e.g µs to second) Fix /stat endpoint output Add docker container …

Changes update default collectors omit citus & timescaledb schemas on object monitoring avoid duplicate pg_statio tuples support PgBouncer v1.16 bug fix: pg_repl collector overlap on pg 12 new parameter: -T connect-timeout PG_EXPORTER_CONNECT_TIMEOUT …

Changes Add PG 14 support Default metrics configuration overhaul. (BUT you can still use the old configuration) add auto-discovery , include-database and exclude-database option Add multiple database monitoring implementations (with auto-discovery = …

“You can’t optimize what you can’t measure.” Slow queries hog connections, hold locks, block replication, trigger deadlocks, and waste resources. Every DBA must know how to find and fix them quickly. Traditional tools pg_stat_statements – essential …

Changes fix shadow DSN corner case fix typo & docs v0.3.2 Released 2021-02-01 View release Source · tar.gz Source · zip pgsty/pg_exporter

今天我很荣幸的宣布，Pigsty正式发布了！ 官方网站：https://pigsty.cc Pigsty是什么？ Pigsty是针对大规模PostgreSQL集群的监控系统 Pigsty是高可用PostgreSQL集群的供给方案 Pigsty基于开源生态构建，是免费的开源软件 Pigsty 针对大规模数据库集群监控与管理而设计，提供业界顶尖的PostgreSQL监控系统与开箱即用的高可用数据库供给方案。Pigsty基于开源生态构建，旨在降低PostgreSQL使用管理的门槛，为用户带来极致的可观 …

Changes fix default configuration problems (especially for versions lower than 13) setting primary_conninfo not exists until PG13 add funcid label to pg_func collector to avoid func name duplicate label fix version string to pg_exporter v0.3.1 …

Preface Playing with databases and playing with cars have something in common - they both require frequently checking the dashboard. What are you doing staring at the dashboard? Looking at metrics. Why look at metrics? You need to understand the …

Changes https://github.com/pgsty/pg_exporter/releases/tag/v0.3.0 Change default configuration, Support PostgreSQL 13 new metrics (pg_slru, pg_shmem, pg_query13,pg_backup, etc…) Add a series of new REST APIs for health / recovery status check Add a …

近自己做了套数据库监控系统，搞的还可以，简单给大家介绍一下。 Pigsty is an advanced PostgreSQL monitoring systemd based on open source projects like prometheus & grafana. PIGSTY /pɪɡ staɪ/ is the abbreviation of “Postgres in Grafana Style”. Pigsty是一个基于Grafana与Prometheus与Consul的 …

Managing databases is similar to managing people - both need KPIs (Key Performance Indicators). So what are database KPIs? This article introduces a way to measure PostgreSQL load: using a single horizontally comparable metric that is basically …

Changes add yum package and linux service definition add a ‘skip’ flag into query config fix pgbouncer_up metrics add conf reload support v0.2.0 Released 2020-03-21 View release Source · tar.gz Source · zip pgsty/pg_exporter

Changes fix pgbouncer_up metrics add dynamic configuration reload remove ‘shard’ related logic add a ‘bulky’ mode to default settings v0.1.2 Released 2020-02-20 View release Source · tar.gz Source · zip pgsty/pg_exporter

Changes Fix the bug that pg_exporter will hang during start-up if any query is failed. v0.1.1 Released 2020-01-10 View release Source · tar.gz Source · zip pgsty/pg_exporter

Changes It works, looks good to me. 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 in real world production environment with 200+ nodes for about 2 weeks. Looks good ! v0.0.4 Released 2019-12-20 View release Source · tar.gz Source · zip pgsty/pg_exporter

Changes v0.0.3 Release, Tested in Production Environment This version is already tested in a production environment. This project is still under rapid evolution, I would say if you want use it in production , try with caution. v0.0.3 Released …

Changes It’s ok to try now v0.0.2 Released 2019-12-09 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 PgBouncer mode v0.0.1 Released 2019-12-09 View release Source · tar.gz Source · zip …

PostgreSQL驾驶技巧 PostgreSQL是一个很棒的数据库，但也相当复杂。上手虽简单，但想要用好不容易，想要管理好就更麻烦了。监控系统是几乎所有运维工作的基础，更亦是驾驭数据库的必备工具。用好一个监控系统，理解各种指标背后的意义并不是一件简单的事情，因此本司机决定写一系列文章，来介绍了PostgreSQL监控系统的设计，实施与使用。 0x01 PostgreSQL监控面板 为了帮助读者形成一种直觉，这里展示了在实际环境中，我所使用的监控面板。最为常用的监控面板为“单数据库实例”监控，并 …

Author: Vonng (@Vonng) PostgreSQL uses MVCC as its primary concurrency control technology. While it has many benefits, it also brings other effects, such as relation bloat. Relation bloat (table and index) negatively impacts database performance and …

Table Space Layout In the broad sense, a Table includes two parts: the main table and TOAST table: Main table: stores the relation’s own data, i.e., the narrow sense relation, relkind='r'. TOAST table: corresponds one-to-one with the main table, …

It’s recommended to configure PostgreSQL’s log format as CSV for easy analysis, and it can be directly imported into PostgreSQL data tables. Log-Related Configuration Items log_destination ='csvlog' logging_collector =on log_directory ='log' …