gistfile1.txt

| {
  "query_block": {
    "select_id": 1,
    "r_loops": 1,
    "r_total_time_ms": 2727.6,
    "temporary_table": {
      "table": {
        "table_name": "<derived2>",
        "access_type": "ALL",
        "r_loops": 1,
        "rows": 860,
        "r_rows": 8623,
        "r_total_time_ms": 193.17,
        "r_extra_time_ms": 340.71,
        "filtered": 100,
        "r_filtered": 99.965,
        "attached_condition": "t_mat.`user` <> 'root'",
        "materialized": {
          "query_block": {
            "recursive_union": {
              "table_name": "<union2,3>",
              "access_type": "ALL",
              "r_loops": 0,
              "r_rows": null,
              "query_specifications": [
                {
                  "query_block": {
                    "select_id": 2,
                    "r_loops": 1,
                    "r_total_time_ms": 77.972,
                    "table": {
                      "table_name": "t_mat",
                      "access_type": "ALL",
                      "r_loops": 1,
                      "rows": 860,
                      "r_rows": 860,
                      "r_total_time_ms": 20.743,
                      "r_extra_time_ms": 57.214,
                      "filtered": 100,
                      "r_filtered": 84.419,
                      "attached_condition": "t_mat.is_role <> 'Y'"
                    }
                  }
                },
                {
                  "query_block": {
                    "select_id": 3,
                    "operation": "UNION",
                    "r_loops": 3,
                    "r_total_time_ms": 1905.6,
                    "table": {
                      "table_name": "t_mat",
                      "access_type": "ALL",
                      "r_loops": 3,
                      "rows": 860,
                      "r_rows": 860,
                      "r_total_time_ms": 46.488,
                      "r_extra_time_ms": 2.754,
                      "filtered": 100,
                      "r_filtered": 100
                    },
                    "table": {
                      "table_name": "r",
                      "access_type": "ref",
                      "possible_keys": ["User"],
                      "key": "User",
                      "key_length": "240",
                      "used_key_parts": ["User"],
                      "ref": ["j1.t_mat.user"],
                      "r_loops": 2580,
                      "rows": 5,
                      "r_rows": 0.8047,
                      "r_total_time_ms": 39.107,
                      "r_extra_time_ms": 3.8212,
                      "filtered": 100,
                      "r_filtered": 100
                    },
                    "table": {
                      "table_name": "<derived2>",
                      "access_type": "ref",
                      "possible_keys": ["key0"],
                      "key": "key0",
                      "key_length": "241",
                      "used_key_parts": ["role"],
                      "ref": ["j1.t_mat.user"],
                      "r_loops": 4344,
                      "rows": 10,
                      "r_rows": 6.5338,
                      "r_total_time_ms": 575.19,
                      "r_extra_time_ms": 1446.8,
                      "filtered": 100,
                      "r_filtered": 100
                    }
                  }
                }
              ]
            }
          }
        }
      }
    }
  }
} |