show handles in batch point get plan if possible

[zz-jason]

Feature Request

Is your feature request related to a problem? Please describe:

it's hard to tell what handles are used to extracted data from storage

Describe the feature you'd like:

show handles in the explain result, like the following one:

TiDB(root@127.0.0.1:test) > explain for connection 1;
+-------------------------+-------+------+-----------------------------------------+
| id                      | count | task | operator info                           |
+-------------------------+-------+------+-----------------------------------------+
| _0                      | N/A   | root | N/A                                     |
| └─Batch_Point_Get_1     | 2.00  | root | table:bmsql_item, handles: [123 456]    |
+-------------------------+-------+------+-----------------------------------------+
2 rows in set (0.00 sec)

Describe alternatives you've considered:

No

Teachability, Documentation, Adoption, Migration Strategy:

No

[zz-jason]

@LittleFall PTAL.

[LittleFall]

Sorry for I didn't understand it well, can you give the expected result for the example? @zz-jason

[zz-jason]

It has been resolved:

TiDB(root@127.0.0.1:test) > explain for connection 4;
+-------------------+---------+------+------------------+------------------------------------------------+
| id                | estRows | task | access object    | operator info                                  |
+-------------------+---------+------+------------------+------------------------------------------------+
| Batch_Point_Get_1 | 2.00    | root | table:bmsql_item | handle:[123 456], keep order:false, desc:false |
+-------------------+---------+------+------------------+------------------------------------------------+
1 row in set (0.00 sec)```