MariaDB [tpch]> source Q4-json.sql
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ANALYZE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {
  "query_optimization": {
    "r_total_time_ms": 0.336535
  },
  "query_block": {
    "select_id": 1,
    "cost": 422.9980574,
    "r_loops": 1,
    "r_total_time_ms": 443.0360048,
    "filesort": {
      "sort_key": "ORDERS.O_ORDERPRIORITY",
      "r_loops": 1,
      "r_total_time_ms": 0.020040648,
      "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": 1500000,
              "r_rows": 1500000,
              "cost": 255.1642272,
              "r_table_time_ms": 194.1256557,
              "r_other_time_ms": 102.2312021,
              "r_engine_stats": {
                "pages_accessed": 12415
              },
              "filtered": 3.907134533,
              "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": "LINEITEM",
              "access_type": "ref",
              "possible_keys": ["PRIMARY", "IDX_LINEITEM_ORDERKEY_FKIDX"],
              "key": "PRIMARY",
              "key_length": "8",
              "used_key_parts": ["L_ORDERKEY"],
              "ref": ["tpch.ORDERS.O_ORDERKEY"],
              "loops": 58607.01783,
              "r_loops": 56579,
              "rows": 4,
              "r_rows": 1.461832129,
              "cost": 128.5483956,
              "r_table_time_ms": 130.517891,
              "r_other_time_ms": 16.10379116,
              "r_engine_stats": {
                "pages_accessed": 172197
              },
              "filtered": 24.99875069,
              "r_total_filtered": 62.69934348,
              "attached_condition": "LINEITEM.L_COMMITDATE < LINEITEM.L_RECEIPTDATE",
              "r_filtered": 62.69934348,
              "first_match": "ORDERS"
            }
          }
        ]
      }
    }
  }
} |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.443 sec)

MariaDB [tpch]> notee