github cybertec-postgresql/pgwatch v4.0.0-beta

one day ago

What's New

This major release introduces several significant updates, new features, bug fixes, and enhancements

Important Changes

PostgreSQL 18 Metrics

  • total_XXX_time columns are added to table_stats metric;
  • read_bytes, write_bytes, and extend_bytes are added to stat_io metric;
  • use pg_stat_io for wal_stats metric;
  • use pg_ls_archive_statusdir() in archiver_pending_count metric;
  • num_done and slru_written columns are added to checkpointer metric;
  • parallel_workers_to_launch and parallel_workers_launched columns are added to db_stats metric.

Grafana Dashboards

  • New Grafana v12 dashboards have been added for both PostgreSQL and Prometheus sinks;
  • Grafana v10 support is discontinued;
  • New "Global Database Overview" dashboard with 26 panels, including new panels for replication, connections, and index usage;
  • New "Database Overview" now has 21 panels with time lag support and improved visualizations;
  • New "Query Performance Analysis" dashboard with enhanced table with 17 metrics and 8 visualization panels;
  • New "Tables Overview" dashboard providing insights into table sizes, bloat, and index usage with treemap visualizations panels.

Metrics

  • Realtime metrics have been deprecated and removed from the system.
  • Metrics can now be loaded from a specified folder, allowing for better organization and management of metric definitions.

Sinks

  • gRPC Sink Enhancements: Basic authentication support has been added to the gRPC sink, along with improved documentation for its usage.

Development and Contribution

  • The development experience with Docker Compose has been enhanced, making it easier to set up and manage the environment.
  • A new repository, pgwatch-contrib, has been created to host additional contributions and extensions for pgwatch from the community. The rpc subdirectory contains sample gRPC sinks implementations.

Changelog

New Contributors

Full Changelog: v3.7.0...v4.0.0-beta

Don't miss a new pgwatch release

NewReleases is sending notifications on new releases.