使用EXPLAIN 查看执行计划, 5.6后可以加参数 EXPLAIN FORMAT=JSON xxx输出json格式的信息。 FORMAT=JSON格式的内容可参考8.8.2 EXPLAIN Output Format中的相关部分。 代码语言:javascript 代码运行次数:0 运行 AI代码解释 +---+---+---+---+---+---+ ...
DFESerialize – Serializes a query’s final results into a JSON string serialization, mapping each input solution to the appropriate variable name. For node and edge results, these results are serialized into a map of entity properties and metadata. DFESort – Takes an input relation and produces...
JSON EXPLAIN PIPELINE 设置: header— 为每个输出端口打印标题。默认值:0。 graph—以DOT图描述语言打印图。默认值:0。 compact— 如果启用了graph设置,则以紧凑模式打印图。默认值:1。 Example: EXPLAIN PIPELINE SELECT count(total_rows) FROM system.tables GROUP BY total_rows % 4 SQL Segment[ 2 ] :...
a new JSON EXPLAIN format was introduced, as the old format has no relation to the legacy, the planning process, or the final plan created by the optimizer. Using the Hypergraph optimizer with EXPLAIN FORMAT=JSON willalwaysyield this new JSON format. If you are using the old optimizer and ...
id (JSON name: select_id) SQL查询中的序列号。 select_type (JSON name: none) 查询的类型,可以是下表的任何一种类型: 查询类型例子: 1、SIMPLE 简单查询(不适用union和子查询的) mysql> explain select * from staff; +---+---+---+---+---+---+---+---+---+---+| id |select_type...
JSON: Renders the query plan in JSON format. This option is compatible only with VERBOSE. ANNOTATED: Embeds optimizer hints that encapsulate the query plan for this query. This option is compatible with LOCAL and VERBOSE. sql-statement A query or DML statement—for example, SELECT, INSERT, UPD...
For example, select_type is DELETE for DELETE statements. table (JSON name: table_name) The name of the table to which the row of output refers. This can also be one of the following values: <unionM,N>: The row refers to the union of the rows with id values of M and N. ...
including_query name is so far what i can come up with, if people have better ideas, then we can change. example: explain (analyze,including_query on, format json) select 1; QUERY PLAN --- [ + {"Query": "select 1"}, + { + "Plan":...
For more information about how to use this format, see SQL Plan Management. plan_cache The EXPLAIN statement outputs results in the row format, with the Plan Cache information as a warning. brief DotGraph JSON The following is an example when FORMAT is "brief" in EXPLAIN: EXPLAIN FORMAT =...
JSON Name select_id None table_name partitions access_type possible_keys key key_length ref rows filtered None Meaning The SELECT identifier The SELECT type The table for the output row The matching partitions The join type The possible indexes to choose The index actually chosen The length of ...