Smart tuning advice

Spend your tuning effort where it pays the most

MyDBA identifies the highest-impact queries in your workload, analyses them to find the best candidates for tuning, and tells you exactly what to do to improve them.

Any tool can sort queries by execution time. The hard part is knowing which of those queries are actually worth fixing — and what the fix is.

Highest-impact queries first

MyDBA ranks your workload by how much each query actually costs you — total time, calls, and resource share — so you spend tuning effort where it produces the most benefit.

The best candidates for tuning

Not every slow query is worth fixing. MyDBA narrows the workload down to the queries where a realistic fix exists and the payoff justifies the work.

Slowness & regression detection

Queries are judged against their own history, so you find out when something got slower — not just what is slow right now. Regressions surface even when nothing has crossed an alert threshold.

EXPLAIN plan analysis built in

Drill into any candidate with visual plan analysis and a guided walkthrough that narrates each node in plain language, highlighting bottlenecks and misestimates.

Plan regression detection

When a query switches to a slower execution plan, MyDBA notices and shows you what changed between the plans.

Exactly what to do next

Every recommendation ends with the concrete next step — the index to add, the rewrite to consider, or the setting to review — ready to check before anything changes.

Optional AI tuning depth

When you want a second opinion, manually invoke AI for a deeper tuning analysis grounded in the collected evidence. The core recommendations never depend on it.

How it works

  1. 1Your workload is ranked by impact — every query's share of total execution time, call volume, and resources, tracked continuously from pg_stat_statements and query telemetry.
  2. 2Slowness and regressions are detected automatically — each query is compared to its own history, so degradation surfaces even when nothing crossed a threshold.
  3. 3The best candidates are analysed — execution plans, index opportunities, and plan changes are examined to find where a realistic fix produces a real payoff.
  4. 4You get the fix, not just the finding — a concrete recommendation for each candidate, with the EXPLAIN evidence behind it, ready to review before you change anything.

Related capabilities

See it in action

Start free with one primary or standalone PostgreSQL instance and all its databases. Monitoring, alerts, query insights, index advice, team access and every non-AI feature included. No replicas. No credit card required. New Free connections get seven days of full collection, then reduced sampling. Free and Pro include 30 days of monitoring history.