Bob Silva has put together a fine MySQL query analyzer plugin for Ruby on Rails. It uses MySQL's EXPLAIN command to analyze all of the different SQL queries made by your Rails application (or, more accurately, by ActiveRecord!) and gives you the information you need to add better indexes (or add any extra indexes at all!) and could help show where a little custom SQL could silence a squeaky wheel.