pgwatch the PostgreSQL monitoring tool has been updated to version 4. This release brings a lot of new features, improvements, and bug fixes to enhance your monitoring experience.

You can see it in action on demo.pgwatch.com. And you can check the detailed changelog on Github.

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 (inspired by postgres.ai);
• 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 (inspired by postgres.ai);
• 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.

We want to thank all contributors and users for their help. If you want to contribute to pgwatch and help to make it better:

• ⭐give a star to the project,
• feel free to open an 🤚issue and ask a 🎓question
• or even consider submitting a 📜pull request.

We appreciate your support!