MariaDB [tpch]> source Q4-json.sql
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ANALYZE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {
  "query_optimization": {
    "r_total_time_ms": 0.433752645
  },
  "query_block": {
    "select_id": 1,
    "cost": 1305.081566,
    "r_loops": 1,
    "r_total_time_ms": 3673.056008,
    "filesort": {
      "sort_key": "ORDERS.O_ORDERPRIORITY",
      "r_loops": 1,
      "r_total_time_ms": 0.015875153,
      "r_used_priority_queue": false,
      "r_output_rows": 5,
      "r_buffer_size": "480",
      "r_sort_mode": "sort_key,rowid",
      "temporary_table": {
        "nested_loop": [
          {
            "table": {
              "table_name": "ORDERS",
              "access_type": "ALL",
              "possible_keys": ["PRIMARY"],
              "loops": 1,
              "r_loops": 1,
              "rows": 1492042,
              "r_rows": 1500000,
              "cost": 243.2235002,
              "r_table_time_ms": 112.7983491,
              "r_other_time_ms": 97.52923966,
              "r_engine_stats": {
                "pages_accessed": 12415
              },
              "filtered": 100,
              "r_total_filtered": 3.771933333,
              "attached_condition": "ORDERS.O_ORDERDATE >= DATE'1995-01-01' and ORDERS.O_ORDERDATE < '1995-04-01'",
              "r_filtered": 3.771933333
            }
          },
          {
            "table": {
              "table_name": "<subquery2>",
              "access_type": "eq_ref",
              "possible_keys": ["distinct_key"],
              "key": "distinct_key",
              "key_length": "8",
              "used_key_parts": ["l_orderkey"],
              "ref": ["func"],
              "r_loops": 56579,
              "r_table_loops": 1596822,
              "rows": 1,
              "r_rows": 0.916559147,
              "r_table_time_ms": 176.2706392,
              "r_other_time_ms": 91.13430149,
              "filtered": 100,
              "r_total_filtered": 100,
              "r_filtered": 100,
              "materialized": {
                "unique": 1,
                "query_block": {
                  "select_id": 2,
                  "nested_loop": [
                    {
                      "table": {
                        "table_name": "LINEITEM",
                        "access_type": "ALL",
                        "possible_keys": ["PRIMARY", "IDX_LINEITEM_ORDERKEY_FKIDX"],
                        "loops": 1,
                        "r_loops": 1,
                        "rows": 5698532,
                        "r_rows": 6000281,
                        "cost": 928.915193,
                        "r_table_time_ms": 656.1866918,
                        "r_other_time_ms": 2539.090429,
                        "r_engine_stats": {
                          "pages_accessed": 52829
                        },
                        "filtered": 100,
                        "r_total_filtered": 63.195657,
                        "attached_condition": "LINEITEM.L_COMMITDATE < LINEITEM.L_RECEIPTDATE",
                        "r_filtered": 63.195657
                      }
                    }
                  ]
                }
              }
            }
          }
        ]
      }
    }
  }
} |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (3.675 sec)

MariaDB [tpch]> notee