Postgres Show Table Size on Disk

Oct 24, 2022

The following commands allow you to query the size on disk occupied by tables, dbs and other relations. 

Table size 

SELECT pg_size_pretty( pg_total_relation_size('table_name') );

db size

SELECT pg_size_pretty( pg_database_size('dbname') );

More posts

• Previous: Postgres Backups with pg_dump, pg_restore & psql