PostgreSQL: pgwatch v4 is out!

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

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 m...

Get the full details here: PostgreSQL: pgwatch v4 is out!