Plugins - pg_explain
Add to favoritesThis Rails plugin shows the output, in your application log, of applying "Explain" or "Explain Analyze" to the select queries of your rails application. It should be used with a PostgreSQL database.
To install the plugin:
script/plugin install svn://rubyforge.org/var/svn/pgexplain
http://pgexplain.rubyforge.org/index.html
svn://rubyforge.org/var/svn/pgexplain
Rails' (MIT)
Statistics and Logs
I've been looking for something like this for ages! Brilliant.
Rails should really have EXPLAIN analysis built in; so many purported performance problems are simply due to people not knowing what EXPLAIN is or how to use it.