TOP SQL
接口URL
/api/v1/cluster/topsql/list
请求方式
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 * from regions ;",
"DatabaseName": "test",
"TotalLatency": 1435301,
"ExecuteTimes": 1,
"AverageLatency": 1435301,
"PlanCount": 1,
"Digest": "85850684ec34c93691da0bc722ede8bc7e9fed111b38a0669408d5cc98460e72"
}, {
"SQLName": "explain select * from regions ;",
"DatabaseName": "test",
"TotalLatency": 744761,
"ExecuteTimes": 1,
"AverageLatency": 744761,
"PlanCount": 1,
"Digest": "794687215e7b9f6716c7fb83c6d1571896f9013282dcea09133e6943e776f98d"
}],
"Success": true
}
| 参数名 | 示例值 | 参数类型 | 参数描述 |
|---|---|---|---|
| code | - | String | |
| data | - | Array | |
| data.averageLatency | - | Number | |
| data.databaseName | - | String | |
| data.digest | - | String | |
| data.executeTimes | - | Integer | |
| data.planCount | - | Integer | |
| data.sqlname | - | String | |
| data.totalLatency | - | Integer | |
| message | - | String | |
| success | - | Boolean |