慢日志-某时间段慢SQL查询

接口描述

某时间段慢SQL查询接口

Action: SlowLogDetail

Method: GET

Version：2016-07-01

请求参数

输入项中文名称	字段名	数据类型	是否必须	取值范围及备注
id	DBInstanceIdentifier	String	是
标识	checksum	String
	StartTime	String	是	yyyy-MM-dd HH:mm:ss
	EndTime	String	是	yyyy-MM-dd HH:mm:ss
	Page	int	否
	Size	int	否
	SortBy	String	否
排序方式	SortWay	int	否	1 正序(升序) 2 倒序(倒列)
匹配操作	HeadKey	String	否	以INSERT、UPDATE、DELETE、SELECT为首进行匹配
具体模板	FingerPrint

返回值

输出项中文名称	字段名	数据类型
标识	checksum	String
SQL模版	fingerprint	String
sql内容	sqlContent	String
数据库	metricsDb	String
数据库ip地址	hostname	String
数据库用户	metricsUser	String
执行时间	queryTime	String
等待时间	lockTime	String
扫描行	rowsExamined	String
平均返回行	rowsSent	String
当前用户、数据库用户	currentUser	String
认证用户	authUser	String
执行次数	queryCount	String

请求示例

curl --location --request GET 'https://krds.console.ksyun.com?DBInstanceIdentifier=fba6******************&StartTime=2020-06-08%2001:00:00&EndTime=2020-06-08%2023:58:58&Marker=0&MaxRecords=10&Action=SlowLogDetail&FingerPrint=SELECT%20TIMESTAMPDIFF(SECOND,%20value,%20convert(now(),%20datetime))%20AS%20heartbeat_delay%20FROM%20mysql.rds_heartbeat;&SortWay=2&SortBy=queryTime' 

返回样例

{
    "data": [
        {
            "id": "fba6*****************",
            "sqlExecTimeStamp": "1591604478",
            "aggTime": "202006081625",
            "authUser": "rdsadmin",
            "currentUser": "rdsadmin",
            "hostname": "localhost",
            "queryTime": "0.000564",
            "lockTime": "0.000393",
            "rowsSent": "1",
            "rowsExamined": "1",
            "sqlContent": "select TIMESTAMPDIFF(SECOND, value, convert(now(), datetime)) as heartbeat_delay from mysql.rds_heartbeat;",
            "threadId": "402542",
            "productId": "fba6*****************",
            "tenantId": "c7f3*****************",
            "checksum": "5540cd0746ddbacf236823f043a0400c",
            "fingerprint": "SELECT TIMESTAMPDIFF(SECOND, value, convert(now(), datetime)) AS heartbeat_delay FROM mysql.rds_heartbeat;"
        }，
        {
            "id": "fba6*****************",
            "sqlExecTimeStamp": "1591605529",
            "aggTime": "202006081640",
            "authUser": "rdsadmin",
            "currentUser": "rdsadmin",
            "hostname": "localhost",
            "queryTime": "0.000369",
            "lockTime": "0.000216",
            "rowsSent": "1",
            "rowsExamined": "1",
            "sqlContent": "select TIMESTAMPDIFF(SECOND, value, convert(now(), datetime)) as heartbeat_delay from mysql.rds_heartbeat;",
            "threadId": "403632",
            "productId": "fba6*****************",
            "tenantId": "c7f3*****************",
            "checksum": "5540cd0746ddbacf236823f043a0400c",
            "fingerprint": "SELECT TIMESTAMPDIFF(SECOND, value, convert(now(), datetime)) AS heartbeat_delay FROM mysql.rds_heartbeat;"
        }
    ],
    "TotalCount": 89,
    "Marker": 0
}