Re: BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset - Mailing list pgsql-bugs

From Kuntal Ghosh
Subject Re: BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset
Date
Msg-id CAGz5QCK_6cDr9-2O1VwKgDT1VL56+qbYKrF8hTaDoJ=Y-4m23w@mail.gmail.com
Whole thread Raw
In response to BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Mon, May 13, 2019 at 12:46 PM PG Bug reporting form <noreply@postgresql.org> wrote:

pg_stat_reset_single_table_counters/pg_stat_reset_single_function_counters
only update pg_stat_database column stats_reset.
stat_reset shuld update when all the column is reset.
pg_stat_reset_single_table_counters resets the stats of a single table. From your example, it resets the following stats:

select * from pg_stat_all_tables where relid='lzzhang_tab'::regclass::oid;
 
It'll not reset the database statistics.

--
Thanks & Regards,
Kuntal Ghosh
EnterpriseDB: http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #15801: pg_stat_database update stats_reset only bypg_stat_reset
Next
From: Kuntal Ghosh
Date:
Subject: Re: Re: BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset