In MySQL 8.0.18 there is a new feature called Explain Analyze when for many years we mostly
had only the traditional Explain. I know there are
different formats, but those based on the same information just
show it in a different format with some extra details.
But Explain Analyze is a different concept. It is
actually going to run the query and measure execution time by
using the new iterator executor for each step. That
topic itself deserves its own blog post on how the new iterator
executor works, and I will write a post about that as well. But
if you cannot wait and you would like to read up, here are some
links to some additional information: Iterator executor analytics …