pgsql: Add stats_reset column to pg_statio_all_sequences

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add stats_reset column to pg_statio_all_sequences
Date: 2026-03-16 08:25:21
Message-ID: E1w23GK-000POj-1v@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(at)gmail(dot)com>
Co-authored-by: Shihao Zhong <zhong950419(at)gmail(dot)com>
Reviewed-by: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAA5RZ0v0OPGyDpwxkX81CtTt9xsj9-TNxhm=8JdOvEKPsVVFNg@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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2026-03-16 08:49:11 pgsql: Reject ALTER TABLE .. CLUSTER earlier for partitioned tables
Previous Message Peter Eisentraut 2026-03-16 06:45:11 pgsql: Fix accidentally casting away const