Tencent Cloud

Recent Pages

Slow Query Analysis

Last updated: 2024-06-27 10:52:17

Operation Guide
1. Log in to Tencent Cloud TCHouse-D Console, and select the target cluster by ID/Name in the cluster list to enter the cluster details page.
2. After switching to the Query Analysis page, you can switch to Slow Queries sub-page to perform slow query analysis.
﻿
﻿
﻿
3. This page, by default, displays slow SQL taking more than 500 ms. You can adjust the threshold for judging slow query SQL duration as needed, supporting a minimum setting of 100 ms.
Features
You can set the time range for analysis, including the last 15 minutes, last 30 minutes, last hour, or a custom time period.
It supports sorting the slow queries list by execution duration, or filtering based on database name, or SQL types:
Database Name: If you did not specify the database during the query, this column will be displayed as NULL.
SQL Type: query and non-query.
﻿
﻿
﻿