projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 035b091) | patch
Add stats_reset to pg_stat_user_functions
authorMichael Paquier <michael@paquier.xyz>
Wed, 8 Oct 2025 03:43:40 +0000 (12:43 +0900)
committerMichael Paquier <michael@paquier.xyz>
Wed, 8 Oct 2025 03:43:40 +0000 (12:43 +0900)
commitb71bae41a0cdda879db39d9946d2cc4af910bed1
tree2a92bc7489ef681fede095f08e46a4dcf4d856d1tree
parent035b09131daab84f2ed9a4a3f766bf4781fd5cbfcommit | diff
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 <bertranddrouvot.pg@gmail.com>
Discussion: https://postgr.es/m/aONjnsaJSx-nEdfU@paquier.xyz
13 files changed:
doc/src/sgml/monitoring.sgml diff | blob | blame | history
src/backend/catalog/system_views.sql diff | blob | blame | history
src/backend/utils/activity/pgstat.c diff | blob | blame | history
src/backend/utils/activity/pgstat_function.c diff | blob | blame | history
src/backend/utils/adt/pgstatfuncs.c diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_proc.dat diff | blob | blame | history
src/include/pgstat.h diff | blob | blame | history
src/include/utils/pgstat_internal.h diff | blob | blame | history
src/test/isolation/expected/stats.out diff | blob | blame | history
src/test/isolation/expected/stats_1.out diff | blob | blame | history
src/test/isolation/specs/stats.spec diff | blob | blame | history
src/test/regress/expected/rules.out diff | blob | blame | history
This is the main PostgreSQL git repository.