Request a Demo
Home   >   mailing lists

Re: Add missing stats_reset column to pg_statio_all_sequences view - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: Add missing stats_reset column to pg_statio_all_sequences view
Date
Msg-id CAA5RZ0sFvN+WJUTxwL0rZQPHcyyCrxsVu+EypxAzRK0Zta71_g@mail.gmail.com
Whole thread
In response to Re: Add missing stats_reset column to pg_statio_all_sequences view  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Add missing stats_reset column to pg_statio_all_sequences view
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: Xuneng Zhou
Date:
Subject: Re: Streamify more code paths
Next
From: Fujii Masao
Date:
Subject: Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row