|
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 | idx_blks_read |
idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read |
tidx_blks_hit -------+------------+---------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+--------------- 16386
| public | tab
|
0 | 0
| 0
| 0
|
|
|
|
(1
row) #
select * from pg_statio_user_indexes; relid
| indexrelid | schemaname | relname | indexrelname | idx_blks_read |
idx_blks_hit -------+------------+------------+---------+--------------+---------------+-------------- 16386
| 24581 | public |
tab | idx_tab_a2
| 0
| 0 (1
row) I’ve set: stats_start_collector
= on stats_row_level = on stats_block_level = on and
I think that the statistics collector should be running, because: $
ps aux|grep stats postgres
3688 0.0 0.0 7272 648
? Ss 00:48
0:00 postgres: stats collector
process
postgres
29790 0.0 0.0 4004 712
pts/2 S+ 04:44 0:00 grep stats Any help would be
really appreciated. Regards, Yinan |
