Reset DB stats suggestion pg_stat_reset()

From: postggen2020 s <postggen2020(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Reset DB stats suggestion pg_stat_reset()
Date: 2020-02-22 08:26:15
Message-ID: CAJ=omAg4ZaCpC4gaE8GM8w7vHf+gVF1z_TYCjV=koAaqaF23Cw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi Team,

Good Afternoon,

We have seen some deadlocks and tempfile count in pg_stat_database view. We
are trying to reset the stats.
Can we use pg_stat_reset() function to reset these stats without any impact
stats of databases.
Please advise the process to reset the stats.

Thanks.
Postggen.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Bartley 2020-02-22 13:31:29 Pay my cash app
Previous Message Scott Ribe 2020-02-21 14:53:54 Re: benchmarking proposed config

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-02-22 17:17:18 Re: Reset DB stats suggestion pg_stat_reset()
Previous Message Andrus 2020-02-22 07:43:10 Re: How to fix 0xC0000005 exception in Postgres 9.0