mmcdermott

c = ActiveRecord::Base.connection
str = ""
c.tables.collect do |t|  
  columns = c.columns(t).collect(&:name).select {|x| x.ends_with?("_id" || x.ends_with("_type"))}
  indexed = c.indexes(t).collect(&:columns).flatten.uniq
  unindexed = columns - indexed
  str += "\n#{t}: #{unindexed.join(", ")}" unless unindexed.empty?
end