Flávio,

Segue comando que utilizei
SELECT current_timestamp, datname, (pg_database_size(datname)),
pg_size_pretty(pg_database_size(datname))
FROM pg_database
WHERE datname not in ('template0','template1','postgres')
order by datname


Esse  pg_database_size pega os dados direto do SO ou dos metadatos?
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a