Horton

Re: Add missing stats_reset column to pg_statio_all_sequences view

Fujii Masao <masao.fujii@gmail.com>

View thread View on postgr.es
From: Fujii Masao <masao.fujii@gmail.com>
To: Sami Imseih <samimseih@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, shihao zhong <zhong950419@gmail.com>
Date: 2026-03-16T08:27:19Z
Lists: pgsql-hackers 
On Fri, Mar 13, 2026 at 11:52 AM Sami Imseih <samimseih@gmail.com> wrote:
>
> > 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.

Thanks for updating the patch!

I made a few cosmetic changes and pushed the patch. Thanks!

Regards,

-- 
Fujii Masao

Commits

  1. Remove unstable test for pg_statio_all_sequences stats reset

  2. Add stats_reset column to pg_statio_all_sequences