Count record in each table in database

db_counter.rb

# use as DbCounter.new.run

class DbRrecordCounter

  def initialize
    @conn = ActiveRecord::Base.connection
  end

  def run
    tables = @conn.tables
    tables.each do |t|
      result = @conn.execute("select count(*) from #{t}")
      rec = result.first
      puts "#{t}: #{rec['count']}"
    end
  end

end