From 5243f9a9988c02ba5ed496fcc5067f13e7157fa6 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 20 Aug 2002 04:47:52 +0000 Subject: Allow pg_statistics to be reset by calling pg_stat_reset(). Christopher Kings-Lynne --- src/backend/utils/adt/pgstatfuncs.c | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'src/backend/utils/adt/pgstatfuncs.c') diff --git a/src/backend/utils/adt/pgstatfuncs.c b/src/backend/utils/adt/pgstatfuncs.c index 2d7054327a7..8e36b001404 100644 --- a/src/backend/utils/adt/pgstatfuncs.c +++ b/src/backend/utils/adt/pgstatfuncs.c @@ -20,6 +20,7 @@ extern Datum pg_stat_get_blocks_hit(PG_FUNCTION_ARGS); extern Datum pg_stat_get_backend_idset(PG_FUNCTION_ARGS); extern Datum pg_backend_pid(PG_FUNCTION_ARGS); +extern Datum pg_stat_reset(PG_FUNCTION_ARGS); extern Datum pg_stat_get_backend_pid(PG_FUNCTION_ARGS); extern Datum pg_stat_get_backend_dbid(PG_FUNCTION_ARGS); extern Datum pg_stat_get_backend_userid(PG_FUNCTION_ARGS); @@ -218,6 +219,17 @@ pg_backend_pid(PG_FUNCTION_ARGS) PG_RETURN_INT32(MyProcPid); } +/* + * Built-in function for resetting the counters + * + */ +Datum +pg_stat_reset(PG_FUNCTION_ARGS) +{ + pgstat_reset_counters(); + + PG_RETURN_BOOL(true); +} Datum pg_stat_get_backend_pid(PG_FUNCTION_ARGS) -- cgit v1.2.3