Re: Add missing stats_reset column to pg_statio_all_sequences view

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Sami Imseih <samimseih(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, shihao zhong <zhong950419(at)gmail(dot)com>
Subject: Re: Add missing stats_reset column to pg_statio_all_sequences view
Date: 2026-03-16 08:27:19
Message-ID: CAHGQGwEP23LzvkuzQPDO55Ys3gqYzY89sK7znAq6kOuUPmrH9A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 13, 2026 at 11:52 AM Sami Imseih <samimseih(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2026-03-16 08:30:05 Re: Improve OAuth discovery logging
Previous Message Andrew Kim 2026-03-16 08:00:06 Re: Proposal for enabling auto-vectorization for checksum calculations