SQL 执行历史

获取某个用户在集群的 SQL 执行历史，最多展示最近的10条

接口URL

/api/v1/dms/sqleditor/statements?clusterID=&userID=

请求方式

GET

Content-Type

application/json

认证方式

Bearer auth

请求Query参数

成功响应示例

{
    "Data": {
        "statementResults": [
            {
                "ResultID": "stmt-8051341647989475",
                "clusterID": "tidb-f91e1f860d360502",
                "execPlan": {
                    "columns": null,
                    "rows": null,
                    "matrix": true,
                    "msg": "",
                    "summary": "Query OK!"
                },
                "execInfo": {
                    "startTime": "2023-09-21T15:23:34.208742681+08:00",
                    "endTime": "2023-09-21T15:23:34.210476396+08:00",
                    "executeTime": "0.002 s",
                    "query": "SELECT * FROM regions;",
                    "limit": 1000,
                    "rowCount": 5
                },
                "resultSet": {
          "code": 0, // 0 表示成功，非 0 表示失败（比如下面 msg )
                    "columns": null,
                    "rows": null,
                    "matrix": true,
                    "msg": "",
                    "summary": "Query OK!"
                },
                "database": "test",
                "userID": "haibo"
            },
        ]
    },
    "Success": true
}