I was looking for an extension that would also display EXPLAIN on queries, I came across this one but it is not compatible with CI2
http://ellislab.com/forums/viewthread/73330/#363390
Attached is the modified version for CI2 and so far its working. Just move it into the
/application/libraries/
Hope someone can find this useful