Skip to content

Instantly share code, notes, and snippets.

@todgru

todgru/size.sql

Created Apr 21, 2020
Embed
What would you like to do?
display size of postgres database and table
SELECT pg_size_pretty (
pg_total_relation_size ('"camelCaseTableName"')
);
SELECT pg_size_pretty (
pg_database_size ('lowercaseddbname')
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.