Horton

Re: Add missing stats_reset column to pg_statio_all_sequences view

Sami Imseih <samimseih@gmail.com>

View thread View on postgr.es
From: Sami Imseih <samimseih@gmail.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, shihao zhong <zhong950419@gmail.com>
Date: 2026-03-13T02:52:10Z
Lists: pgsql-hackers

Attachments

> it would be better to verify that the stats of the specified sequence are
> actually reset by using pg_stat_reset_single_table_counters().
>
> Also, the documentation for pg_stat_reset_single_table_counters() should
> mention that it can reset sequence statistics as well.

good points.

For the  documentation of pg_stat_reset_single_table_counters(), I also
mentioned materialized views for completeness.

--
Sami Imseih
Amazon Web Services (AWS)

Commits

  1. Remove unstable test for pg_statio_all_sequences stats reset

  2. Add stats_reset column to pg_statio_all_sequences