Are MySQL partitions visible in the EXPLAIN plan for SELECT ....?

Question

I would like to know if we have the opportunity to see which partitions were scanned during the query execution plan.

Is this information visible in EXPLAIN / EXPLAIN EXTENDED of the corresponding SELECT ...?

Answer 1

Use: EXPLAIN PARTITIONS SELECT

Answer 2

You need to use EXPLAIN PARTITIONS(and link 5.5 )

MySQL 5.1.5, , SELECT, EXPLAIN PARTITIONS. PARTITIONS EXPLAIN, , .

EXPLAIN PARTITIONS EXTENDED,