Postgres Pro
Downloads
Home   >   mailing lists

Re: Shared buffers increased but cache hit ratio is still 85% - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Shared buffers increased but cache hit ratio is still 85%
Date
Msg-id 6ac7183c-d93b-9fc5-d7a7-8d2f312be0c0@a-kretschmer.de
Whole thread Raw
In response to Shared buffers increased but cache hit ratio is still 85%  (Hans Schou <hans.schou@gmail.com>)
Responses Re: Shared buffers increased but cache hit ratio is still 85%
Re: Shared buffers increased but cache hit ratio is still 85%
List pgsql-general
Tree view 

Am 18.07.2018 um 10:26 schrieb Hans Schou:
> Am I doing something wrong or should some history be cleared?

Reset the stats for that database. You can check the date of last reset 
with:

select stats_reset from pg_stat_database where datname = 'database_name';

and reset it with:

||pg_stat_reset()
||
||Reset all statistics counters for the current database to zero 
(requires superuser privileges by default, but EXECUTE for this function 
can be granted to others.)||


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

pgsql-general by date:

Previous
From: Hans Schou
Date:
Subject: Shared buffers increased but cache hit ratio is still 85%
Next
From: Raghavendra Rao J S V
Date:
Subject: Is it ok to run vacuum full verbose command for live database for thetables which has more dead tuples?