database sizes

gistfile1.txt

dan=# select datname, pg_size_pretty(pg_database_size(datname)) from pg_database;
    datname     | pg_size_pretty 
----------------+----------------
 bacula156      | 8115 kB
 template1      | 6835 kB
 bacula157      | 8099 kB
 postgres       | 6835 kB
 template0      | 6537 kB
 bacula         | 122 GB
 bacula100      | 7649 kB
 bacula150      | 8131 kB
 bacula151      | 8099 kB
 bacula152      | 8099 kB
 bacula153      | 8107 kB
 bacula154      | 8067 kB
 bacula155      | 7763 kB
 bacula158      | 8107 kB
 bacula159      | 7955 kB
 bacula160      | 7755 kB
 bacula161      | 8059 kB
 bacula162      | 8091 kB
 bacula163      | 8147 kB
 bacula164      | 8099 kB
 bacula165      | 7771 kB
 bacula166      | 7763 kB
 bacula167      | 7771 kB
 bacula168      | 7771 kB
 bacula169      | 7771 kB
 bacula170      | 7771 kB
 bacula171      | 8107 kB
 baculatest     | 8513 kB
 bsdcan         | 8811 kB
 dan            | 6739 kB
 freshports.org | 19 GB
 pgcon          | 8275 kB
 testing        | 34 GB
(33 rows)

dan=#