MySQL EXPLAIN

EXPLAIN 

 SELECT mycolumn

   FROM mytable

  WHERE mycolumn = 'myvalue';

EXPLAIN FORMAT=JSON

 SELECT mycolumn

   FROM mytable

  WHERE mycolumn = 'myvalue';

EXPLAIN FORMAT=TREE

 SELECT mycolumn

   FROM mytable

  WHERE mycolumn = 'myvalue';

Not available in 5.7 and earlier

EXPLAIN ANALYZE

 SELECT mycolumn

   FROM mytable

  WHERE mycolumn = 'myvalue';

Bibliography