Re: Needs Suggestion

On 4/27/2011 9:35 AM, SUBHAM ROY wrote:
> Can I calculate the *Buffer Hit ratio* *of a particular query* in
> postgres? That is *how many times it finds the required page* in its
> buffer cache, pg_buffercache or the
> linux buffer cache.
>
> --
> Thank You,
> Subham Roy,
> CSE IIT Bombay.
>

There are plenty of stats per table, but I dont think you'll find
anything per query.

However, you could clear the table stats, run the query a bunch of
times, then look at the table stats. Also, it'll tell you pg buffer
hits, but you wont really know if it hit the linux cache or actual hard
drive.

Google can help you out with table stats: postgres cache hit

-Andy