Skip to content

Instantly share code, notes, and snippets.

@adriancb

adriancb/size.rb

Created June 18, 2015 18:16
Show Gist options
  • Save adriancb/a5d5155999c59832b733 to your computer and use it in GitHub Desktop.
Save adriancb/a5d5155999c59832b733 to your computer and use it in GitHub Desktop.
Download ZIP
Show size of PG tables
Raw
size.rb
ActiveRecord::Base.connection.execute("SELECT relname AS relation, pg_size_pretty(pg_relation_size(C.oid)) AS size FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN ('pg_catalog', 'information_schema') ORDER BY pg_relation_size(C.oid) DESC LIMIT 100;").each {|c| puts c}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment