postgrsql 查看物理空间函数

=> SELECT pg_database_size('myproject');
 pg_database_size
------------------
          9641188
(1 row)

=> SELECT pg_relation_size('mytable');
 pg_relation_size
------------------
             8192
(1 row)


显示为更易读的格式：
=> SELECT pg_size_pretty(pg_database_size('myproject'));
 pg_size_pretty
----------------
 9415 kB
(1 row)
=> SELECT pg_size_pretty(pg_relation_size('mytable'));
 pg_size_pretty
----------------
 8192 bytes
(1 row)