My Opera查看PostgreSQL数据表格和索引的大小
Tuesday, July 31, 2007 10:07:38 AM
-- 随机顺序
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
You must be 
