Find potential missing foreign key indexes

gistfile1.txt

ActiveRecord::Base.logger = nil
connection = ActiveRecord::Base.connection; nil
connection.tables.each do |table|  
  columns = connection.columns(table).map(&:name).select {|x| x.ends_with?("_id")}
  indexed_columns = connection.indexes(table).map(&:columns).flatten.uniq
  unindexed = columns - indexed_columns
  unless unindexed.empty?
    puts "#{table}: #{unindexed.join(", ")}"
  end
  nil
end; nil