Querying Top Slow SQL Statements

Function

This API is used to query top slow SQL statements.

URI

GET /v3/{project_id}/instances/top-slow-log

**Table 1** URI parameter
Parameter	Mandatory	Type	Description
project_id	Yes	String	Explanation: Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID. Constraints: N/A Values: The value can contain 32 characters. Only letters and digits are allowed. Default value: N/A

**Table 2** Query parameters
Parameter	Mandatory	Type	Description
num	Yes	Integer	Explanation: Top N Constraints: N/A Values: [0, 2^31-1]. The actual value depends on the query result. Default value: N/A
start_at	Yes	Long	Explanation: Start time Constraints: Unix timestamp, in milliseconds Values: [0, 2^31-1]. The actual value depends on the query result. Default value: N/A
end_at	Yes	Long	Explanation: End time Constraints: Unix timestamp, in milliseconds Values: [0, 2^31-1]. The actual value depends on the query result. Default value: N/A

Request Parameters

None

Response Parameters

Status code: 200

**Table 3** Response body parameter
Parameter	Type	Description
top_slow_log_list	Array of Table 4 objects	Explanation: Top slow SQL statements Values: N/A

**Table 4** top_slow_log_list
Parameter	Type	Description
instance_id	String	Explanation: Instance ID Values: N/A
instance_name	String	Explanation: Instance name Values: N/A
slow_log_num	Long	Explanation: Number of slow query logs Values: [0, 2^31-1]

Example Request

"GET https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/instances/top-slow-log?num=10&start_at=1736402167045&end_at=1736403967045"

Example Response

Status code: 200

Successful request

{
      "top_slow_log_list":   [
            {
                  "instance_id":   "5c59fa7d6f09456b947f32922f9aeda1in01",
                  "instance_name":   "DAS-MYSQL-AT",
                  "slow_log_num":   21
            }
      ]
}