I've used this in the past. What I find that it's missing is the _why_, not the _what_. It's not that my query is performing a full table scan that I care about. It's why it's not using one of the six indexes that I want to know.

I would pay good money for an extension that could answer how the query planner makes decisions about a given query.