v6.0.0-beta

[pashagolub]

pgwatch v6-beta is here 🎉

The biggest release since v5 — full Postgres v19 support, a new source type, fully modernized dashboards, and a reaper core built for reliability at scale.

The big three

🔌 Prometheus as a source. pgwatch can now scrape your existing Prometheud endpoints (patroni, postgres_exporter, etc.) directly — no need to stand up native connections everywhere. Mix and match Postgres and Prometheus sources in the same setup.

📊 Dashboards, reimagined. Every dashboard has been rebuilt on Grafana's new v13 schema with a unified row layout — cleaner, faster, and wall-display ready. Prometheus now gets first-class dashboard parity with Postgres, including brand-new Lock Details, Server Log Events, and Stored Procedures views.

⚙️ A reaper that doesn't choke under load. The core collection loop init is now parallelized, database round-trips are bounded so nothing hangs for long, and continuous discovery is cached. Translation: fewer stuck goroutines, faster restarts, better behavior under real production load.

Also worth knowing

• WebUI modernized to React 19 + MUI v9
• New metrics: recovery, stat_lock, settings_num, autovacuum_scores, plus stats_reset tracking across table/index/sproc stats
• Fixed: graceful sink outage handling, SourceReaper deadlocks, NaN/Inf sanitization in measurements, replication lag panel bugs
• Security: JWT secret is now randomly generated at startup, not hardcoded
• Postgres support bumped to v19
• New Task build tool support for contributors

⚠️ It's a beta

The Prometheus source and v13 dashboard schema are new territory — please kick the tires in a non-prod environment first and file issues as you find them.

What's Changed

• [!] add Prometheus exporter as a pgwatch source by @pashagolub in [!] add Prometheus exporter as a pgwatch source #1405
• [!] bump Postgres to v19 by @pashagolub in [+] bump Postgres to v19 #1497
• [!] refactor reaper.Reap main loop as parallel by @pashagolub in [!] refactor reaper.Reap main loop as parallel #1512
• [!] transform v13 dashboards to row layout with unified colophon by @pashagolub in [!] transform v13 dashboards to row layout with unified colophon #1500
• [!] upgrade webui to React v19, MUI v9, MUI X Data Grid v9 by @pashagolub in [!] upgrade webui to React v19, MUI v9, MUI X Data Grid v9 #1422
• [!] upgrade Grafana dashboards to v13 by @pashagolub in [!] upgrade Grafana dashboards to v13 #1487
• [!] use bounded contexts for all database round-trips by @pashagolub in [!] use bounded contexts for all database round-trips #1511
• [+] add "Lock details" dashboard by @pashagolub in [+] add "Lock details" dashboard #1498
• [+] add .git-blame-ignore-revs by @pashagolub in [+] add .git-blame-ignore-revs #1389
• [+] add autovacuum_scores metric by @nadashaban11 in [+] add autovacuum_scores metric #1403
• [+] add mem_exceeded_count to pg_stat_replication_slots, closes Add support for mem_exceeded_count column in pg_stat_replication_slots #1395 by @pashagolub in [+] add mem_exceeded_count to pg_stat_replication_slots, closes #1395 #1503
• [+] add recovery metric, closes Add metric for pg_stat_recovery to report recovery status #1394 by @pashagolub in [+] add recovery metric, closes #1394 #1490
• [+] add settings_num metric, closes settings metric should be rewritten with values casted to integer #1247 by @pashagolub in [+] add settings_num metric, closes #1247 #1436
• [+] add stat_lock metric to report per-lock statistics, closes Add metric for pg_stat_lock and/or pg_stat_get_lock() to report per-lock type statistics #1393 by @pashagolub in [+] add stat_lock metric to report per-lock statistics, closes #1393 #1496
• [+] add stats_reset to table_*stats and index_stats, closes Add support for stats_reset column in pg_stat_all_tables, pg_stat_all_indexes, and pg_statio_all_sequences #1396 by @pashagolub in [+] add stats_reset to table_*stats and index_stats, closes #1396 #1502
• [+] add wal_fpi_bytes field to wal_stats metric, fixes Add reporting of the bytes written to WAL for full page images #1399 by @nadashaban11 in [+] add wal_fpi_bytes field to wal_stats metric, fixes #1399 #1402
• [+] add Prometheus "Server Log Events" dashboard by @pashagolub in [+] add Prometheus "Server Log Events" dashboard #1518
• [+] add Prometheus stored procedures dashboards by @pashagolub in [+] add Prometheus stored procedures dashboards #1516
• [+] add Prometheus variant of "Version Overview" dashboard by @pashagolub in [+] add Prometheus variant of "Version Overview" dashboard #1514
• [+] add stats_reset to sproc_stats and database_conflicts metrics, closes Add support for stats_reset column in pg_stat_user_functions and pg_stat_database_conflicts #1397 by @pashagolub in [+] add stats_reset to sproc_stats and database_conflicts metrics, closes #1397 #1501
• [+] add support for Task build tool by @pashagolub in [+] add support for Task build tool #1504
• [+] add v13 "Health check" dashboard by @avandras in [+] add v13 "Health check" dashboard #1448
• [+] add v13 global DB overview dashboard by @avandras in [+] add v13 global DB overview dashboard #1454
• [+] bump actions/cache from 5 to 6 by @dependabot[bot] in [+] bump actions/cache from 5 to 6 #1453
• [+] bump actions/checkout from 6 to 7 by @dependabot[bot] in [+] bump actions/checkout from 6 to 7 #1447
• [+] bump actions/setup-go from 6 to 7 by @dependabot[bot] in [+] bump actions/setup-go from 6 to 7 #1465
• [+] bump actions/setup-node from 6 to 7 by @dependabot[bot] in [+] bump actions/setup-node from 6 to 7 #1462
• [+] bump actions/setup-python from 6 to 7 by @dependabot[bot] in [+] bump actions/setup-python from 6 to 7 #1468
• [+] bump actions/stale from 10 to 11 by @dependabot[bot] in [+] bump actions/stale from 10 to 11 #1478
• [+] bump axios from 1.15.0 to 1.18.0 in webui by @dependabot[bot] in [+] bump axios from 1.15.0 to 1.15.2 in webui #1390 [+] bump axios from 1.15.2 to 1.16.0 #1424 [+] bump axios from 1.16.0 to 1.18.0 in webui #1471
• [+] bump brace-expansion from 5.0.6 to 5.0.9 in webui by @dependabot[bot] in [+] bump brace-expansion from 5.0.8 to 5.0.9 in webui #1485 [+] bump brace-expansion to v5.0.6 #1420
• [+] bump etcd/client/v3 from 3.6.11 to 3.6.12 by @dependabot[bot] in [+] bump etcd/client/v3 from 3.6.11 to 3.6.12 #1431
• [+] bump go.etcd.io/etcd/client/v3 from 3.6.12 to 3.7.1 by @dependabot[bot] in [+] bump go.etcd.io/etcd/client/v3 from 3.6.12 to 3.7.0 #1461 [+] bump go.etcd.io/etcd/client/v3 from 3.7.0 to 3.7.1 #1472
• [+] bump google.golang.org/grpc from 1.81.0 to 1.83.0 by @dependabot[bot] in [+] bump google.golang.org/grpc from 1.81.0 to 1.81.1 #1410 [+] bump google.golang.org/grpc from 1.81.1 to 1.82.0 #1457 [+] bump google.golang.org/grpc from 1.82.0 to 1.82.1 #1463 [+] bump google.golang.org/grpc from 1.82.1 to 1.83.0 #1479
• [+] bump google.golang.org/protobuf from 1.36.11 to 1.36.12 by @dependabot[bot] in [+] bump google.golang.org/protobuf from 1.36.11 to 1.36.12 #1522
• [+] bump gopsutil/v4 from 4.26.4 to 4.26.5 by @dependabot[bot] in [+] bump gopsutil/v4 from 4.26.4 to 4.26.5 #1425
• [+] bump grpc from 1.80.0 to 1.81.0 by @dependabot[bot] in [+] bump grpc from 1.80.0 to 1.81.0 #1388
• [+] bump jackc/pgx/v5 from 5.9.2 to 5.10.0 by @dependabot[bot] in [+] bump jackc/pgx/v5 from 5.9.2 to 5.10.0 #1432
• [+] bump js-yaml from 4.3.0 to 4.3.1 in webui by @dependabot[bot] in [+] bump js-yaml from 4.3.0 to 4.3.1 in webui #1510
• [+] bump nanoid from 3.3.16 to 3.3.18 in webui by @dependabot[bot] in [+] bump nanoid from 3.3.16 to 3.3.18 in webui #1509
• [+] bump prometheus/client_golang from 1.23.2 to 1.24.1 by @dependabot[bot] in [+] bump prometheus/client_golang from 1.23.2 to 1.24.0 #1469 [+] bump prometheus/client_golang from 1.24.0 to 1.24.1 #1473
• [+] bump sethvargo/go-retry from 0.3.0 to 0.4.0 by @dependabot[bot] in [+] bump sethvargo/go-retry from 0.3.0 to 0.4.0 #1466
• [+] bump shirou/gopsutil/v4 from 4.26.5 to 4.26.7 by @dependabot[bot] in [+] bump shirou/gopsutil/v4 from 4.26.5 to 4.26.6 #1458 [+] bump shirou/gopsutil/v4 from 4.26.6 to 4.26.7 #1484
• [+] bump sirupsen/logrus from 1.9.4 to 1.10.0 by @pashagolub in [+] bump sirupsen/logrus from 1.9.4 to 1.10.0 #1524
• [+] bump testcontainers/testcontainers-go from 0.42.0 to 0.44.0 by @dependabot[bot] in [+] bump testcontainers/testcontainers-go from 0.42.0 to 0.43.0 #1450 [+] bump testcontainers/testcontainers-go from 0.43.0 to 0.44.0 #1508
• [+] bump vite from 7.3.2 to 8.0.16 by @pashagolub in [+] bump Vite from 7.3.2 to 8.0.14 #1421 [+] bump vite from 8.0.14 to 8.0.16 in webui #1440 [+] bump vite from v8.0.14 to v8.0.16 #1445
• [+] bump yaml from 1.10.0 to 2.8.4 in webui by @pashagolub in [+] bump yaml from 1.10.0 to 2.8.4 in webui #1391
• [+] improve admin.drop_all_metric_tables routine, closes Change admin.drop_all_metric_tables() #1474 by @pashagolub in [+] improve admin.drop_all_metric_tables routine, closes #1474 #1520
• [+] increase test coverage for testutil package by @pashagolub in [+] increase test coverage for testutil package #1521
• [-] avoid deadlock in SourceReaper, fixes deadlock in SourceReaper #1412 by @pashagolub in [-] avoid deadlock in SourceReaper, fixes #1412 #1417
• [-] fix checkpointer metric by @0xgouda in [-] fix checkpointer metric #1411
• [-] fix Grafana postgres datasource provisioning for Grafana 12+ by @pashagolub in [-] fix Grafana postgres datasource provisioning for Grafana 12+ #1406
• [-] fix potential race conditions, fixes Investigate potential race condition on SourceConn struct #1359 by @pashagolub in [-] fix potential race conditions, fixes #1359 #1492
• [-] fix the way log parser started in new DbConnReaper by @pashagolub in [-] fix the way log parser started in new DbConnReaper #1517
• [-] fix v12 "Replication lag" panel, closes Replication lag (byte) dashboard panel expects "total_lag" field which is not provided by replication metric #1444 by @youdie006 in [-] fix v12 "Replication lag" panel, closes #1444 #1483
• [-] forbid different pgURI for metrics and sources, fixes Error when using different databases for --sources and --metrics #1288 by @pashagolub in [-] forbid different pgURI for metrics and sources, fixes #1288 #1519
• [-] handle pg sink being down gracefully, fixes pgwatch goes mad when the pg sink is down #1426 by @0xgouda in [-] handle pg sink being down gracefully, fixes #1426 #1429
• [-] patch security vulnerabilities in webui dependencies by @pashagolub in [-] patch security vulnerabilities in webui dependencies #1477
• [-] sanitize NaN/Inf float values in measurements, fixes Postgres sink fails with "COPY from stdin failed: unsupported value: NaN" for psutil_mem metric #1416 by @justin212407 in [-] sanitize NaN/Inf float values in measurements, fixes #1416 #1418
• [-] use random JWT secret instead of hardcoded key by @pashagolub in [-] use random JWT secret instead of hardcoded key #1475
• [*] add cache for Postgres continous discovery by @pashagolub in [*] add cache for Postgres continous discovery #1513
• [*] change backends values from int to float by @avandras in [*] change backends values from int to float #1439
• [*] fix log message by @0xgouda in [*] fix log message #1413
• [*] improve "Health check" dashboard by @pashagolub in [*] improve "Health check" dashboard #1486
• [*] improve Replication dashboards by @pashagolub in [*] improve Replication dashboards #1489
• [*] improve source reaper error logging by @pashagolub in [*] improve source reaper error logging #1456
• [*] migrate to time-only partitioning in pg sink by @0xgouda in [*] migrate to time-only partitioning in pg sink #1408
• [*] move Cybertec logo to repo by @pashagolub in [*] move Cybertec logo to repo #1433
• [*] refactor reaper.Reap() by @pashagolub in [*] refactor reaper.Reap() #1505
• [*] remove duplicate assignment to metricsConfig by @pashagolub in [*] remove duplicate assignment to metricsConfig #1493
• [*] remove EOL Grafana v11 dashboards by @pashagolub in [*] remove EOL Grafana v11 dashboards #1407
• [*] repurpose duplicate_count in DROP INDEX recommendations by @avandras in [*] repurpose duplicate_count in DROP INDEX recommendations #1446
• [*] serve dashboards Cybertec logo from the repo by @pashagolub in [*] serve dashboards Cybertec logo from the repo #1434

New Contributors

• @justin212407 made their first contribution in [-] sanitize NaN/Inf float values in measurements, fixes #1416 #1418
• @avandras made their first contribution in [*] repurpose duplicate_count in DROP INDEX recommendations #1446
• @youdie006 made their first contribution in [-] fix v12 "Replication lag" panel, closes #1444 #1483

Full Changelog: v5.2.0...v6.0.0-beta

What to do next?

• Star the repository
• Read the documentation
• Check out the blog
• Follow us on Linkedin, YouTube, Twitter and Facebook.

---

This discussion was created from the release v6.0.0-beta.