Re: Shared buffers increased but cache hit ratio is still 85%

[Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>]

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