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