ClickHouse Slow Query Management

Querying Ongoing Slow SQL Statements

1. Log in to the CloudTable console.
2. Click the name of the target cluster to access its details page.
3. In the navigation pane on the left, choose Slow Query Management.
4. Use filter criteria such as the latency, time range, user, remote IP, and SQL statement to quickly find out or kill the desired slow queries.

   Table 1 Ongoing slow query parameters

   Parameter	Description
   Query ID	ID of each SQL command
   Start time	Time when the SQL statement starts to be executed
   End time	Time when the SQL statement execution ends
   Database	Database that is being queried
   SQL Statement	Ongoing SQL statement
   Latency (ms)	SQL execution duration
   Status	SQL status
   User	User who submitted the SQL statement.
   Remote IP	Address of the client used by the user who submitted the SQL statement.
   Operation	Operation for killing the query

Querying Completed Slow SQL Statements

1. Log in to the CloudTable console.
2. Click the name of the target cluster to access its details page.
3. In the navigation pane on the left, choose Slow Query Management and click Completed Queries.
4. Use filter criteria such as the latency, time range, status, user, remote IP, and SQL statement to quickly find out the desired slow queries.

   Table 2 Completed slow query parameters

   Parameter	Description
   Query ID	ID of each SQL command
   Start time	Time when the SQL statement starts to be executed
   End time	Time when the SQL statement execution ends
   Database	Queried database
   SQL Statement	Completed SQL statement
   Latency (ms)	SQL execution duration
   Status	SQL status
   User	User who submitted the SQL statement.
   Remote IP	Address of the client used by the user who submitted the SQL statement.

Slow SQL Query Statuses

The slow SQL query statuses include FINISHED, RUNNING, or CANCELLED. When the status is RUNNING, Kill Query is displayed in the Operation column.