Domain name for API request: cynosdb.intl.tencentcloudapi.com.
This API is used to query the execution plan details.
A maximum of 20 requests can be initiated per second for this API.
The following request parameter list only provides API request parameters and some common parameters. For the complete common parameter list, see Common Request Parameters.
| Parameter Name | Required | Type | Description |
|---|---|---|---|
| Action | Yes | String | Common Params. The value used for this API: DescribeSQLExecutionPlan. |
| Version | Yes | String | Common Params. The value used for this API: 2019-01-07. |
| Region | Yes | String | Common Params. For more information, please see the list of regions supported by the product. This API only supports: 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 | Yes | String | Cluster ID. |
| InstanceId | Yes | String | Instance ID. |
| TemplateID | Yes | String | SQL Template ID |
| PlanDetailId | Yes | Integer | Plan details serial number |
| Parameter Name | Type | Description |
|---|---|---|
| PlanDetail | ExecutionPlanDetail | Execution plan details Note: This field may return null, indicating that no valid values can be obtained. |
| RequestId | String | The unique request ID, generated by the server, will be returned for every request (if the request fails to reach the server for other reasons, the request will not obtain a RequestId). RequestId is required for locating a problem. |
POST / HTTP/1.1
Host: cynosdb.intl.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: DescribeSQLExecutionPlan
<Common request parameters>
{
"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"
}
}
TencentCloud API 3.0 integrates SDKs that support various programming languages to make it easier for you to call APIs.
The following only lists the error codes related to the API business logic. For other error codes, see Common Error Codes.
| Error Code | Description |
|---|---|
| FailedOperation.OperationFailedError | Operation failed. Try again later. If the problem persists, contact customer service. |
| InvalidParameterValue.InstanceNotFound | The instance does not exist. |
| InvalidParameterValue.InvalidParameterValueError | Invalid parameter value. |
| OperationDenied.ClusterOpNotAllowedError | The current cluster does not allow the operation. |
| ResourceNotFound.InstanceNotFoundError | The instance does not exist. |
| ResourceNotFound.ResourceError | The resource corresponding to the parameter does not exist. |
| ResourceUnavailable.InstanceStatusAbnormal | The instance is exceptional, so the operation cannot be performed temporarily. |
| UnauthorizedOperation.PermissionDenied | CAM authentication failed. |
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback