Rails Query Analyzer Plugin (now also on Oracle and Postgresql!)
Published on Friday, December 1 2006
A few days ago I discovered the query_analyzer plugin in a comment on the last article of The Rails Way series. It allows you to have the plans for the queries used in your application directly in the log file and this is invaluable when trying to to optimize the database for you shiny new rails application.
On the downside it was only for mysql and my oracle developer half though that it was what I needed, so here it is (with Postgresql support as well).
Use it but be warned that I don’t want to fork this plugin, so I haven’t prepared a proper svn access to it and I hope that my additions might be integrated by Bob Silva in his own codebase (I’ll post a comment in his blog since I can’t find any other way to contact him).
Thanks! That’s just what I needed. I hope Bob integrates this back into the plugin.
I took the plugin github clone, your code, added some salt and pepper and put on fire: The result? A gem =P
http://github.com/nofxx/query_analyzer
=D