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')查看表有多少个pageselect relpages from pg_class where relname='re';查看表相关联的toastselect reltoastrelid::regclass from pg_class where relname='re';查看文件对应统计信息select * from pg_stat_file('base/12896/16429_fsm');查看表的tuple的使用率，可查表膨胀select * from pgstattuple('re');

vm:

http://book.51cto.com/art/201201/313233.htm

fsm:

http://book.51cto.com/art/201201/313230.htm