接口功能介绍
查询TOP语句。
接口约束
无
URI
GET /v2/operation/topsqls
路径参数
无
Query参数
参数 | 是否必填 | 参数类型 | 说明 | 示例 | 下级对象 |
---|---|---|---|---|---|
prodInstId | 是 | String | 产品实例id,涉及实例的接口一律使用产品实例id | cb236d462b924ef7bfba5ecf1d61de2b | |
nodeId | 是 | String | 内部节点id | /dbproxy_cluster/dbproxy_cluster_0000000005/nodes/node_0000000279 | |
type | 是 | String | top类型,all、slow、broadcast、risk | all | |
topSQLCount | 否 | String | 查询top语句数量,若为空或小于1,默认是10 | 10 |
请求参数
请求头header参数
无
请求体body参数
无
响应参数
参数 | 是否必填 | 参数类型 | 说明 | 示例 | 下级对象 |
---|---|---|---|---|---|
code | 是 | String | 返回码 取值范围:0表示成功,1表示失败 | 0 | |
message | 是 | String | 结果描述 | success | |
result | 否 | Array of Objects | 返回对象,列表,若无该字段或该字段为null或者空列表,都代表返回对象为空。 | result |
表 result
参数 | 是否必填 | 参数类型 | 说明 | 示例 | 下级对象 | |
---|---|---|---|---|---|---|
statement | 否 | String | sql statement | INSERT INTO pc1 ( id , name ) VALUES ( ? , ? ) | ||
count | 是 | Long | 执行次数 | 12 | ||
type | 是 | String | topsql类型 | all | ||
totalTime | 是 | Long | 总耗时,毫秒 | 393 | ||
avgTime | 是 | Long | 平均耗时,毫秒 | 131 | ||
minTime | 是 | Long | 最小耗时,毫秒 | 44 | ||
maxTime | 是 | Long | 最大耗时,毫秒 | 189 | ||
ip | 否 | String | 客户端ip | 192.168.128.1 | ||
begin | 是 | String | 开始时间 | 2022-10-18 06:53:51 | ||
end | 是 | String | 结束时间 | 2022-10-18 08:47:25 | ||
schema | 否 | String | schema | DBPROXYCDC |
请求示例
请求头header
无
请求体body
无
响应示例
{
"code": 0,
"message": "success",
"result": [
{
"statement": "INSERT INTO pc1 ( id , name ) VALUES ( ? , ? ) ",
"count": 3,
"type": "ALL",
"totalTime": 393,
"avgTime": 131,
"minTime": 44,
"maxTime": 189,
"ip": "192.168.128.1",
"begin": "2022-10-18 06:53:51",
"end": "2022-10-18 09:23:48",
"schema": "DBPROXYCDC"
},
{
"statement": "SHOW FULL tables FROM `DBPROXYCDC` WHERE table_type = ? ",
"count": 1,
"type": "ALL",
"totalTime": 348,
"avgTime": 348,
"minTime": 348,
"maxTime": 348,
"ip": "192.168.128.1",
"begin": "2022-10-18 06:53:51",
"end": "2022-10-18 09:23:48",
"schema": "DBPROXYCDC"
},
{
"statement": "SHOW CREATE TABLE `DBPROXYCDC` . `pc1` ",
"count": 1,
"type": "ALL",
"totalTime": 85,
"avgTime": 85,
"minTime": 85,
"maxTime": 85,
"ip": "192.168.128.1",
"begin": "2022-10-18 06:53:51",
"end": "2022-10-18 09:23:48",
"schema": "DBPROXYCDC"
},
{
"statement": "EXPLAIN SELECT * FROM `DBPROXYCDC` . `pc1` LIMIT ? , ? ; ",
"count": 1,
"type": "ALL",
"totalTime": 135,
"avgTime": 135,
"minTime": 135,
"maxTime": 135,
"ip": "192.168.128.1",
"begin": "2022-10-18 06:53:51",
"end": "2022-10-18 09:23:48",
"schema": "DBPROXYCDC"
},
{
"statement": "SELECT * FROM `DBPROXYCDC` . `pc1` LIMIT ? , ? ; ",
"count": 1,
"type": "ALL",
"totalTime": 1508,
"avgTime": 1508,
"minTime": 1508,
"maxTime": 1508,
"ip": "192.168.128.1",
"begin": "2022-10-18 06:53:51",
"end": "2022-10-18 09:23:48",
"schema": "DBPROXYCDC"
},
{
"statement": "SHOW keys FROM `DBPROXYCDC` . `pc1` ",
"count": 1,
"type": "ALL",
"totalTime": 2,
"avgTime": 2,
"minTime": 2,
"maxTime": 2,
"ip": "192.168.128.1",
"begin": "2022-10-18 06:53:51",
"end": "2022-10-18 09:23:48",
"schema": "DBPROXYCDC"
},
{
"statement": "SHOW FULL fields FROM `DBPROXYCDC` . `pc1` ",
"count": 1,
"type": "ALL",
"totalTime": 16,
"avgTime": 16,
"minTime": 16,
"maxTime": 16,
"ip": "192.168.128.1",
"begin": "2022-10-18 06:53:51",
"end": "2022-10-18 09:23:48",
"schema": "DBPROXYCDC"
}
]
}
状态码
请参考 状态码说明。