---
title: "Slow Queries dashboard"
url: "https://docs.yugabyte.com/stable/yugabyte-platform/alerts-monitoring/slow-queries-dashboard/"
---

# Slow Queries dashboard

View slow running queries that have run on your universe

Use the **Slow Queries** dashboard to analyze statistics of past queries on your YugabyteDB universes. You can use this data to do the following:

- Visually identify slower running database operations.
- Evaluate query execution times over time.
- Discover potential queries for memory optimization.

All user roles can use the **Slow Queries** dashboard.

Slow queries are displayed on the universe **Queries** tab. The top slow queries are also displayed on the **Overview** tab.

Note that slow queries are not available for YCQL.

## View Slow Queries

To access slow queries for a universe, do the following:

1. Navigate to **Universes**, select your universe, then select **Queries > Slow Queries**.
   
   Or, on the **Overview** tab, select **Top SQL Statements**. You can also access slow queries from each node in the **Nodes** page by clicking its **Actions** button.
2. If query monitoring is not enabled, select the **Query Monitoring** option to turn it on.
   
   Use the **Column Display** options to display specific fields.
   
   ![Slow Queries](/images/yp/alerts-monitoring/slow-queries/selecting-columns.png "Slow Queries")

The following table describes the **Slow Queries** column values.

Column Description 

Query The query command.  
For example, `select * from my_keyspace.my_table`. 

Database The YSQL database used by the query. 

User The name of role used to access YSQL database. 

Count/ Total count The total number of times this type of query has executed. 

Total time The total duration (in milliseconds) this query has taken. 

Rows The total number of database table rows returned across all iterations of this query. 

Avg Exec Time Average or mean execution time (in milliseconds) for this query. 

Min Exec Time Minimum execution time (in milliseconds) for this query. 

Max Exec Time Maximum execution time (in milliseconds) for this query. 

Std Dev Time Standard deviation of execution times for this query. 

Temp Tables RAM Memory used by temporary tables generated from query. 

P25 Latency Latency with its 25th percentile. 

P50 Latency Latency with its 50th percentile. 

P90 Latency Latency with its 90th percentile. 

P95 Latency Latency with its 95th percentile. 

P99 Latency Latency with its 99th percentile.

### Filter queries

You can filter the list of queries by entering terms in the **Filter by query text** field.

![Filter slow queries](/images/yp/alerts-monitoring/slow-queries/search-dropdown-options.png "Filter slow queries")

Use filtering for comparisons on numbers columns (`Avg Time`) using `>`, `>=`, `<`, and `<=` to search for values that are greater than, greater than or equal to, less than, and less than or equal to another value. For example, `Avg Time: < 30`.

You can also use the range syntax `n..m` to search for values in a range, where the first number `n` is the lowest value and the second number `m` is the highest value. The range syntax supports tokens like the following: `n..*` which is equivalent to `>= n`. Or `*..n` which is the same as `<= n`.

### View query details

Select a row to display the **Query Details** sheet, with a full view of the query statement, along with all the column data, including the Response Time Percentile and [Latency histogram](/stable/yugabyte-platform/alerts-monitoring/latency-histogram/ "Latency histogram").

![View query statement](/images/yp/alerts-monitoring/slow-queries/query-info-panel.png "View query statement")

![View query details](/images/yp/alerts-monitoring/slow-queries/query-details-panel.png "View query details")