Himanshu Baweja <[EMAIL PROTECTED]> writes: > i just noted one more thing... > pg_stat_get_db_blocks_fetched/hit is getting updated > but pg_stat_get_blocks_fetched/hit are not getting > updated.....
That's pretty difficult to credit after looking at the pgstat.c code: every incoming blocks_fetched count is added to both per-table and per-database stats. I wonder if you are looking at the wrong per-table entries? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]