pgwatch v4 is out!

[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!