获取查询Profile分析信息。
接口说明
推荐您使用可视化界面执行查询并获取 QueyID。具体操作，请参见查询审计。
版本限制
-
不支持 3.0 版本。
-
不支持创建日期在 2025-08-01 前的实例，若有需要，请联系工单支持。
调试
您可以在OpenAPI Explorer中直接运行该接口，免去您计算签名的困扰。运行成功后，OpenAPI Explorer可以自动生成SDK代码示例。
调试
授权信息
请求参数
|
名称 |
类型 |
必填 |
描述 |
示例值 |
| DBInstanceId |
string |
是 |
实例 ID。 |
selectdb-cn-7213cjv**** |
| RegionId |
string |
是 |
地域 ID。 |
cn-beijing |
| QueryId |
string |
否 |
查询 ID。 |
sq202510231018sh3b69ad10014154 |
返回参数
|
名称 |
类型 |
描述 |
示例值 |
|
object |
PlainResponse |
||
| RequestId |
string |
请求 ID。 |
F8900A96-67F7-5274-A41B-7722E1ECF8C9 |
| Profile |
string |
Profile 文本，暂未支持。 |
No Demo |
| ProfileSummary |
any |
Profile 摘要总结。 |
{ "summary": { "workloadGroup": "normal", "totalTime": "16ms", "totalTimeMs": 16, "state": "OK", "queryId": "8c7776d539f2426b-b0b654c7acc9bf8f", "sql": "SELECT * FROM demo_db.user_info WHERE status = 1" }, "operators": [ { "pipeline": 0, "frag": 0, "skewRatio": 1, "name": "RESULT_SINK_OPERATOR", "timePct": 0.34, "inputRows": 4, "execTimeAvgMs": 0.05 }, { "pipeline": 0, "frag": 0, "name": "OLAP_SCAN_OPERATOR(nereids_id=84. table_name=user_info(user_info))", "timePct": 0, "runtimeFilters": [ "RuntimeFilterInfo: sum , avg , max , min" ], "execTimeAvgMs": 0, "table": "demo_db.user_info" } ], "queryStats": { "blockedOperators": 0, "operatorCount": 2, "spilledOperators": 0, "fragmentCount": 2 }, "fragments": [ { "pipelines": 1, "instances": 1, "execTimeMs": 0.05, "id": 0 }, { "pipelines": 0, "instances": 0, "execTimeMs": 0, "id": 0 } ], "timeBreakdown": { "schedule": "4ms", "parseSql": "1ms", "nereidsAnalysis": "1ms", "waitFetchResult": "5ms", "fetchResult": "1ms", "nereidsOptimize": "N/A", "plan": "6ms", "nereidsRewrite": "1ms" }, "scannedTables": { "demoDb.userInfo": { "totalSizeGb": 0, "totalRows": 5, "tabletSkew": 1.6, "ddl": "CREATE TABLE `user_info` xxx", "tablets": 8 } } } |
示例
正常返回示例
JSON格式
{
"RequestId": "F8900A96-67F7-5274-A41B-7722E1ECF8C9",
"Profile": "No Demo",
"ProfileSummary": "{\n \"summary\": {\n \"workloadGroup\": \"normal\",\n \"totalTime\": \"16ms\",\n \"totalTimeMs\": 16,\n \"state\": \"OK\",\n \"queryId\": \"8c7776d539f2426b-b0b654c7acc9bf8f\",\n \"sql\": \"SELECT * FROM demo_db.user_info WHERE status = 1\"\n },\n \"operators\": [\n {\n \"pipeline\": 0,\n \"frag\": 0,\n \"skewRatio\": 1,\n \"name\": \"RESULT_SINK_OPERATOR\",\n \"timePct\": 0.34,\n \"inputRows\": 4,\n \"execTimeAvgMs\": 0.05\n },\n {\n \"pipeline\": 0,\n \"frag\": 0,\n \"name\": \"OLAP_SCAN_OPERATOR(nereids_id=84. table_name=user_info(user_info))\",\n \"timePct\": 0,\n \"runtimeFilters\": [\n \"RuntimeFilterInfo: sum , avg , max , min\"\n ],\n \"execTimeAvgMs\": 0,\n \"table\": \"demo_db.user_info\"\n }\n ],\n \"queryStats\": {\n \"blockedOperators\": 0,\n \"operatorCount\": 2,\n \"spilledOperators\": 0,\n \"fragmentCount\": 2\n },\n \"fragments\": [\n {\n \"pipelines\": 1,\n \"instances\": 1,\n \"execTimeMs\": 0.05,\n \"id\": 0\n },\n {\n \"pipelines\": 0,\n \"instances\": 0,\n \"execTimeMs\": 0,\n \"id\": 0\n }\n ],\n \"timeBreakdown\": {\n \"schedule\": \"4ms\",\n \"parseSql\": \"1ms\",\n \"nereidsAnalysis\": \"1ms\",\n \"waitFetchResult\": \"5ms\",\n \"fetchResult\": \"1ms\",\n \"nereidsOptimize\": \"N/A\",\n \"plan\": \"6ms\",\n \"nereidsRewrite\": \"1ms\"\n },\n \"scannedTables\": {\n \"demoDb.userInfo\": {\n \"totalSizeGb\": 0,\n \"totalRows\": 5,\n \"tabletSkew\": 1.6,\n \"ddl\": \"CREATE TABLE `user_info` xxx\",\n \"tablets\": 8\n }\n }\n }"
}错误码
|
HTTP status code |
错误码 |
错误信息 |
描述 |
|---|---|---|---|
| 400 | DocumentConvertFailed.ExceedFileSizeLimit | The conversion has been failed, exceed file size limit. | 文档转换失败，文件大小超过系统限额。 |
| 400 | Forbidden | User not authorized to operate on the specified resource, or this API does not support RAM. | 子账号权限不足，请先获取授权。 |
| 400 | InvalidDBName | The specified database name is not allowed. | 数据库名称不符合要求，请确认数据名称是否正确。 |
| 400 | CreateOrderFailed | Failed to create order. | 创建订单失败。 |
| 400 | InvalidDBInstanceId.Malformed | The specified parameter "DBInstanceId" is not valid. | 参数"DBInstanceId"不合法。 |
| 400 | InvalidParameter | Specified parameter is not valid. | 指定的参数无效。 |
| 400 | InvalidParameter.QueryId | Specified parameters is not valid. | 指定的参数无效。 |
| 403 | DBClusterNotSupported | The requested operation can not be performed while the cluster is not sale. | 当集群未运行时，无法执行请求的操作。 |
| 403 | IncorrectDBInstanceState | Current DB instance state does not support this operation. | 当前实例状态不支持此操作。 |
| 403 | InstanceEngineType.NotSupport | The instance engine and type does not support operations. | 操作失败，实例引擎和类型不支持该操作。 |
| 403 | InvalidDBInstanceState.NotSupport | The specified instance state does't support this operation. | 指定的实例状态不支持此操作。 |
| 403 | MoneyLessThan100 | The Account Monet less Than 100. | 当前阿里云账号余额不足100，请充值。 |
| 403 | OperationDenied.DBNameAndAccountPrivilegeCount | The operation is not permitted due to count of database or account privilege. | 操作失败，数据库与权限的数量不一致。 |
| 403 | InsufficientResourceCapacity | The resource is out of usage. | 资源不足，请您稍后再试。 |
| 403 | IncorrectMinorVersion | Current engine minor version does not support operations. | 当前内核小版本不支持此操作。 |
| 403 | IncorrectEngineVersion | Current engine version does not support operations. | 当前版本不支持此操作。 |
| 404 | DBInstanceLocked | The current instance lock mode does not support this operation. | 操作失败，当前实例已锁定。 |
| 404 | IncorrectVswitchId | The specified parameter VSwitchId is not valid. | 交换机参数无效。 |
| 404 | InvalidApi.NotFound | Specified api is not found, please check your url and method. | |
| 404 | InvalidDBInstance.NotFound | The specified instance is not found. | 没有找到指定的实例，请检查实例的正确性。 |
| 404 | InvalidDBInstanceClass.NotFound | The specified instance classic does not exist. | 当前选择的配置或规格不存在或已停售，请重新选择。 |
| 404 | InvalidRegionId.NotFound | The provided RegionId does not exist in our records. | 操作失败，输入的地域及可用区不存在。 |
| 404 | QueryPrice.Failed | The inquiry failed. Contact Alibaba Cloud customer service representatives. | 询价失败，请联系客服同学。 |
| 404 | InvalidDBInstanceId.NotFound | The DBInstanceId provided does not exist in our records. | SelectDB实例不存在。 |
访问错误中心查看更多错误码。
变更历史
更多信息，参考变更详情。