Explore query performance
With telemetry flowing, you can now explore your PostgreSQL query performance on the Queries overview page. This page is your starting point for identifying slow queries, understanding execution patterns, and finding optimization opportunities.
To explore your PostgreSQL query performance, complete the following steps:
Expand Observability in the navigation menu.
Expand Database in the navigation menu.
Click Queries overview.
Review the summary panels at the top of the page: Instances, Databases, Tables, Total queries executed, and Current rate show the scope of what’s being monitored. Below them, Duration average, Errors, and Rate plot query behavior over time. Spikes here indicate performance regressions or queries that need investigation.
Scroll down to the Top queries table. Each row shows a normalized SQL statement with its duration, call count, errors, and wait events. Use Search by query to find a specific statement.
Click any query row to drill into its details. The detail view shows explain plans, query samples, and wait event breakdowns for that query.
You’ve explored the Queries overview page and learned how to identify slow queries and drill into their details.
From the query detail view, you can:
- View explain plans showing how PostgreSQL executes the query
- Examine query samples with individual timing and parameters
- Analyze wait events revealing resource contention
- Review table schemas for missing indexes