某时间段慢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
}
文档内容是否对您有帮助?
评价建议不能为空
非常感谢您的反馈,我们会继续努力做到更好!