Add stats_reset column to pg_statio_all_sequences pg_statio_all_sequences lacked a stats_reset column, unlike the other pg_statio_* views that already expose it. This commit adds the column so users can see when the statistics in this view were last reset.
Also this commit updates the documentation for pg_stat_reset_single_table_counters() to clarify that it can reset statistics for sequences and materialized views as well. Catalog version bumped. Author: Sami Imseih <[email protected]> Co-authored-by: Shihao Zhong <[email protected]> Reviewed-by: Fujii Masao <[email protected]> Discussion: https://postgr.es/m/CAA5RZ0v0OPGyDpwxkX81CtTt9xsj9-TNxhm=8jdovekpsvv...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/8fe315f18d4181d37385c8e62ea3009084ba303a Modified Files -------------- doc/src/sgml/monitoring.sgml | 11 +++++++++++ src/backend/catalog/system_views.sql | 3 ++- src/include/catalog/catversion.h | 2 +- src/test/regress/expected/rules.out | 9 ++++++--- src/test/regress/expected/stats.out | 33 +++++++++++++++++++++++++++++++++ src/test/regress/sql/stats.sql | 15 +++++++++++++++ 6 files changed, 68 insertions(+), 5 deletions(-)
