Let me obtain a detailed query plan in MySQL much like EXPLAIN Evaluate shows in PostgreSQL. Can there be a similar?

EDIT: Whilst not an immediate equivalent or as detailed as Explain Evaluate here are a few tools that you can try

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

I haven't used PostgreSQL before MySQL has EXPLAIN EXTENDED which provides more details than EXPLAIN and could give you the data you're searching for.