PostgreSQL check all DB SIZE

#CHECK DB SIZE:

postgres=# select t1.datname AS db_name,pg_size_pretty(pg_database_size(t1.datname)) as db_size from pg_database t1 order by pg_database_size(t1.datname) desc;

        db_name         | db_size 

------------------------+---------

 xxx                    | 8109 MB

 xxx_20210622_14h05     | 7520 MB

 xxx_500001_1000000     | 1052 MB

 xxx_000001_500000      | 566 MB

 postgres               | 11 MB

 beta_xxxchat           | 8461 kB

 template1              | 7605 kB

 template0              | 7433 kB

(8 rows)