Documentation forSolarWinds Observability

Queries Explorer

If you are monitoring databases with SolarWinds Observability, you can see a list of observed queries for a selected period by going to Analyze > Queries. This displays observed queries for the selected time period listed in digest format by total time, allowing you to determine which queries are consuming the most time. Queries observed within the last hour are displayed by default.

Queries Overview

To view details for a selected query, click the Query Details icon to the right of the query to open the Queries Overview.

The Queries overview displays detailed information about the selected query. The full query text is displayed along the top of the page, with Latency, Total Time, Throughput, Errors, and Results graphs displayed along the bottom of the page. Each graph displays information for the selected query through the selected time period. The following charts are available:

Chart Description
Average Latency This option is displayed in the Latency graph by default. Displays the amount of query latency in milliseconds per query execution for the selected time period.
P99 Click P99 from the drop-down menu in the latency graph to display this option. Displays the amount of query latency in the 99th percentile value for the selected time period.
Total Time Displays the execution time in milliseconds per query execution for the selected time period.
Throughput Displays the amount of query throughput in milliseconds per query execution for the selected time period.
Errors Displays the amount of errors per query execution for the selected time period.
Results Displays the amount of rows sent per query execution for the selected time period.

The right of the Queries Overview page displays identifiers for the selected query. The following identifiers are displayed:

Metric Description
Query ID Displays a unique query identification number for the selected query.
First Seen Displays the date and time the query was first observed by SolarWinds Observability.
Tags Displays tags associated with the selected query.
Users Displays users associated with the selected query.

Click the query text to open the Query Digest. The Query Digest displays the full query text in an easy to read format.

Query Samples

SolarWinds Observability captures raw samples of the queries that are sent to your monitored database in addition to aggregate query metrics. This provides richer detail into query activity, especially slow queries or queries which generate errors, and also lets you examine execution plans for opportunities for optimization. The sample page allows you to answer questions such as:

  • What queries did this user run which took longer than 2 seconds?

  • What slow queries use this database?

  • What queries did this client run?

From the Queries Overview page, click Samples to open the Sample page for the selected query. The Samples page displays captured query samples for the selected query and details about the query execution.

The following metrics are available:

Metric Description
Sample Displays a recorded query sample of the selected query.
Timestamp Displays the day and time when the query sample was created.
Latency Displays the average latency for the query sample in milliseconds.

Database

Displays the database that the query was executed against.
User Displays the user(s) that executed the query.
Origin Displays the IP address and port of the client that issued the query.

Click a query sample to open the Explain Plan for your selection. The query sample metrics are displayed to the right of the Explain Plan.

Click Sample ID to return to the query samples page.