1. 接口描述
接口请求域名： cynosdb.tencentcloudapi.com 。
本接口(DescribeSQLExecutionPlan)用于查询执行计划详情
默认接口请求频率限制：20次/秒。
推荐使用 API Explorer
点击调试
API Explorer 提供了在线调用、签名验证、SDK 代码生成和快速检索接口等能力。您可查看每次调用的请求内容和返回结果以及自动生成 SDK 调用示例。
2. 输入参数
以下请求参数列表仅列出了接口请求参数和部分公共参数，完整公共参数列表见 公共请求参数。
| 参数名称 | 必选 | 类型 | 描述 |
|---|---|---|---|
| Action | 是 | String | 公共参数，本接口取值：DescribeSQLExecutionPlan。 |
| Version | 是 | String | 公共参数，本接口取值：2019-01-07。 |
| Region | 是 | String | 公共参数，详见产品支持的 地域列表，本接口仅支持其中的: ap-bangkok, ap-beijing, ap-chengdu, ap-chongqing, ap-guangzhou, ap-hongkong, ap-jakarta, ap-nanjing, ap-seoul, ap-shanghai, ap-shenzhen-fsi, ap-singapore, ap-tokyo, eu-frankfurt, na-ashburn, na-siliconvalley, sa-saopaulo 。 |
| ClusterId | 是 | String | 集群ID 示例值：cynosdbmysql-8tumaajt |
| InstanceId | 是 | String | 实例ID 示例值：cynosdbmysql-ins-2qzix1mk |
| TemplateID | 是 | String | SQL模板ID 示例值：tpch1g:a9b833b766a7a28a56c04115e79abf04bb7d5cb0f0486bb0fc4b6a8eae250d48 |
| PlanDetailId | 是 | Integer | 计划详情序列号 示例值：25180 |
3. 输出参数
| 参数名称 | 类型 | 描述 |
|---|---|---|
| PlanDetail | ExecutionPlanDetail | 执行计划详情 注意：此字段可能返回 null，表示取不到有效值。 |
| RequestId | String | 唯一请求 ID，由服务端生成，每次请求都会返回（若请求因其他原因未能抵达服务端，则该次请求不会获得 RequestId）。定位问题时需要提供该次请求的 RequestId。 |
4. 示例
示例1 查询执行计划
输入示例
POST / HTTP/1.1
Host: cynosdb.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: DescribeSQLExecutionPlan
<公共请求参数>
{
"ClusterId": "cynosdbmysql-8tumaajt",
"InstanceId": "cynosdbmysql-ins-2qzix1mk",
"TemplateID": "tpch1g:a9b833b766a7a28a56c04115e79abf04bb7d5cb0f0486bb0fc4b6a8eae250d48",
"PlanDetailId": 25180
}输出示例
{
"Response": {
"PlanDetail": {
"Db": "tpch1g",
"QueryTimeAfter": 7.9771255,
"QueryTimeBefore": 42.2461075,
"SQLSample": "select\n s_name,\n count(*) as numwait\nfrom\n supplier,\n lineitem l1,\n orders,\n nation\nwhere\n s_suppkey = l1.l_suppkey\n and o_orderkey = l1.l_orderkey\n and o_orderstatus = 'F'\n and l1.l_receiptdate > l1.l_commitdate\n and exists \n (\n select\n *\n from\n lineitem l2\n where\n l2.l_orderkey = l1.l_orderkey\n and l2.l_suppkey <> l1.l_suppkey\n )\n and not exists \n (\n select\n *\n from\n lineitem l3\n where\n l3.l_orderkey = l1.l_orderkey\n and l3.l_suppkey <> l1.l_suppkey\n and l3.l_receiptdate > l3.l_commitdate\n )\n and s_nationkey = n_nationkey\n and n_name = 'VIETNAM'\ngroup by\n s_name\norder by\n numwait desc,\n s_name",
"SQLSampleRewritten": "select /*+ BEGIN_OUTLINE_DATA LEADING(@`select$1` (((((`nation` 3, `supplier` 0), `l1` 1), `orders` 2), `l2` 4), `l3` 5)) BNL(`supplier`@`select$1`) REF_SCAN(`supplier`@`select$1` `i_s_nationkey`) NESTED_LOOP_JOIN(`supplier`@`select$1`) BNL(`l1`@`select$1`) HASH_JOIN(`l1`@`select$1`) NO_INDEX(`l1`@`select$1`) BNL(`orders`@`select$1`) REF_SCAN(`orders`@`select$1` `PRIMARY`) NESTED_LOOP_JOIN(`orders`@`select$1`) NO_INDEX(`nation`@`select$1`) SEMIJOIN(@`select$2` FIRSTMATCH) BNL(`l2`@`select$2`) REF_SCAN(`l2`@`select$2` `PRIMARY`) NESTED_LOOP_JOIN(`l2`@`select$2`) SEMIJOIN(@`select$3` FIRSTMATCH) BNL(`l3`@`select$3`) REF_SCAN(`l3`@`select$3` `PRIMARY`) NESTED_LOOP_JOIN(`l3`@`select$3`) SET_VAR(optimizer_switch=8336409648) END_OUTLINE_DATA */\n s_name,\n count(*) as numwait\nfrom\n supplier,\n lineitem l1,\n orders,\n nation\nwhere\n s_suppkey = l1.l_suppkey\n and o_orderkey = l1.l_orderkey\n and o_orderstatus = 'F'\n and l1.l_receiptdate > l1.l_commitdate\n and exists \n (\n select\n *\n from\n lineitem l2\n where\n l2.l_orderkey = l1.l_orderkey\n and l2.l_suppkey <> l1.l_suppkey\n )\n and not exists \n (\n select\n *\n from\n lineitem l3\n where\n l3.l_orderkey = l1.l_orderkey\n and l3.l_suppkey <> l1.l_suppkey\n and l3.l_receiptdate > l3.l_commitdate\n )\n and s_nationkey = n_nationkey\n and n_name = 'VIETNAM'\ngroup by\n s_name\norder by\n numwait desc,\n s_name",
"SQLScanRowsAfter": 6370410,
"SQLScanRowsBefore": 6448214,
"TablePlanAfter": [
{
"Extra": "Using where; Using temporary; Using filesort",
"Filtered": 10,
"Id": 1,
"Key": "",
"KeyLen": "",
"Partitions": "",
"PossibleKeys": "",
"Ref": "",
"Rows": 25,
"SelectType": "SIMPLE",
"Table": "nation",
"Type": "ALL"
}
],
"TablePlanBefore": [
{
"Extra": "Using where; Using temporary; Using filesort",
"Filtered": 10,
"Id": 1,
"Key": "",
"KeyLen": "",
"Partitions": "",
"PossibleKeys": "PRIMARY",
"Ref": "",
"Rows": 1503916,
"SelectType": "SIMPLE",
"Table": "orders",
"Type": "ALL"
}
],
"TemplateID": "tpch1g:a9b833b766a7a28a56c04115e79abf04bb7d5cb0f0486bb0fc4b6a8eae250d48",
"TreePlanAfter": "{\n \"query\": \"/* select#1 */ select /*+ SET_VAR(optimizer_switch=8336409648) LEADING(@`select#1` (((((`nation` 3, `supplier` 0), `l1` 1), `orders` 2), `l2` 4), `l3` 5)) BNL(`supplier`@`select#1`) REF_SCAN(`supplier`@`select#1` `i_s_nationkey`) NESTED_LOOP_JOIN(`supplier`@`select#1`) BNL(`l1`@`select#1`) HASH_JOIN(`l1`@`select#1`) NO_INDEX(`l1`@`select#1`) BNL(`orders`@`select#1`) REF_SCAN(`orders`@`select#1` `PRIMARY`) NESTED_LOOP_JOIN(`orders`@`select#1`) NO_INDEX(`nation`@`select#1`) SEMIJOIN(@`select#2` FIRSTMATCH) BNL(`l2`@`select#2`) REF_SCAN(`l2`@`select#2` `PRIMARY`) NESTED_LOOP_JOIN(`l2`@`select#2`) SEMIJOIN(@`select#3` FIRSTMATCH) BNL(`l3`@`select#3`) REF_SCAN(`l3`@`select#3` `PRIMARY`) NESTED_LOOP_JOIN(`l3`@`select#3`) */ `tpch1g`.`supplier`.`s_name` AS `s_name`,count(0) AS `numwait` from `tpch1g`.`supplier` join `tpch1g`.`lineitem` `l1` join `tpch1g`.`orders` join `tpch1g`.`nation` semi join (`tpch1g`.`lineitem` `l2`) anti join (`tpch1g`.`lineitem` `l3`) on(((`l3`.`l_orderkey` = `l1`.`l_orderkey`) and (`l3`.`l_suppkey` <> `tpch1g`.`supplier`.`s_suppkey`) and (`l3`.`l_receiptdate` > `l3`.`l_commitdate`))) where ((`tpch1g`.`supplier`.`s_nationkey` = `tpch1g`.`nation`.`n_nationkey`) and (`tpch1g`.`orders`.`o_orderkey` = `l1`.`l_orderkey`) and (`l2`.`l_orderkey` = `l1`.`l_orderkey`) and (`l1`.`l_suppkey` = `tpch1g`.`supplier`.`s_suppkey`) and (`tpch1g`.`orders`.`o_orderstatus` = 'F') and (`l1`.`l_receiptdate` > `l1`.`l_commitdate`) and (`tpch1g`.`nation`.`n_name` = 'VIETNAM') and (`l2`.`l_suppkey` <> `tpch1g`.`supplier`.`s_suppkey`)) group by `tpch1g`.`supplier`.`s_name` order by `numwait` desc,`tpch1g`.`supplier`.`s_name`\",\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"operation\": \"Table scan on l1\",\n \"table_name\": \"l1\",\n \"access_type\": \"table\",\n \"actual_rows\": 6001215.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 5725745.0,\n \"actual_last_row_ms\": 5496.675893,\n \"actual_first_row_ms\": 2.091768,\n \"estimated_total_cost\": 980.0111026275647\n }\n ],\n \"condition\": \"(l1.l_receiptdate > l1.l_commitdate)\",\n \"operation\": \"Filter: (l1.l_receiptdate > l1.l_commitdate)\",\n \"access_type\": \"filter\",\n \"actual_rows\": 3793296.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 197.69924468766476,\n \"actual_last_row_ms\": 5854.604804,\n \"actual_first_row_ms\": 2.093088,\n \"estimated_total_cost\": 980.0111026275647\n },\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"operation\": \"Table scan on nation\",\n \"table_name\": \"nation\",\n \"access_type\": \"table\",\n \"actual_rows\": 25.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 25.0,\n \"actual_last_row_ms\": 1.162188,\n \"actual_first_row_ms\": 1.158898,\n \"estimated_total_cost\": 3.5\n }\n ],\n \"condition\": \"(nation.n_name = 'VIETNAM')\",\n \"operation\": \"Filter: (nation.n_name = 'VIETNAM')\",\n \"access_type\": \"filter\",\n \"actual_rows\": 1.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 2.500000037252903,\n \"actual_last_row_ms\": 1.165758,\n \"actual_first_row_ms\": 1.1635280000000001,\n \"estimated_total_cost\": 3.5\n },\n {\n \"covering\": false,\n \"operation\": \"Index lookup on supplier using i_s_nationkey (s_nationkey=nation.n_nationkey)\",\n \"index_name\": \"i_s_nationkey\",\n \"table_name\": \"supplier\",\n \"access_type\": \"index\",\n \"actual_rows\": 399.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 396.3599853515625,\n \"lookup_condition\": \"s_nationkey=nation.n_nationkey\",\n \"index_access_type\": \"index_lookup\",\n \"actual_last_row_ms\": 2.954752,\n \"actual_first_row_ms\": 2.1702179999999998,\n \"estimated_total_cost\": 127.64824120004909\n }\n ],\n \"heading\": \"Hash\",\n \"join_type\": \"inner join\",\n \"operation\": \"Nested loop inner join\",\n \"access_type\": \"join\",\n \"actual_rows\": 399.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 990.8999781444663,\n \"join_algorithm\": \"nested_loop\",\n \"actual_last_row_ms\": 4.141059,\n \"actual_first_row_ms\": 3.3348459999999998,\n \"estimated_total_cost\": 382.07460703468064\n }\n ],\n \"join_type\": \"inner join\",\n \"operation\": \"Inner hash join (l1.l_suppkey = supplier.s_suppkey)\",\n \"access_type\": \"join\",\n \"actual_rows\": 151237.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 6.764065999195586,\n \"hash_condition\": [\n \"(l1.l_suppkey = supplier.s_suppkey)\"\n ],\n \"join_algorithm\": \"hash\",\n \"actual_last_row_ms\": 6074.518301,\n \"actual_first_row_ms\": 6.335513,\n \"estimated_total_cost\": 991045.334534254\n },\n {\n \"inputs\": [\n {\n \"covering\": false,\n \"operation\": \"Single-row index lookup on orders using PRIMARY (o_orderkey=l1.l_orderkey)\",\n \"index_name\": \"PRIMARY\",\n \"table_name\": \"orders\",\n \"access_type\": \"index\",\n \"actual_rows\": 1.0,\n \"actual_loops\": 151237,\n \"estimated_rows\": 1.0,\n \"lookup_condition\": \"o_orderkey=l1.l_orderkey\",\n \"index_access_type\": \"index_lookup\",\n \"actual_last_row_ms\": 0.009225258422211495,\n \"actual_first_row_ms\": 0.009201951050338211,\n \"estimated_total_cost\": 0.00048093393503419093\n }\n ],\n \"condition\": \"(orders.o_orderstatus = 'F')\",\n \"operation\": \"Filter: (orders.o_orderstatus = 'F')\",\n \"access_type\": \"filter\",\n \"actual_rows\": 0.4834200625508308,\n \"actual_loops\": 151237,\n \"estimated_rows\": 0.10000000149011612,\n \"actual_last_row_ms\": 0.009417779690155188,\n \"actual_first_row_ms\": 0.009382624820645743,\n \"estimated_total_cost\": 0.00048093393503419093\n }\n ],\n \"join_type\": \"inner join\",\n \"operation\": \"Nested loop inner join\",\n \"access_type\": \"join\",\n \"actual_rows\": 73111.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 0.6764066099988024,\n \"join_algorithm\": \"nested_loop\",\n \"actual_last_row_ms\": 7516.577456,\n \"actual_first_row_ms\": 7.517811,\n \"estimated_total_cost\": 991140.2159870679\n },\n {\n \"inputs\": [\n {\n \"covering\": false,\n \"operation\": \"Index lookup on l2 using PRIMARY (l_orderkey=l1.l_orderkey)\",\n \"index_name\": \"PRIMARY\",\n \"table_name\": \"l2\",\n \"access_type\": \"index\",\n \"actual_rows\": 1.2135519962796295,\n \"actual_loops\": 73111,\n \"estimated_rows\": 3.8266098499298096,\n \"lookup_condition\": \"l_orderkey=l1.l_orderkey\",\n \"index_access_type\": \"index_lookup\",\n \"actual_last_row_ms\": 0.002929321196536773,\n \"actual_first_row_ms\": 0.0028866301787692688,\n \"estimated_total_cost\": 2.7405877787157538\n }\n ],\n \"condition\": \"(l2.l_suppkey <> supplier.s_suppkey)\",\n \"operation\": \"Filter: (l2.l_suppkey <> supplier.s_suppkey)\",\n \"access_type\": \"filter\",\n \"actual_rows\": 0.9638221334682879,\n \"actual_loops\": 73111,\n \"estimated_rows\": 3.4439487737033403,\n \"actual_last_row_ms\": 0.003099465470312265,\n \"actual_first_row_ms\": 0.003099465470312265,\n \"estimated_total_cost\": 2.7405877787157538\n }\n ],\n \"join_type\": \"semijoin\",\n \"operation\": \"Nested loop semijoin\",\n \"access_type\": \"join\",\n \"actual_rows\": 70466.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 2.3295097150302095,\n \"join_algorithm\": \"nested_loop\",\n \"actual_last_row_ms\": 7752.051947,\n \"actual_first_row_ms\": 7.523631,\n \"estimated_total_cost\": 1006729.260594798\n },\n {\n \"inputs\": [\n {\n \"covering\": false,\n \"operation\": \"Index lookup on l3 using PRIMARY (l_orderkey=l1.l_orderkey)\",\n \"index_name\": \"PRIMARY\",\n \"table_name\": \"l3\",\n \"access_type\": \"index\",\n \"actual_rows\": 1.8223114693611102,\n \"actual_loops\": 70466,\n \"estimated_rows\": 3.8266098499298096,\n \"lookup_condition\": \"l_orderkey=l1.l_orderkey\",\n \"index_access_type\": \"index_lookup\",\n \"actual_last_row_ms\": 0.002739451792353759,\n \"actual_first_row_ms\": 0.0026278000596032134,\n \"estimated_total_cost\": 3.0451050872714744\n }\n ],\n \"condition\": \"((l3.l_suppkey <> supplier.s_suppkey) and (l3.l_receiptdate > l3.l_commitdate))\",\n \"operation\": \"Filter: ((l3.l_suppkey <> supplier.s_suppkey) and (l3.l_receiptdate > l3.l_commitdate))\",\n \"access_type\": \"filter\",\n \"actual_rows\": 0.9446399682116198,\n \"actual_loops\": 70466,\n \"estimated_rows\": 3.8266098499298096,\n \"actual_last_row_ms\": 0.0030080967274997874,\n \"actual_first_row_ms\": 0.0030080967274997874,\n \"estimated_total_cost\": 3.0451050872714744\n }\n ],\n \"join_type\": \"antijoin\",\n \"operation\": \"Nested loop antijoin\",\n \"access_type\": \"join\",\n \"actual_rows\": 3901.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 8.914124821041783,\n \"join_algorithm\": \"nested_loop\",\n \"actual_last_row_ms\": 7971.408892,\n \"actual_first_row_ms\": 10.174192999999999,\n \"estimated_total_cost\": 1022318.9377805906\n }\n ],\n \"operation\": \"Aggregate using temporary table\",\n \"access_type\": \"temp_table_aggregate\",\n \"actual_rows\": 399.0,\n \"actual_loops\": 1,\n \"actual_last_row_ms\": 7975.965818,\n \"actual_first_row_ms\": 7975.965818\n }\n ],\n \"operation\": \"Table scan on <temporary>\",\n \"table_name\": \"<temporary>\",\n \"access_type\": \"table\",\n \"actual_rows\": 399.0,\n \"actual_loops\": 1,\n \"actual_last_row_ms\": 7975.999928,\n \"actual_first_row_ms\": 7975.967638\n }\n ],\n \"operation\": \"Sort: numwait DESC, supplier.s_name\",\n \"access_type\": \"sort\",\n \"actual_rows\": 399.0,\n \"sort_fields\": [\n \"numwait DESC\",\n \"supplier.s_name\"\n ],\n \"actual_loops\": 1,\n \"outline_data\": \"/*+ BEGIN_OUTLINE_DATA LEADING(@`select$1` (((((`nation` 3, `supplier` 0), `l1` 1), `orders` 2), `l2` 4), `l3` 5)) BNL(`supplier`@`select$1`) REF_SCAN(`supplier`@`select$1` `i_s_nationkey`) NESTED_LOOP_JOIN(`supplier`@`select$1`) BNL(`l1`@`select$1`) HASH_JOIN(`l1`@`select$1`) NO_INDEX(`l1`@`select$1`) BNL(`orders`@`select$1`) REF_SCAN(`orders`@`select$1` `PRIMARY`) NESTED_LOOP_JOIN(`orders`@`select$1`) NO_INDEX(`nation`@`select$1`) SEMIJOIN(@`select$2` FIRSTMATCH) BNL(`l2`@`select$2`) REF_SCAN(`l2`@`select$2` `PRIMARY`) NESTED_LOOP_JOIN(`l2`@`select$2`) SEMIJOIN(@`select$3` FIRSTMATCH) BNL(`l3`@`select$3`) REF_SCAN(`l3`@`select$3` `PRIMARY`) NESTED_LOOP_JOIN(`l3`@`select$3`) SET_VAR(optimizer_switch=8336409648) END_OUTLINE_DATA */\",\n \"query_digest\": \"fa1b09d3f61e2a023e0fc5267ff1bcdb642f54f3d1c0746e4bca763d7394ac74\",\n \"query_plan_id\": \"0x008498a4dc40c72239\",\n \"rows_examined\": 6370410,\n \"actual_last_row_ms\": 7976.171226,\n \"actual_first_row_ms\": 7976.158716\n}",
"TreePlanBefore": "{\n \"query\": \"/* select#1 */ select `tpch1g`.`supplier`.`s_name` AS `s_name`,count(0) AS `numwait` from `tpch1g`.`supplier` join `tpch1g`.`lineitem` `l1` join `tpch1g`.`orders` join `tpch1g`.`nation` semi join (`tpch1g`.`lineitem` `l2`) anti join (`tpch1g`.`lineitem` `l3`) on(((`l3`.`l_orderkey` = `tpch1g`.`orders`.`o_orderkey`) and (`l3`.`l_suppkey` <> `l1`.`l_suppkey`) and (`l3`.`l_receiptdate` > `l3`.`l_commitdate`))) where ((`tpch1g`.`supplier`.`s_nationkey` = `tpch1g`.`nation`.`n_nationkey`) and (`l1`.`l_orderkey` = `tpch1g`.`orders`.`o_orderkey`) and (`l2`.`l_orderkey` = `tpch1g`.`orders`.`o_orderkey`) and (`tpch1g`.`supplier`.`s_suppkey` = `l1`.`l_suppkey`) and (`tpch1g`.`orders`.`o_orderstatus` = 'F') and (`l1`.`l_receiptdate` > `l1`.`l_commitdate`) and (`tpch1g`.`nation`.`n_name` = 'VIETNAM') and (`l2`.`l_suppkey` <> `l1`.`l_suppkey`)) group by `tpch1g`.`supplier`.`s_name` order by `numwait` desc,`tpch1g`.`supplier`.`s_name`\",\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"operation\": \"Table scan on nation\",\n \"table_name\": \"nation\",\n \"access_type\": \"table\",\n \"actual_rows\": 25.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 25.0,\n \"actual_last_row_ms\": 1.00976,\n \"actual_first_row_ms\": 1.00391,\n \"estimated_total_cost\": 0.0005514502712131666\n }\n ],\n \"condition\": \"(nation.n_name = 'VIETNAM')\",\n \"operation\": \"Filter: (nation.n_name = 'VIETNAM')\",\n \"access_type\": \"filter\",\n \"actual_rows\": 1.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 2.500000037252903,\n \"actual_last_row_ms\": 1.01434,\n \"actual_first_row_ms\": 1.00784,\n \"estimated_total_cost\": 0.0005514502712131666\n },\n {\n \"inputs\": [\n {\n \"inputs\": [\n {\n \"operation\": \"Table scan on orders\",\n \"table_name\": \"orders\",\n \"access_type\": \"table\",\n \"actual_rows\": 1500000.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 1503916.0,\n \"actual_last_row_ms\": 300.096449,\n \"actual_first_row_ms\": 2.2044170000000003,\n \"estimated_total_cost\": 157490.99360041623\n }\n ],\n \"condition\": \"(orders.o_orderstatus = 'F')\",\n \"operation\": \"Filter: (orders.o_orderstatus = 'F')\",\n \"access_type\": \"filter\",\n \"actual_rows\": 729413.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 150391.60224100947,\n \"actual_last_row_ms\": 408.53486,\n \"actual_first_row_ms\": 2.207327,\n \"estimated_total_cost\": 157490.99360041623\n },\n {\n \"inputs\": [\n {\n \"covering\": false,\n \"operation\": \"Index lookup on l1 using PRIMARY (l_orderkey=orders.o_orderkey)\",\n \"index_name\": \"PRIMARY\",\n \"table_name\": \"l1\",\n \"access_type\": \"index\",\n \"actual_rows\": 3.9781906820964257,\n \"actual_loops\": 729413,\n \"estimated_rows\": 3.8266098499298096,\n \"lookup_condition\": \"l_orderkey=orders.o_orderkey\",\n \"index_access_type\": \"index_lookup\",\n \"actual_last_row_ms\": 0.010278997290972331,\n \"actual_first_row_ms\": 0.008581368660827269,\n \"estimated_total_cost\": 0.8182804634942625\n }\n ],\n \"condition\": \"(l1.l_receiptdate > l1.l_commitdate)\",\n \"operation\": \"Filter: (l1.l_receiptdate > l1.l_commitdate)\",\n \"access_type\": \"filter\",\n \"actual_rows\": 2.5073737375122187,\n \"actual_loops\": 729413,\n \"estimated_rows\": 1.2754090418154362,\n \"actual_last_row_ms\": 0.010639340963212885,\n \"actual_first_row_ms\": 0.008829539742231081,\n \"estimated_total_cost\": 0.8182804634942625\n }\n ],\n \"heading\": \"Hash\",\n \"join_type\": \"inner join\",\n \"operation\": \"Nested loop inner join\",\n \"access_type\": \"join\",\n \"actual_rows\": 1828911.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 191810.8093112941,\n \"join_algorithm\": \"nested_loop\",\n \"actual_last_row_ms\": 8317.914674000001,\n \"actual_first_row_ms\": 3.341915,\n \"estimated_total_cost\": 338102.3746951474\n }\n ],\n \"join_type\": \"inner join\",\n \"operation\": \"Inner hash join (no condition)\",\n \"access_type\": \"join\",\n \"actual_rows\": 1828911.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 47952.70375692543,\n \"hash_condition\": [],\n \"join_algorithm\": \"hash\",\n \"actual_last_row_ms\": 8814.606188999998,\n \"actual_first_row_ms\": 8493.958550000001,\n \"estimated_total_cost\": 386160.60186033446\n },\n {\n \"inputs\": [\n {\n \"covering\": false,\n \"operation\": \"Single-row index lookup on supplier using PRIMARY (s_suppkey=l1.l_suppkey)\",\n \"index_name\": \"PRIMARY\",\n \"table_name\": \"supplier\",\n \"access_type\": \"index\",\n \"actual_rows\": 1.0,\n \"actual_loops\": 1828911,\n \"estimated_rows\": 1.0,\n \"lookup_condition\": \"s_suppkey=l1.l_suppkey\",\n \"index_access_type\": \"index_lookup\",\n \"actual_last_row_ms\": 0.001363853301773569,\n \"actual_first_row_ms\": 0.0013405737015087119,\n \"estimated_total_cost\": 0.10000000893682495\n }\n ],\n \"condition\": \"(supplier.s_nationkey = nation.n_nationkey)\",\n \"operation\": \"Filter: (supplier.s_nationkey = nation.n_nationkey)\",\n \"access_type\": \"filter\",\n \"actual_rows\": 0.039975154613865846,\n \"actual_loops\": 1828911,\n \"estimated_rows\": 0.05000000074505806,\n \"actual_last_row_ms\": 0.0015036497008329,\n \"actual_first_row_ms\": 0.0015005575798931715,\n \"estimated_total_cost\": 0.10000000893682495\n }\n ],\n \"join_type\": \"inner join\",\n \"operation\": \"Nested loop inner join\",\n \"access_type\": \"join\",\n \"actual_rows\": 73111.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 2397.63522357382,\n \"join_algorithm\": \"nested_loop\",\n \"actual_last_row_ms\": 11709.404138,\n \"actual_first_row_ms\": 8493.97589,\n \"estimated_total_cost\": 438908.57456385053\n },\n {\n \"inputs\": [\n {\n \"covering\": false,\n \"operation\": \"Index lookup on l2 using PRIMARY (l_orderkey=orders.o_orderkey)\",\n \"index_name\": \"PRIMARY\",\n \"table_name\": \"l2\",\n \"access_type\": \"index\",\n \"actual_rows\": 1.2135519962796295,\n \"actual_loops\": 73111,\n \"estimated_rows\": 3.8266098499298096,\n \"lookup_condition\": \"l_orderkey=orders.o_orderkey\",\n \"index_access_type\": \"index_lookup\",\n \"actual_last_row_ms\": 0.41380506700770064,\n \"actual_first_row_ms\": 0.4137379223235902,\n \"estimated_total_cost\": 2.8181625467990035\n }\n ],\n \"condition\": \"(l2.l_suppkey <> l1.l_suppkey)\",\n \"operation\": \"Filter: (l2.l_suppkey <> l1.l_suppkey)\",\n \"access_type\": \"filter\",\n \"actual_rows\": 0.9638221334682879,\n \"actual_loops\": 73111,\n \"estimated_rows\": 3.4439487737033403,\n \"actual_last_row_ms\": 0.41401645489734784,\n \"actual_first_row_ms\": 0.41401645489734784,\n \"estimated_total_cost\": 2.8181625467990035\n }\n ],\n \"join_type\": \"semijoin\",\n \"operation\": \"Nested loop semijoin\",\n \"access_type\": \"join\",\n \"actual_rows\": 70466.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 8257.332888014991,\n \"join_algorithm\": \"nested_loop\",\n \"actual_last_row_ms\": 41988.167672999996,\n \"actual_first_row_ms\": 8494.003059,\n \"estimated_total_cost\": 459445.41601481376\n },\n {\n \"inputs\": [\n {\n \"covering\": false,\n \"operation\": \"Index lookup on l3 using PRIMARY (l_orderkey=orders.o_orderkey)\",\n \"index_name\": \"PRIMARY\",\n \"table_name\": \"l3\",\n \"access_type\": \"index\",\n \"actual_rows\": 1.8223114693611102,\n \"actual_loops\": 70466,\n \"estimated_rows\": 3.8266098499298096,\n \"lookup_condition\": \"l_orderkey=orders.o_orderkey\",\n \"index_access_type\": \"index_lookup\",\n \"actual_last_row_ms\": 0.003049482800215707,\n \"actual_first_row_ms\": 0.0028714652456503843,\n \"estimated_total_cost\": 3.131297908861849\n }\n ],\n \"condition\": \"((l3.l_suppkey <> l1.l_suppkey) and (l3.l_receiptdate > l3.l_commitdate))\",\n \"operation\": \"Filter: ((l3.l_suppkey <> l1.l_suppkey) and (l3.l_receiptdate > l3.l_commitdate))\",\n \"access_type\": \"filter\",\n \"actual_rows\": 0.9446399682116198,\n \"actual_loops\": 70466,\n \"estimated_rows\": 3.8266098499298096,\n \"actual_last_row_ms\": 0.003349360443334374,\n \"actual_first_row_ms\": 0.003349360443334374,\n \"estimated_total_cost\": 3.131297908861849\n }\n ],\n \"join_type\": \"antijoin\",\n \"operation\": \"Nested loop antijoin\",\n \"access_type\": \"join\",\n \"actual_rows\": 3901.0,\n \"actual_loops\": 1,\n \"estimated_rows\": 31597.591363427528,\n \"join_algorithm\": \"nested_loop\",\n \"actual_last_row_ms\": 42232.703443,\n \"actual_first_row_ms\": 8499.760899,\n \"estimated_total_cost\": 482224.5351458131\n }\n ],\n \"operation\": \"Aggregate using temporary table\",\n \"access_type\": \"temp_table_aggregate\",\n \"actual_rows\": 399.0,\n \"actual_loops\": 1,\n \"actual_last_row_ms\": 42239.891110000004,\n \"actual_first_row_ms\": 42239.891110000004\n }\n ],\n \"operation\": \"Table scan on <temporary>\",\n \"table_name\": \"<temporary>\",\n \"access_type\": \"table\",\n \"actual_rows\": 399.0,\n \"actual_loops\": 1,\n \"actual_last_row_ms\": 42239.925729,\n \"actual_first_row_ms\": 42239.893879999996\n }\n ],\n \"operation\": \"Sort: numwait DESC, supplier.s_name\",\n \"access_type\": \"sort\",\n \"actual_rows\": 399.0,\n \"sort_fields\": [\n \"numwait DESC\",\n \"supplier.s_name\"\n ],\n \"actual_loops\": 1,\n \"outline_data\": \"/*+ BEGIN_OUTLINE_DATA LEADING(@`select$1` (((((`orders` 2, `l1` 1), `nation` 3), `supplier` 0), `l2` 4), `l3` 5)) BNL(`l1`@`select$1`) REF_SCAN(`l1`@`select$1` `PRIMARY`) NESTED_LOOP_JOIN(`l1`@`select$1`) BNL(`nation`@`select$1`) HASH_JOIN(`nation`@`select$1`) NO_INDEX(`nation`@`select$1`) BNL(`supplier`@`select$1`) REF_SCAN(`supplier`@`select$1` `PRIMARY`) NESTED_LOOP_JOIN(`supplier`@`select$1`) NO_INDEX(`orders`@`select$1`) SEMIJOIN(@`select$2` FIRSTMATCH) BNL(`l2`@`select$2`) REF_SCAN(`l2`@`select$2` `PRIMARY`) NESTED_LOOP_JOIN(`l2`@`select$2`) SEMIJOIN(@`select$3` FIRSTMATCH) BNL(`l3`@`select$3`) REF_SCAN(`l3`@`select$3` `PRIMARY`) NESTED_LOOP_JOIN(`l3`@`select$3`) SET_VAR(optimizer_switch=8333557247) END_OUTLINE_DATA */\",\n \"query_digest\": \"a9b833b766a7a28a56c04115e79abf04bb7d5cb0f0486bb0fc4b6a8eae250d48\",\n \"query_plan_id\": \"0x00e5244895dc3aad21\",\n \"rows_examined\": 6448214,\n \"actual_last_row_ms\": 42240.066968,\n \"actual_first_row_ms\": 42240.054388\n}"
},
"RequestId": "39254142-09e5-494c-9112-af3be015e5e1"
}
}5. 开发者资源
腾讯云 API 平台
腾讯云 API 平台 是综合 API 文档、错误码、API Explorer 及 SDK 等资源的统一查询平台，方便您从同一入口查询及使用腾讯云提供的所有 API 服务。
API Inspector
用户可通过 API Inspector 查看控制台每一步操作关联的 API 调用情况，并自动生成各语言版本的 API 代码，也可前往 API Explorer 进行在线调试。
SDK
云 API 3.0 提供了配套的开发工具集（SDK），支持多种编程语言，能更方便的调用 API。
- Tencent Cloud SDK 3.0 for Python: CNB, GitHub, Gitee
- Tencent Cloud SDK 3.0 for Java: CNB, GitHub, Gitee
- Tencent Cloud SDK 3.0 for PHP: CNB, GitHub, Gitee
- Tencent Cloud SDK 3.0 for Go: CNB, GitHub, Gitee
- Tencent Cloud SDK 3.0 for Node.js: CNB, GitHub, Gitee
- Tencent Cloud SDK 3.0 for .NET: CNB, GitHub, Gitee
- Tencent Cloud SDK 3.0 for C++: CNB, GitHub, Gitee
- Tencent Cloud SDK 3.0 for Ruby: CNB, GitHub, Gitee
命令行工具
6. 错误码
以下仅列出了接口业务逻辑相关的错误码，其他错误码详见 公共错误码。
| 错误码 | 描述 |
|---|---|
| FailedOperation.OperationFailedError | 操作失败，请稍后重试。如果持续不成功，请联系客服进行处理。 |
| InvalidParameterValue.InstanceNotFound | 实例不存在。 |
| InvalidParameterValue.InvalidParameterValueError | 参数值无效。 |
| OperationDenied.ClusterOpNotAllowedError | 由于操作禁止，当前集群不允许该操作。 |
| ResourceNotFound.InstanceNotFoundError | 实例不存在。 |
| ResourceNotFound.ResourceError | 参数对应资源不存在。 |
| ResourceUnavailable.InstanceStatusAbnormal | 实例状态异常，暂时不可操作。 |
| UnauthorizedOperation.PermissionDenied | CAM鉴权不通过。 |
