From 2e8a0edc2a3321582d5da65690b0371654c7a44f Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Thu, 16 Nov 2023 15:41:34 +0900 Subject: Add target "slru" to pg_stat_reset_shared() Currently, pg_stat_reset_shared() cannot reset the counters in the view pg_stat_slru even if it is a type of shared stats. This patch adds support for a new value in pg_stat_reset_shared(), called "slru", able to do that. Note that pg_stat_reset_shared(NULL) also resets SLRU counters. There may be a point in removing pg_stat_reset_slru() that was introduced in 28cac71bd368 (v13~) as the new option overlaps with this function, but we would lose the ability to reset individual SLRU counters. This is left for future reconsideration. Author: Atsushi Torikoshi Discussion: https://postgr.es/m/e3c25d72e81378e7b64f3c52e0306fc9@oss.nttdata.com --- doc/src/sgml/monitoring.sgml | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 1e9913c8bc7..42509042ad5 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -4749,6 +4749,12 @@ description | Waiting for a newly initialized WAL file to reach durable storage the pg_stat_recovery_prefetch view. + + + slru: Reset all the counters shown in the + pg_stat_slru view. + + wal: Reset all the counters shown in the -- cgit v1.2.3