show size database postgres

 SELECT pg_size_pretty(pg_database_size ('database_name'));