Queries SQL log reports.
Operation description
Debugging
Authorization information
There is currently no authorization information disclosed in the API.
Request parameters
Parameter | Type | Required | Description | Example |
---|---|---|---|---|
DBInstanceId | string | Yes | The instance ID. You can call the DescribeDBInstances operation to query the instance ID. | rm-uf6wjk5xxxxxxx |
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. | 2021-03-13T16:00: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.
| 2021-03-18T16:00:00Z |
PageSize | integer | No | The number of entries per page. Valid values:
Default value: 30. | 30 |
PageNumber | integer | No | The page number. Valid values: any non-zero positive integer. Default value: 1. | 1 |
Response parameters
Examples
Sample success responses
JSON
format
{
"RequestId": "08A3B71B-FE08-4B03-974F-CC7EA6DB1828\t",
"PageNumber": 1,
"PageRecordCount": 30,
"TotalRecordCount": 60,
"Items": {
"Item": [
{
"ReportTime": "2019-03-27T16:00:00Z",
"LatencyTopNItems": {
"LatencyTopNItem": [
{
"SQLText": "SELECT * FROM table_name;",
"SQLExecuteTimes": 5,
"AvgLatency": 500
}
]
},
"QPSTopNItems": {
"QPSTopNItem": [
{
"SQLExecuteTimes": 5,
"SQLText": "SELECT * FROM table_name;"
}
]
}
}
]
}
}
Error codes
For a list of error codes, visit the Service error codes.