cybertec-postgresql/pgwatch v6.0.0

on GitHub

pgwatch v6 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 Prometheus 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 collection core no longer runs one goroutine per (source × metric) — it runs one per source, waking on a shared tick and sending every due metric in a single round-trip. On a six-source test run that removes 414 goroutines, cuts steady-state allocation by 8–9×, and drops GC CPU by roughly 3×. Around it, the per-source sweep in the main loop is now bounded-parallel (32 at a time) on every refresh, every database round-trip has a deadline, and continuous discovery is served from a last-known-good cache when it fails. Translation: one wedged database can no longer stall the fleet, and a restart is no longer the fix.

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

What's Changed

• [!] add Prometheus exporter as a pgwatch source by @pashagolub in #1405
• [!] bump Postgres to v19 by @pashagolub in #1497
• [!] reaper goroutine consolidation via pgx.Batch queries (#1316)
• [!] refactor reaper.Reap main loop as parallel by @pashagolub in #1512
• [!] restructure docs into Diátaxis quadrants by @pashagolub in #1532
• [!] transform v13 dashboards to row layout with unified colophon by @pashagolub in #1500
• [!] upgrade webui to React v19, MUI v9, MUI X Data Grid v9 by @pashagolub in #1422
• [!] upgrade Grafana dashboards to v13 by @pashagolub in #1487
• [!] use bounded contexts for all database round-trips by @pashagolub in #1511
• [+] add "Lock details" dashboard by @pashagolub in #1498
• [+] add .git-blame-ignore-revs by @pashagolub in #1389
• [+] add autovacuum_scores metric by @nadashaban11 in #1403
• [+] add mem_exceeded_count to pg_stat_replication_slots, closes #1395 by @pashagolub in #1503
• [+] add recovery metric, closes #1394 by @pashagolub in #1490
• [+] add settings_num metric, closes #1247 by @pashagolub in #1436
• [+] add stat_lock metric to report per-lock statistics, closes #1393 by @pashagolub in #1496
• [+] add stats_reset to table_*stats and index_stats, closes #1396 by @pashagolub in #1502
• [+] add wal_fpi_bytes field to wal_stats metric, fixes #1399 by @nadashaban11 in #1402
• [+] add Prometheus "Server Log Events" dashboard by @pashagolub in #1518
• [+] add Prometheus stored procedures dashboards by @pashagolub in #1516
• [+] add Prometheus variant of "Version Overview" dashboard by @pashagolub in #1514
• [+] add stats_reset to sproc_stats and database_conflicts metrics, closes #1397 by @pashagolub in #1501
• [+] add support for Task build tool by @pashagolub in #1504
• [+] add v13 "Health check" dashboard by @avandras in #1448
• [+] add v13 global DB overview dashboard by @avandras in #1454
• [+] bump @humanfs/node from 0.16.7 to 0.16.8 by @dependabot[bot] in #1546
• [+] bump actions/cache from 5 to 6 by @dependabot[bot] in #1453
• [+] bump actions/checkout from 6 to 7 by @dependabot[bot] in #1447
• [+] bump actions/setup-go from 6 to 7 by @dependabot[bot] in #1465
• [+] bump actions/setup-node from 6 to 7 by @dependabot[bot] in #1462
• [+] bump actions/setup-python from 6 to 7 by @dependabot[bot] in #1468
• [+] bump actions/stale from 10 to 11 by @dependabot[bot] in #1478
• [+] bump axios from 1.15.0 to 1.18.0 in webui by @dependabot[bot] in #1390 #1424 #1471
• [+] bump brace-expansion from 5.0.6 to 5.0.9 in webui by @dependabot[bot] in #1485 #1420
• [+] bump browserslist from 4.28.1 to 4.28.8 by @dependabot[bot] in #1543
• [+] bump etcd/client/v3 from 3.6.11 to 3.6.12 by @dependabot[bot] in #1431
• [+] bump go.etcd.io/etcd/client/v3 from 3.6.12 to 3.7.1 by @dependabot[bot] in #1461 #1472
• [+] bump google.golang.org/grpc from 1.81.0 to 1.83.0 by @dependabot[bot] in #1410 #1457 #1463 #1479
• [+] bump google.golang.org/protobuf from 1.36.11 to 1.36.12 by @dependabot[bot] in #1522
• [+] bump gopsutil/v4 from 4.26.4 to 4.26.5 by @dependabot[bot] in #1425
• [+] bump grpc from 1.80.0 to 1.81.0 by @dependabot[bot] in #1388
• [+] bump jackc/pgx/v5 from 5.9.2 to 5.10.0 by @dependabot[bot] in #1432
• [+] bump js-yaml from 4.3.0 to 4.3.2 in webui by @dependabot[bot] in #1510 #1557
• [+] bump nanoid from 3.3.16 to 3.3.18 in webui by @dependabot[bot] in #1509
• [+] bump prometheus/client_golang from 1.23.2 to 1.24.1 by @dependabot[bot] in #1469 #1473
• [+] bump sethvargo/go-retry from 0.3.0 to 0.4.0 by @dependabot[bot] in #1466
• [+] bump shirou/gopsutil/v4 from 4.26.5 to 4.26.7 by @dependabot[bot] in #1458 #1484
• [+] bump sirupsen/logrus from 1.9.4 to 1.10.0 by @pashagolub in #1524
• [+] bump testcontainers/testcontainers-go from 0.42.0 to 0.44.0 by @dependabot[bot] in #1450 #1508
• [+] bump vite from 7.3.2 to 8.0.16 by @pashagolub in #1421 #1440 #1445
• [+] bump yaml from 1.10.0 to 2.8.4 in webui by @pashagolub in #1391
• [+] bump pgwatch module to v6 by @pashagolub in #1530
• [+] cut allocations in PrometheusWriter.WritePromMetrics by @pashagolub in #1550
• [+] improve admin.drop_all_metric_tables routine, closes #1474 by @pashagolub in #1520
• [+] increase test coverage for testutil package by @pashagolub in #1521
• [-] avoid deadlock in SourceReaper, fixes #1412 by @pashagolub in #1417
• [-] fix checkpointer metric by @0xgouda in #1411
• [-] fix Grafana postgres datasource provisioning for Grafana 12+ by @pashagolub in #1406
• [-] fix multiple logging errors by @0xgouda in #1541
• [-] fix partition creation after long downtime, closes #1529 by @0xgouda in #1531
• [-] fix potential race conditions, fixes #1359 by @pashagolub in #1492
• [-] fix the default dashboard file name by @0xgouda in #1538
• [-] fix the way log parser started in new DbConnReaper by @pashagolub in #1517
• [-] fix v12 "Replication lag" panel, closes #1444 by @youdie006 in #1483
• [-] fix webui column resizing glitches by @0xgouda in #1527
• [-] forbid different pgURI for metrics and sources, fixes #1288 by @pashagolub in #1519
• [-] handle pg sink being down gracefully, fixes #1426 by @0xgouda in #1429
• [-] patch security vulnerabilities in webui dependencies by @pashagolub in #1477
• [-] sanitize NaN/Inf float values in measurements, fixes #1416 by @justin212407 in #1418
• [-] use random JWT secret instead of hardcoded key by @pashagolub in #1475
• [*] add cache for Postgres continous discovery by @pashagolub in #1513
• [*] add missing if condition to pg partitioning logic by @0xgouda in #1534
• [*] change backends values from int to float by @avandras in #1439
• [*] fix log message by @0xgouda in #1413
• [*] handle counter resets in dashboard queries by @0xgouda in #1528
• [*] improve "Health check" dashboard by @pashagolub in #1486
• [*] improve Replication dashboards by @pashagolub in #1489
• [*] improve source reaper error logging by @pashagolub in #1456
• [*] migrate to time-only partitioning in pg sink by @0xgouda in #1408
• [*] move Cybertec logo to repo by @pashagolub in #1433
• [*] optimize flush() in pg sink by @0xgouda in #1537
• [*] optimize prom sink memory usage by @0xgouda in #1549
• [*] refactor reaper.Reap() by @pashagolub in #1505
• [*] remove duplicate assignment to metricsConfig by @pashagolub in #1493
• [*] remove EOL Grafana v11 dashboards by @pashagolub in #1407
• [*] repurpose duplicate_count in DROP INDEX recommendations by @avandras in #1446
• [*] serve dashboards Cybertec logo from the repo by @pashagolub in #1434

New Contributors

• @justin212407 made their first contribution in #1418
• @avandras made their first contribution in #1446
• @youdie006 made their first contribution in #1483

Full Changelog: v5.3.0...v6.0.0

What to do next?

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