when is pg_stat_archiver.stats_reset modified?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

when is pg_stat_archiver.stats_reset modified?

Luca Ferrari-2
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?

Thanks,
Luca


Reply | Threaded
Open this post in threaded view
|

Re: when is pg_stat_archiver.stats_reset modified?

Ian Lawrence Barwick
2021年2月18日(木) 20:21 Luca Ferrari <[hidden email]>:
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

--
Reply | Threaded
Open this post in threaded view
|

Re: when is pg_stat_archiver.stats_reset modified?

Laurenz Albe
In reply to this post by Luca Ferrari-2
On Thu, 2021-02-18 at 12:20 +0100, Luca Ferrari wrote:
> 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?

SELECT pg_stat_reset_shared('archiver');

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com