From b71bae41a0cdda879db39d9946d2cc4af910bed1 Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Wed, 8 Oct 2025 12:43:40 +0900 Subject: Add stats_reset to pg_stat_user_functions It is possible to call pg_stat_reset_single_function_counters() for a single function, but the reset time was missing the system view showing its statistics. Like all the fields of pg_stat_user_functions, the GUC track_functions needs to be enabled to show the statistics about function executions. Bump catalog version. Bump PGSTAT_FILE_FORMAT_ID, as a result of the new field added to PgStat_StatFuncEntry. Author: Bertrand Drouvot Discussion: https://postgr.es/m/aONjnsaJSx-nEdfU@paquier.xyz --- src/backend/utils/activity/pgstat_function.c | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'src/backend/utils/activity/pgstat_function.c') diff --git a/src/backend/utils/activity/pgstat_function.c b/src/backend/utils/activity/pgstat_function.c index 6214f93d36e..b5db9d15e07 100644 --- a/src/backend/utils/activity/pgstat_function.c +++ b/src/backend/utils/activity/pgstat_function.c @@ -214,6 +214,12 @@ pgstat_function_flush_cb(PgStat_EntryRef *entry_ref, bool nowait) return true; } +void +pgstat_function_reset_timestamp_cb(PgStatShared_Common *header, TimestampTz ts) +{ + ((PgStatShared_Function *) header)->stats.stat_reset_timestamp = ts; +} + /* * find any existing PgStat_FunctionCounts entry for specified function * -- cgit v1.2.3