| From: | Sami Imseih <samimseih(at)gmail(dot)com> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(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-13 02:52:10 |
| Message-ID: | CAA5RZ0sFvN+WJUTxwL0rZQPHcyyCrxsVu+EypxAzRK0Zta71_g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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)
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Add-stats_reset-column-to-pg_statio_all_sequences.patch | application/octet-stream | 6.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-03-13 02:57:13 | Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row |
| Previous Message | Xuneng Zhou | 2026-03-13 02:39:52 | Re: Streamify more code paths |