]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Add stats_reset column to pg_statio_all_sequences
authorFujii Masao <fujii@postgresql.org>
Mon, 16 Mar 2026 08:24:08 +0000 (17:24 +0900)
committerFujii Masao <fujii@postgresql.org>
Mon, 16 Mar 2026 08:24:08 +0000 (17:24 +0900)
commit8fe315f18d4181d37385c8e62ea3009084ba303a
tree4e9b817d74b4d09fec93ab21a462dc07acef6667
parenta41bc38439a1929a741eb6f1d40ed9eb30d9a8d7
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 <samimseih@gmail.com>
Co-authored-by: Shihao Zhong <zhong950419@gmail.com>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Discussion: https://postgr.es/m/CAA5RZ0v0OPGyDpwxkX81CtTt9xsj9-TNxhm=8JdOvEKPsVVFNg@mail.gmail.com
doc/src/sgml/monitoring.sgml
src/backend/catalog/system_views.sql
src/include/catalog/catversion.h
src/test/regress/expected/rules.out
src/test/regress/expected/stats.out
src/test/regress/sql/stats.sql