Domain name for API request: redis.tencentcloudapi.com.
This API is used to query the records of slow query.
A maximum of 20 requests can be initiated per second for this API.
The following request parameter list only provides API request parameters and some common parameters. For the complete common parameter list, see Common Request Parameters.
Parameter Name | Required | Type | Description |
---|---|---|---|
Action | Yes | String | Common Params. The value used for this API: DescribeSlowLog. |
Version | Yes | String | Common Params. The value used for this API: 2018-04-12. |
Region | No | String | Common Params. This parameter is not required for this API. |
InstanceId | Yes | String | ID of a specified instance, such as "crs-xjhsdj****" Log in to the Redis console and copy the instance ID in the instance list. |
BeginTime | Yes | String | Start time for prequerying a slow log |
EndTime | Yes | String | End time for prequerying a slow log |
MinQueryTime | No | Integer | The average execution time threshold of slow query in microseconds |
Limit | No | Integer | Number of slow queries displayed per page. Default value: 20 . Value range: [20,1000]. |
Offset | No | Integer | Slow query offset, which is an integral multiple of Limit . Calculation formula: offset = limit * (page number - 1). |
Role | No | String | Node role. - master: Master node.- slave: Replica node. |
Parameter Name | Type | Description |
---|---|---|
TotalCount | Integer | Total number of slow queries |
InstanceSlowlogDetail | Array of InstanceSlowlogDetail | Due to the naming irregularity of this parameter. It is recommended to use the parameter InstanceSlowLogDetail instead. Details of slow queries. |
InstanceSlowLogDetail | Array of InstanceSlowlogDetail | Details of slow queries. |
RequestId | String | The unique request ID, generated by the server, will be returned for every request (if the request fails to reach the server for other reasons, the request will not obtain a RequestId). RequestId is required for locating a problem. |
This example shows you how to query detailed information about slow queries for a specific instance through the DescribeSlowLog API, including the slow query commands, command line information, latency time, client addresses, and node IDs.
POST / HTTP/1.1
Host: redis.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: DescribeSlowLog
<Common request parameters>
{
"InstanceId": "crs-asda****",
"EndTime": "2019-09-09 12:12:41",
"BeginTime": "2019-09-08 12:12:41"
}
{
"Response": {
"InstanceSlowlogDetail": [
{
"Node": "833a2f6d8b402319aee8ad7f1c0fbbf7********",
"Command": "hget",
"CommandLine": "hget hash_key classify_scope::default",
"Duration": 45,
"ExecuteTime": "2019-09-08 12:13:08",
"Client": ""
},
{
"Node": "833a2f6d8b402319aee8ad7f1c0fbbf7********",
"Command": "keys",
"CommandLine": "keys OtherResControler:orion.ovs.client.1514259512471:orion.ovs.entprise.9281083591:sence:*",
"Duration": 41,
"ExecuteTime": "2019-09-08 12:13:08",
"Client": ""
},
{
"Node": "24a05f0d545da235f07a5bc5deebb937********",
"Command": "get",
"CommandLine": "get slot::fsm::status::orion.ovs.client.1508751991541::1db7ffcf9216bc1fd939e6c710514f6fb40fd4fe1525f",
"Duration": 41,
"ExecuteTime": "2019-09-08 12:13:08",
"Client": ""
}
],
"RequestId": "121d5b40-d2b8-11e9-8c40-ef686158cbd6",
"TotalCount": 106980
}
}
TencentCloud API 3.0 integrates SDKs that support various programming languages to make it easier for you to call APIs.
The following only lists the error codes related to the API business logic. For other error codes, see Common Error Codes.
Error Code | Description |
---|---|
FailedOperation.SystemError | Internal system error, which is irrelevant to the business. |
InternalError.DbOperationFailed | Internal system error with the database operation, which may be update, insert, select, etc. |
InvalidParameter.EmptyParam | The parameter is empty. |
InvalidParameter.PermissionDenied | The API has no CAM permissions. |
InvalidParameterValue.UnSupportedType | The instance type is not supported. |
ResourceNotFound.InstanceNotExists | No Redis instance is found by the serialId. |
ResourceUnavailable.InstanceStatusError | Operation unsupported: the instance is exceptional. |
本页内容是否解决了您的问题?