One of the use cases of EXPLAIN is estimating the number of rows in your table. select count() from table1 is costly, alternatively, explain select count(*) from table1 will give an estimated result much faster.

Such an informative and well-written blog! Rooting for more such blogs.