table相关信息

http://blog.163.com/digoal@126/blog/static/1638770402013527920474/

create extension pgstattuple;

create extension pg_freespacemap;

查看表文件路径 select * from pg_relation_filepath('re'); 查看表(所有page)的大小 select * from pg_relation_size('re') 查看表有多少个page select relpages from pg_class where relname='re'; 查看表相关联的toast select reltoastrelid::regclass from pg_class where relname='re'; 查看文件对应统计信息 select * from pg_stat_file('base/12896/16429_fsm'); 查看表的tuple的使用率,可查表膨胀 select * from pgstattuple('re');

vm:
fsm:
posted @ 2014-05-30 10:33  bielidefeng  阅读(87)  评论(0编辑  收藏  举报