"Chris Hoover" <[EMAIL PROTECTED]> writes:
> I was taking heap_blks_hit / heap_blks_read for my hit pct.
> It should be heap_blks_hit/(heap_blks_read+heap_blks_hit), correct?
Right.
regards, tom lane
---(end of broadcast)---
I think I have figured my problem out.
I was taking heap_blks_hit / heap_blks_read for my hit pct.
It should be heap_blks_hit/(heap_blks_read+heap_blks_hit), correct?
Thanks
On Wednesday 21 April 2004 11:34, Chris Hoover wrote:
> I just want to make sure that I am interpreting this data correctl
I just want to make sure that I am interpreting this data correctly.
From pg_statio_user_tables, I have pulled relname, heap_blks_read,
heap_blks_hit. I get several rows like this:
relname heap_bkls_read heap_blks_hit
clmhdr 8607161
