Hi, <br /><br /> Currently a "select * from pg_statio_user_tables;" displays only heap_blks_read, heap_blks_hit stats
amongstothers for the main relation. It would be good to have the following stats collected too. I think these stats
canbe used to better statistically analyze/understand the block I/O activity on the relation:<br /><br />
heap_blks_reused:The number of buffers returned by the FSM for use to store a new tuple in<br /><br />
heap_blks_extend:The number of times file extend was invoked on the relation<br /><br /> heap_blks_truncate: The total
numberof blocks that have been truncated due to vacuum activity e.g.<br /><br /> As an addendum to the truncate stats
above,we can also have the additional following stats:<br /><br /> heap_blks_maxtruncate: The max block of buffers
truncatedin one go<br /><br /> heap_blks_ntruncate: The number of times truncate was called on this relation<br
clear="all"/><br /> I can come up with a patch (already have one) for the above. Any thought/comments?<br /><br />
Regards,<br/> Nikhils <br /> (<a href="http://www.enterprisedb.com">www.enterprisedb.com</a>)<br />-- <br />All the
world'sa stage, and most of us are desperately unrehearsed.<br />