While loading a large database from files to a Postgres schema, I found very useful to know how much space on disk it actually occupies (just in case I need to re-size the disk). I found this answer online:
SELECT schema_name,
pg_size_pretty(sum(table_size)::bigint) as
