Tencent Cloud

search by keyword

Recent Pages

Documentation

DescribeSlowLogData

Last updated: 2020-04-23 18:53:07

1. API Description

Domain name for API request: cdb.tencentcloudapi.com.

This API is used to search for slow logs of an instance by criteria. You can only view slow logs within a month.

A maximum of 20 requests can be initiated per second for this API.

Note: This API supports Finance regions. If the common parameter Region is a Finance region, a domain name with the Finance region needs to be specified, for example: cdb.ap-shanghai-fsi.tencentcloudapi.com

2. Input Parameters

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 parameter. The value used for this API: DescribeSlowLogData.
Version	Yes	String	Common parameter. The value used for this API: 2017-03-20.
Region	Yes	String	Common parameter. For more information, please see the list of regions supported by the product.
InstanceId	Yes	String	Instance ID.
StartTime	Yes	Integer	Start timestamp.
EndTime	Yes	Integer	End timestamp.
UserHosts.N	No	Array of String	Client `Host` list.
UserNames.N	No	Array of String	Client username list.
DataBases.N	No	Array of String	Accessed database list.
SortBy	No	String	Sort by field. Valid values: Timestamp, QueryTime, LockTime, RowsExamined, RowsSent.
OrderBy	No	String	Sorting order. Valid values: ASC (ascending), DESC (descending).
Offset	No	Integer	Offset. Default value: 0.
Limit	No	Integer	Number of results to be returned at a time. Maximum value: 400.

3. Output Parameters

Parameter Name	Type	Description
TotalCount	Integer	Number of eligible entries.
Items	Array of SlowLogItem	Queried results. Note: this field may return null, indicating that no valid values can be obtained.
RequestId	String	The unique request ID, which is returned for each request. RequestId is required for locating a problem.

4. Example

Example1 Querying instance slow logs by search criteria

Input Example

https://cdb.tencentcloudapi.com/?Action=DescribeSlowLogData
&InstanceId=cdb-c1nl9rpv
&StartTime=1585142640
&EndTime=1585142640
&UserNames.0=usename0
&DataBases.0=database0
&UserHosts.0=userhosts0
&SortBy=RowsSent
&OrderBy=DESC
&Limit=400
&Offset=0
&<Common request parameters>

Output Example

{
  "Response": {
    "RequestId": "6EF60BEC-0242-43AF-BB20-270359FB54A7",
    "TotalCount": 1,
    "Items": [
      {
        "Database": "1231231",
        "LockTime": 1,
        "Md5": "23123123",
        "QueryTime": 100,
        "RowsExamined": 0,
        "RowsSent": 0,
        "SqlTemplate": "show master status111111",
        "SqlText": "update order_logistics set logistics_status = 205 where logistics_id in ( select `logistics_id` from `order_info` where order_no in('15706082880074381752', '15706082880074381751'))",
        "Timestamp": 1585142640,
        "UserHost": "localhost",
        "UserName": "marchzcma"
      }
    ]
  }
}

5. Developer Resources

API Explorer

This tool allows online call, signature authentication, SDK code generation and quick search of APIs to greatly improve the efficiency of using TencentCloud APIs.