Re: [GENERAL] zero value in statistics collector's result

2007-09-23 Thread Tom Lane
"Yinan Li" <[EMAIL PROTECTED]> writes: > When I use the statistics collector to see the number of IO, I always get > zero in almost all of columns. I really want to know the reason for that. It sure sounds like you don't really have stats_block_level turned on. Did you remember to SIGHUP the postm

[GENERAL] zero value in statistics collector's result

2007-09-23 Thread Yinan Li
Hi, When I use the statistics collector to see the number of IO, I always get zero in almost all of columns. I really want to know the reason for that. The result of statistics view: # select * from pg_statio_user_tables; relid | schemaname | relname | heap_blks_read | heap_blks_hit | id