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.