Help understanding stat tables - Mailing list pgsql-performance

From Chris Hoover
Subject Help understanding stat tables
Date
Msg-id 200404211134.16876.revoohc@sermonaudio.com
Whole thread Raw
Responses Re: Help understanding stat tables
List pgsql-performance
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            196547165







                                                                                               


So this means that I am getting over a 100% cache hit ratio for this table,
right?  If not, please help me understand what these numbers mean.

Thanks,

Chris


pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Wierd context-switching issue on Xeon
Next
From: Frédéric Robinet
Date:
Subject: Shared buffers, Sort memory, Effective Cache Size