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:

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

fsm:

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