PostgreSQL disk usage
Size of database with name ‘dbname’: SELECT pg_size_pretty(pg_database_size(’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’));SELECT pg_size_pretty(pg_total_relation_size(‘tablename’));