Skip to content

Instantly share code, notes, and snippets.

@adriancb

adriancb/size.rb

Created June 18, 2015 18:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save adriancb/a5d5155999c59832b733 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save adriancb/a5d5155999c59832b733 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. adriancb created this gist Jun 18, 2015.
    1 change: 1 addition & 0 deletions size.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    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}