[20241002] MySQL Explain (TRADITIONAL, TREE, JSON, ANALYZE)

[JuHyun419]

SELECT * FROM 사원 WHERE 사원번호 BETWEEN 100001 AND 200000;

EXPLAIN (default TRADITIONAL)

EXPLAIN FORMAT = TREE

-> Filter: (`사원`.`사원번호` between 100001 and 200000)  (cost=4021.24 rows=20080)
    -> Index range scan on 사원 using PRIMARY over (100001 <= 사원번호 <= 200000)  (cost=4021.24 rows=20080)

EXPLAIN FORMAT = JSON

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "4021.24"
    },
    "table": {
      "table_name": "사원",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "사원번호"
      ],
      "key_length": "4",
      "rows_examined_per_scan": 20080,
      "rows_produced_per_join": 20080,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "2013.24",
        "eval_cost": "2008.00",
        "prefix_cost": "4021.24",
        "data_read_per_join": "1M"
      },
      "used_columns": [
        "사원번호",
        "생년월일",
        "이름",
        "성",
        "성별",
        "입사일자"
      ],
      "attached_condition": "(`tuning`.`사원`.`사원번호` between 100001 and 200000)"
    }
  }
}

EXPLAIN ANALYZE

-> Filter: (`사원`.`사원번호` between 100001 and 200000)  (cost=4021.24 rows=20080) (actual time=0.086..10.034 rows=10025 loops=1)
    -> Index range scan on 사원 using PRIMARY over (100001 <= 사원번호 <= 200000)  (cost=4021.24 rows=20080) (actual time=0.079..8.449 rows=10025 loops=1)