Skip to content

Instantly share code, notes, and snippets.

@jorgeas80

jorgeas80/get_sizes.sql

Created October 15, 2017 09:17
Show Gist options
  • Save jorgeas80/4d1540a2ec6fb3efb364bb848a72d4ca to your computer and use it in GitHub Desktop.
Save jorgeas80/4d1540a2ec6fb3efb364bb848a72d4ca to your computer and use it in GitHub Desktop.
Download ZIP
Get size of database objects
Raw
get_sizes.sql
SELECT
relname as "Table",
pg_size_pretty(pg_total_relation_size(relid)) As "Size",
pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size"
FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;
@jorgeas80
Copy link
Author

Taken from https://wiki-bsse.ethz.ch/display/ITDOC/Check+size+of+tables+and+objects+in+PostgreSQL+database

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment