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

Re: Help understanding stat tables

From: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help understanding stat tables
Date: 2004-04-21 16:24:35
Message-ID: 200404211224.35696.revoohc@sermonaudio.com (view raw or flat)
Thread:
Lists: pgsql-performance
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 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly


In response to

Responses

pgsql-performance by date

Next:From: Frédéric RobinetDate: 2004-04-21 16:29:06
Subject: Shared buffers, Sort memory, Effective Cache Size
Previous:From: Edoardo CeccarelliDate: 2004-04-21 16:23:12
Subject: Re: slow seqscan

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