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: