本文展示了如何使用PostgreSQL内置函数查询特定数据库及其表的大小，并将结果以易于理解的格式展示。
=> 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)
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)
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
