Queries the slow log details of an instance.
Operation description
Debugging
Authorization information
Request parameters
Parameter | Type | Required | Description | Example |
---|---|---|---|---|
DBInstanceId | string | Yes | The ID of the instance. You can call the DescribeDBInstances operation to query the ID of the instance. | rm-uf6wjk5****** |
SQLHASH | string | No | The unique ID of the SQL statement. The ID is used to obtain the slow query logs of the SQL statement. | U2FsdGVk**** |
StartTime | string | Yes | The beginning of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time must be in UTC. | 2020-06-17T16:00Z |
EndTime | string | Yes | The end of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time must be in UTC.** Note
The end time must be later than the start time.
| 2020-06-18T16:00Z |
DBName | string | No | The name of the database. | RDS_MySQL |
PageSize | integer | No | The number of entries per page. Valid value: 30 to 200. Default value: 30. | 30 |
PageNumber | integer | No | The page number. Pages start from page 1. Default value: 1. | 1 |
NodeId | string | No | The ID of the node. Note
This parameter is available only for instances that run RDS Cluster Edition. You can specify this parameter to query the logs of a specified node. If this parameter is not specified, the logs of the primary node are returned by default.
| rn-p1fm78s90x5**** |
Response parameters
Examples
Sample success responses
JSON
format
{
"PageRecordCount": 1,
"RequestId": "4DBB1BB0-E5D8-4D41-B1C9-142364DB****",
"TotalRecordCount": 1,
"DBInstanceId": "rm-uf6wjk5*******",
"Engine": "MySQL",
"PageNumber": 1,
"Items": {
"SQLSlowRecord": [
{
"HostAddress": "xxx[xxx] @ [1xx.xxx.xxx.xx]",
"RowsAffectedCount": 34,
"QueryTimes": 2,
"SQLText": "select sleep(2)",
"CpuTime": 0.002,
"QueryTimeMS": 2001,
"ApplicationName": "example",
"LockTimes": 0,
"ExecutionStartTime": "2020-06-18T01:40:44Z",
"LogicalIORead": 383,
"WriteIOCount": 22,
"PhysicalIORead": 200,
"ReturnRowCounts": 1,
"ParseRowCounts": 1,
"DBName": "testDB",
"ClientHostName": "example",
"UserName": "user",
"LastRowsAffectedCount": 2,
"SQLHash": "U2FsdGVk****"
}
]
}
}
Error codes
HTTP status code | Error code | Error message | Description |
---|---|---|---|
400 | InvalidSearchTimeRange | search time range cannot be longer than a month. | The interval between the end time that is specified by the EndTime parameter and the start time that is specified by the StartTime parameter must be less than 31 days. Check the values of these parameters. |
400 | IO.Exception | IO exception, retry later. | An I/O error occurred. |
For a list of error codes, visit the Service error codes.
Change history
Change time | Summary of changes | Operation |
---|---|---|
2023-06-06 | The Error code has changed | View Change Details |
2023-06-02 | The Error code has changed. The request parameters of the API has changed | View Change Details |