查看PostgreSQL数据表格和索引的大小
Tuesday, 31. July 2007, 10:07:38
-- 随机顺序
SELECT relname, reltuples, relpages FROM pg_class ;
-- 按 relpages（磁盘使用量）排序（降序）
SELECT relname, reltuples, relpages FROM pg_class ORDER BY relpages DESC ;
-- 按 reltuples（记录数）排序（降序）
SELECT relname, reltuples, relpages FROM pg_class ORDER BY reltuples DESC ;
参考：PostgreSQL Tips and Tricks
SELECT relname, reltuples, relpages FROM pg_class ;
-- 按 relpages（磁盘使用量）排序（降序）
SELECT relname, reltuples, relpages FROM pg_class ORDER BY relpages DESC ;
-- 按 reltuples（记录数）排序（降序）
SELECT relname, reltuples, relpages FROM pg_class ORDER BY reltuples DESC ;
参考：PostgreSQL Tips and Tricks
WIDGETIZE