create table ten(a int);

insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

create table one_k(a int);

insert into one_k select A.a + B.a* 10 + C.a * 100 from ten A, ten B, ten C;

create table t1 (pk int primary key);

insert into t1 select a from one_k;

alter table t1 add b int;

update t1 set b=pk;

analyze format=json delete from t1 where pk < 10 and b > 4;

{

  "query_block": {

    "select_id": 1,

    "table": {

      "delete": 1,

      "table_name": "t1",

      "access_type": "range",

      "possible_keys": ["PRIMARY"],

      "key": "PRIMARY",

      "key_length": "4",

      "used_key_parts": ["pk"],

      "rows": 10,

      "r_rows": 10,

      "r_filtered": 0.5,

      "attached_condition": "((t1.pk < 10) and (t1.b > 4))"

    }

  }

}

MariaDB [test]> analyze format=json select * from t1 where pk < 10 and b > 4;

{

  "query_block": {

    "select_id": 1,

    "r_loops": 1,

    "r_total_time_ms": 0.5577,

    "table": {

      "table_name": "t1",

      "access_type": "range",

      "possible_keys": ["PRIMARY"],

      "key": "PRIMARY",

      "key_length": "4",

      "used_key_parts": ["pk"],

      "r_loops": 1,

      "rows": 10,

      "r_rows": 10,

      "r_total_time_ms": 0.3788,

      "filtered": 100,

      "r_filtered": 50,

      "attached_condition": "((t1.pk < 10) and (t1.b > 4))"

    }

  }

}