Investigate database performance with Grafana Assistant
Investigate database performance with Grafana Assistant
When a database slows down, you can now ask Grafana Assistant a question like “Why is my orders database slow?” or “What are my worst-performing database queries?” and get an answer straight from your Grafana Cloud Database Observability telemetry with no PromQL or LogQL required.
A new Database Observability tool gives the Assistant structured access to the same telemetry that powers the Database Observability app. Ask for your slowest queries and you get the top 10 ranked across MySQL and PostgreSQL, with calls, latency, errors, and rows examined for each query.
Drill into a single query to get the full picture with SQL text, a per-call latency timeline, wait events, and the decoded explain plan. The answer also includes the schemas of the tables the query touches, so optimization suggestions need no follow-up lookups. From any answer, follow the deep link into the Database Observability app for the full query details page.
This capability is available in Grafana Cloud when the Database Observability app is installed and Grafana Alloy is collecting from your MySQL or PostgreSQL databases. There’s no feature toggle to enable. Open the Assistant and try questions like:
- “What are my slowest PostgreSQL queries?”
- “Why did latency spike on the orders database?”
- “Show me the explain plan for the top query on payments.”
