Skip to main content

Database Queries

The Queries tab shows aggregated performance metrics for every normalized database query. Use it to identify slow queries, high- volume queries, and queries that consume the most total database time.

Database Queries

Overview Chart​

At the top of the page, a time-series chart visualizes the selected metric over time. Use the dropdown to switch between:

  • Total Duration — Cumulative execution time across all executions.
  • Avg Duration — Mean execution time per query call.
  • Count — Number of executions.

Queries Table​

Below the chart, the table lists every normalized query:

ColumnDescription
QueryNormalized SQL statement (parameters replaced with placeholders)
CountNumber of times the query ran in the selected window
Total DurationCumulative execution time with a visual bar
Avg DurationAverage execution time
Avg RowsAverage number of rows returned or affected
Cache Hit RatioPercentage of executions served from cache
% DurationShare of total database time consumed by this query

Sorting​

Click any column header to sort. Sorting by Total Duration (descending) is the most effective way to find the queries that matter most.

Use the search bar to filter queries by SQL text.

Column Selector​

Click the column-selector button in the toolbar to toggle additional columns on or off. Hidden by default are block-level I/O columns such as Avg Shared Blocks Hit/Read, Avg Local Blocks Hit/Read, and Avg Temp Blocks Read/Written. These are useful for diagnosing I/O-heavy queries.

Show Full Query​

Toggle Show Full Query in the toolbar to expand truncated SQL statements in the table so you can read the complete query text without clicking into the detail drawer.

Filters​

The left-hand panel provides:

  • Host — Filter by database host.
  • Database — Filter by database name.
  • User — Filter by the database user that executed the query.
  • Tables — Filter by referenced table names.
  • Commands — Filter by SQL command type (e.g., SELECT, INSERT).

Click to Drill Down​

Click any query row to see:

  • A detailed execution timeline.
  • Per-host breakdown of execution statistics.
  • Link to related Samples for that query.

Support​

If you have any questions or need assistance, please contact us via our help chat app available on the Support link in the sidebar, or by reaching out to support@oodle.ai.