Query metrics

Use the database instance navigator to review performance, resource consumption, active sessions, workload, query metrics, and system metrics for a selected database instance.

The Query Metrics tab provides time-series charts for query-specific performance trends, such as execution count, latency, and resource consumption.

Use this tab to correlate spikes in latency with query volume or resource usage.

Query Metrics tab showing time-series charts for query executions, duration, CPU time, active sessions, and rows returned.

Charts on the Query Metrics tab include:

  • Executions (count): Total volume of queries executed over time. Spikes can indicate sudden increases in application demand or potential query loops.

  • Total duration (sec): Cumulative time the database instance spent executing queries. Use this chart to identify periods of sustained high database load.

  • Average duration (sec): Average latency of query executions. Use this chart to pinpoint when query performance began to degrade.

  • Total CPU Time (sec): Cumulative CPU resources consumed by query execution.

  • Active sessions (count): Stacked timeline of active database sessions, color-coded by wait states such as CPU, lock contention, or I/O.

  • Total rows returned (count): Volume of data rows returned by executed queries. A sudden spike can explain elevated network latency or memory pressure on the database host.

Tip: Use chart controls to customize the visualization. Select Aggregate to change how a metric is grouped or filtered. Hover over any point on a chart to display synchronized tooltips across other charts. Drag-select a region on a graph and select Zoom in to inspect a narrower time range.