From: Adrian Klaver <adrian.klaver@aklaver.com>
To: postggen2020 s <postggen2020@gmail.com>
To: pgsql-general@postgresql.org
To: pgsql-admin@postgresql.org
Subject: Re: Reset DB stats suggestion pg_stat_reset()
Date: Sat, 22 Feb 2020 09:17:18 -0800
Message-ID: <e9e9e02d-7df5-60e9-c101-3208716bc00d@aklaver.com> (raw)
In-Reply-To: <CAJ=omAg4ZaCpC4gaE8GM8w7vHf+gVF1z_TYCjV=koAaqaF23Cw@mail.gmail.com>
References: <CAJ=omAg4ZaCpC4gaE8GM8w7vHf+gVF1z_TYCjV=koAaqaF23Cw@mail.gmail.com>
On 2/22/20 12:26 AM, postggen2020 s wrote:
> 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.
See here:
https://www.postgresql.org/docs/12/monitoring-stats.html
Table 27.20. Additional Statistics Functions
It details what your options are.
>
> Thanks.
> Postggen.
--
Adrian Klaver
adrian.klaver@aklaver.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: adrian.klaver@aklaver.com, postggen2020@gmail.com, pgsql-general@postgresql.org
Subject: Re: Reset DB stats suggestion pg_stat_reset()
In-Reply-To: <e9e9e02d-7df5-60e9-c101-3208716bc00d@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox