POSTGRESQL 查看数据库 数据表大小

1、查看数据库大小：

select pg_database_size('log_analysis');

select pg_database_size('log_analysis');

 pg_database_size 
------------------
         23799992
(1 row)

2、select pg_database.datname, pg_size_pretty (pg_database_size(pg_database.datname)) AS size from pg_database; 

log_analysis=# select pg_database.datname, pg_size_pretty (pg_database_size(pg_database.datname)) AS size from