Skip to content

Instantly share code, notes, and snippets.

@pop3xrj

pop3xrj/calculate psql table size

Created September 11, 2009 01:43
Show Gist options
  • Save pop3xrj/184999 to your computer and use it in GitHub Desktop.
Save pop3xrj/184999 to your computer and use it in GitHub Desktop.
Download ZIP
display table szie for ppostgresql
Raw
calculate psql table size
SELECT relname, reltuples, relpages * 8 / 1024 AS "MB" FROM pg_class ORDER BY relpages DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment