2021年2月18日(木) 20:21 Luca Ferrari <fluca1...@gmail.com>: > Hi all, > running on 12.5, but I guess this does not mind, I cannot understand > when the value of pg_stat_archiver.stats_reset field is modified. > I've executed a pg_stat_reset() but it did not affected the specified > field. > I suppose that field is not "resettable" by the administrator, as I > tried to, but then what drives changes? >
As pg_stat_archiver shows cluster-wide stats, you need pg_stat_reset_shared(). https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-STATS-FUNCTIONS Regards Ian Barwick -- EnterpriseDB: https://www.enterprisedb.com