Dasha 1.8: index recommendations, I/O analysis, schema checks and log insights

Dasha 1.8 was released as an open‑source dashboard that reads PostgreSQL statistics without installing any agents on the database hosts. The new version adds automatic index recommendations drawn from pg_stat_statements, an I/O analysis page that relies on pg_stat_io available from PostgreSQL 16, a set of 17 schema checks for hidden structural defects, and log‑insight integration with OpenSearch, Elasticsearch and VictoriaLogs. It also introduces a health‑score metric ranging from 0‑100 that aggregates eight categories of instance health. The tool can serve many clusters from a single instance, combining per‑host data to expose issues such as an index that appears unused on a primary but powers the read workload on a standby. By proposing CREATE INDEX CONCURRENTLY statements and flagging mis‑estimated row counts, Dasha helps prevent performance regressions before they impact production. The log‑search feature groups events like deadlocks and autovacuum into time windows, making it easier to pinpoint the root cause of spikes. It is uncertain how well the automatic recommendations will perform in environments that heavily customize query plans or use extensions beyond the standard statistics views. The developers note that the I/O page requires PostgreSQL 16 or newer, but the effectiveness of the I/O breakdown on earlier versions has not been proven. Claims about the completeness of the 17 schema checks are attributed to the Dasha team, and independent verification is pending.