Re: when is pg_stat_archiver.stats_reset modified? - Mailing list pgsql-general

From Ian Lawrence Barwick
Subject Re: when is pg_stat_archiver.stats_reset modified?
Date
Msg-id CAB8KJ=i3S2+OWHuSuwhZas6BnzqXJVanA1836cb1nQahBj5s-g@mail.gmail.com
Whole thread Raw
In response to when is pg_stat_archiver.stats_reset modified?  (Luca Ferrari <fluca1978@gmail.com>)
List pgsql-general
2021年2月18日(木) 20:21 Luca Ferrari <fluca1978@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().


Regards

Ian Barwick

--

pgsql-general by date:

Previous
From: Joao Miguel Ferreira
Date:
Subject: Re: permanent setting of config variables
Next
From: Laurenz Albe
Date:
Subject: Re: when is pg_stat_archiver.stats_reset modified?