Re: BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset

From: Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>
To: zlianzhuang(at)163(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset
Date: 2019-05-13 08:23:54
Message-ID: CAGz5QCK_6cDr9-2O1VwKgDT1VL56+qbYKrF8hTaDoJ=Y-4m23w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, May 13, 2019 at 12:46 PM PG Bug reporting form <
noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kuntal Ghosh 2019-05-13 08:51:42 Re: Re: BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset
Previous Message Michael Paquier 2019-05-13 08:20:26 Re: BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset