Explain or describe tells you how the SQL engine processes the query
Yup. I probably misunderstood the original post
My thinking was that it would be tough (impossible?) to determine "after the run".
As the query and the data content and possibly the db definition might have changed along the way, the EXPLAIN might show unrelated results.
Good to hear the time problem has been improved.