Dasha 1.8 expands its open-source PostgreSQL performance dashboard with new capabilities including index recommendations, I/O analysis, schema checks, and log insights. The tool operates without agents or extensions on database hosts, using a read-only role to aggregate statistics across all cluster instances and replicas. It specifically proposes missing B-tree indexes by analyzing pg_stat_statements on every host to provide a unified view of the fleet's workload.
- No agents or extensions required; connects via read-only role to existing clusters.
- Aggregates per-instance stats across primaries and standbys to avoid blind spots.
- Recommends missing B-tree indexes based on pg_stat_statements from all hosts.
- Single dashboard instance can monitor many clusters and their replicas simultaneously.
- New features include I/O analysis, schema checks, and deeper log insights.