{
  "title": "MySQL Explain",
  "type": "object",
  "properties": {
    "query_block": {
      "type": "object",
      "properties": {
        "select_id": {
          "type": "integer"
        },
        "cost_info": {
          "type": "object",
          "properties": {
            "query_cost": {
              "type": "string"
            }
          }
        },
        "table": {
          "type": "object",
          "properties": {
            "table_name": {
              "type": "string"
            },
            "access_type": {
              "type": "string"
            },
            "rows_examined_per_scan": {
              "type": "integer"
            },
            "rows_produced_per_join": {
              "type": "integer"
            },
            "filtered": {
              "type": "integer"
            },
            "cost_info": {
              "type": "object",
              "properties": {
                "read_cost": {
                  "type": "string"
                },
                "eval_cost": {
                  "type": "string"
                },
                "prefix_cost": {
                  "type": "string"
                },
                "data_read_per_join": {
                  "type": "string"
                }
              }
            },
            "used_columns": {
              "type": "array"
            }
          }
        }
      }
    }
  }
}