From e5cca6288a4098cf731599b5977b0f6714ba0ac6 Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Tue, 14 Nov 2023 09:50:52 +0900 Subject: Add support for pg_stat_reset_slru without argument pg_stat_reset_slru currently requires an input argument, either: - NULL to reset the SLRU counters of everything. - A specific value to reset a single SLRU cache. This commit adds support for a new pattern: pg_stat_reset_slru without any argument works the same way as pg_stat_reset_slru(NULL), relying on a DEFAULT in the function definition to handle this case. This makes the function more consistent with 23c8c0c8f472. Bump catalog version. Author: Bharath Rupireddy Reviewed-by: Atsushi Torikoshi Discussion: https://postgr.es/m/CALj2ACW1VizYg01EeH_cA-7qA+4NzWVAoZ5Lw9_XYO1RRHAZbA@mail.gmail.com --- doc/src/sgml/monitoring.sgml | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index b8495b64989..6b237d41cb4 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -4781,14 +4781,15 @@ description | Waiting for a newly initialized WAL file to reach durable storage pg_stat_reset_slru - pg_stat_reset_slru ( text ) + pg_stat_reset_slru ( [ target text DEFAULT NULL ] ) void Resets statistics to zero for a single SLRU cache, or for all SLRUs in - the cluster. If the argument is NULL, all counters shown in + the cluster. If target is + NULL or is not specified, all the counters shown in the pg_stat_slru view for all SLRU caches are - reset. The argument can be one of + reset. The argument can be one of CommitTs, MultiXactMember, MultiXactOffset, -- cgit v1.2.3