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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general