Skip to content

Instantly share code, notes, and snippets.

@alfie-max

alfie-max/list_tables.rb

Forked from davidleandro/list_tables.rb
Created August 26, 2022 14:15
Show Gist options
  • Save alfie-max/0788b9b363b196df4ee3b5b79a89382e to your computer and use it in GitHub Desktop.
Save alfie-max/0788b9b363b196df4ee3b5b79a89382e to your computer and use it in GitHub Desktop.
Download ZIP
Rails list all tables count
Raw
list_tables.rb
tables = []
ActiveRecord::Base.connection.tables.each do |t|
count = ActiveRecord::Base.connection.exec_query("select count(*) from #{t}").rows[0][0]
tables << [t, count.to_i]
end
tables.sort_by { |t| t[1] }.reverse!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment