Skip site navigation (1) Skip section navigation (2)

Help understanding stat tables

From: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Help understanding stat tables
Date: 2004-04-21 15:34:16
Message-ID: 200404211134.16876.revoohc@sermonaudio.com (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-performance by date

Next:From: Edoardo CeccarelliDate: 2004-04-21 16:23:12
Subject: Re: slow seqscan
Previous:From: Dave CramerDate: 2004-04-21 15:05:31
Subject: Re: Wierd context-switching issue on Xeon

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group