[pgwatch](https://pgwat.ch/) 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](https://demo.pgwatch.com/). And you can check the detailed [changelog on Github](https://github.com/cybertec-postgresql/pgwatch/releases/tag/v4.0.0). ### 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](https://postgres.ai/docs/monitoring)); * 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](https://postgres.ai/docs/monitoring)); * 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](https://github.com/cybertec-postgresql/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](https://github.com/cybertec-postgresql/pgwatch/stargazers) to the project, * feel free to open an 🤚[issue](https://github.com/cybertec-postgresql/pgwatch/issues) and ask a 🎓[question](https://github.com/cybertec-postgresql/pgwatch/discussions) * or even consider submitting a 📜[pull request](https://github.com/cybertec-postgresql/pgwatch/pulls). We appreciate your support!
