simple explain output.

Hi all,

I'm pretty sure the answer to this is "not possible" but I'll ask just
in case.

Is there a way to simplify the output that comes from explain?

I'm writing a script to check my database logs to see whether I am
missing any indexes.


Basically the process goes like this:

- Find a select query in the logs
- Run it through the database using 'explain'
- Check whether it's using an index scan or "other"


Yes, I know not every query is going to use an index, but this will cut
down on the queries I have to check.

At the moment the explain output can get complicated to parse and
process, so I'm trying to think of another approach to use.

Any suggestions are welcome :)

Chris.