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()

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.