慢查询
接口URL
/api/v1/cluster/slowquery/lists
请求方式
POST
Content-Type
application/json
认证方式
Bearer auth
请求Header参数
| 参数名 | 示例值 | 参数类型 | 是否必填 | 参数描述 |
|---|---|---|---|---|
| Accept | application/json | Text | 是 | - |
| Content-Type | application/json | Text | 是 | - |
请求Body参数
{
"clusterID": "tidb-f91e1f860d360502",
"getListRequest": {
"limit": "10",
"minute": "120"
}
}
| 参数名 | 示例值 | 参数类型 | 是否必填 | 参数描述 |
|---|---|---|---|---|
| getListRequest.limit | - | String | 否 | - |
| getListRequest.minute | - | String | 否 | - |
成功响应示例
{
"Data": [{
"SQLName": "select sum(value),avg(value),min(value),max(value) from `metrics_schema`.`tidb_ops_statement` where time\u003e='2023-09-17 10:27:01.147' and time\u003c='2023-09-17 10:57:01.147';",
"DatabaseName": "test",
"TotalLatency": 2914764,
"ExecuteTimes": 5,
"AverageLatency": 668948.75,
"MaximumLatency": 1435301,
"PlanCount": 3,
"Digest": "cfe049ab1ecc8c91fb63c38b59a0237e904b5b4fa399081c680f7a03eeea4b57"
}, {
"SQLName": "select sum(value),avg(value),min(value),max(value) from `metrics_schema`.`tidb_ops_statement` where time\u003e='2023-09-16 03:03:01.138' and time\u003c='2023-09-16 03:33:01.138';",
"DatabaseName": "test",
"TotalLatency": 2914764,
"ExecuteTimes": 5,
"AverageLatency": 668948.75,
"MaximumLatency": 1435301,
"PlanCount": 3,
"Digest": "cfe049ab1ecc8c91fb63c38b59a0237e904b5b4fa399081c680f7a03eeea4b57"
}],
"Success": true
}
| 参数名 | 示例值 | 参数类型 | 参数描述 |
|---|---|---|---|
| Data | - | Array | |
| Data.SQLName | select sum(value),avg(value), min(value),max(value) from metrics_schema.tidb_ops_statement where time>='2023-09-17 10:27:01.147' and time<='2023-09-17 10:57:01.147'; |
String | SQL语句 |
| Data.DatabaseName | test | String | 数据库名 |
| Data.TotalLatency | 2914764 | Integer | 累计耗时 |
| Data.ExecuteTimes | 5 | Integer | 运行次数 |
| Data.AverageLatency | 668948.75 | Number | 平均耗时 |
| Data.MaximumLatency | 1435301 | Integer | 最大耗时 |
| Data.PlanCount | 3 | Integer | 执行计划版本数 |
| Data.Digest | cfe049ab1ecc8c91fb63c38b59a 0237e904b5b4fa399081 c680f7a03eeea4b57 |
String | SQL 指纹 |
| Success | true | Boolean | 成功状态 |