missing_index_finder.rb

module ActiveRecord::ConnectionAdapters::DatabaseStatements
  def select_all_with_explain_plan(sql, name = nil)
    missing_indexes = select_all_without_explain_plan("EXPLAIN #{sql}", "explain plan").reject {|r| r['key'] }
    raise "Missing dataabase indexes: #{missing_indexes.inspect}" if missing_indexes.any?
    select_all_without_explain_plan(sql, name)
  end
  alias_method_chain :select_all, :explain_plan
end