sql - What is the MySQL equivalent of PostgreSQL's EXPLAIN ANALYZE

Question

I'd like to get a detailed query plan in MySQL similar to EXPLAIN ANALYZE shows in PostgreSQL. Is there an equivalent?

Answer 1

EDIT: While not a direct equivalent or as detailed as Explain Analyze here are some tools that you can look at

mysql offers EXPLAIN and procedure analyse()
http://dev.mysql.com/doc/refman/5.0/en/explain.html
http://dev.mysql.com/doc/refman/5.0/en/procedure-analyse.html