Dasha - performance dashboard

Dasha is an open source performance dashboard for PostgreSQL fleets. It connects to your clusters with a read-only role, shows what the databases are doing right now, and explains what to do about it. Nothing is installed on the database hosts: no agent, no extension beyond the ones you already have.

One instance serves many clusters and all of their replicas. Because most PostgreSQL statistics are per-instance and are not replicated, Dasha reads every host of a cluster and reasons over the combined picture — an index that looks unused on the primary may be serving the entire read workload on a standby.

---

Features

• Health Score — a composite 0-100 score per instance across eight categories, with prioritized recommendations and per-database drill-down. Optionally computed from Prometheus/VictoriaMetrics time series instead of point-in-time SQL, with a trend and seasonal baseline.
• Query analysis — top queries by execution time and WAL, running and blocked queries, and pg_stat_statements snapshots that can be saved to a storage database, shared by URL, and diffed against another snapshot or against live data.
• Automatic snapshots — a separate daemon captures query and lock-contention snapshots on activity spikes or primary/replica role changes, so the evidence exists the next morning, when someone asks what happened at 03:00.
• Index analysis — bloat, duplicates, invalid indexes, B-tree on arrays, plus a may I drop this index? verdict that accounts for statistics resets, per-host counters and partitioned indexes, instead of trusting idx_scan = 0.
• Tables and maintenance — size with TOAST breakdown, per-table describe, autovacuum and wraparound thresholds computed with PostgreSQL's own formula, vacuum progress, and hot tables/indexes derived from scheduled delta snapshots.
• Locks, waits, connections — lock trees, wait events grouped by type, connection states and sources, active session details.
• Access control — three auth modes (open, static API keys, or OIDC with encrypted session cookies), Casbin RBAC, personal access tokens and per-identity rate limiting.
• MCP connector — a read-only MCP server that exposes the fleet diagnostics to AI assistants: 26 tools, 5 prompts, per-user token passthrough, and an embedded knowledge base of the scoring rules. The interface is available in English, Russian and German.

Requirements

• PostgreSQL 14 or newer (tested on 14-18) for the monitored clusters, reachable with a role holding pg_monitor and CONNECT.
• pg_stat_statements for query statistics; pgstattuple is optional.
• A separate PostgreSQL database if you want snapshots, hot-object history and personal access tokens — everything else works without it.

Documentation

• README — configuration, deployment, Helm values.
• Health Score scoring model
• Changelog

License

Dasha is licensed under the GNU General Public License v3.0; see LICENSE.

Project page: github.com/dbulashev/dasha