PostgreSQL disk usage

Posted on by admin
Size of database with name ‘dbname’: 
SELECT pg_size_pretty(pg_database_size('dbname'));
Size of table with name ‘tablename’ in current database: 
SELECT pg_size_pretty(pg_total_relation_size('tablename'));