Home > mailing lists

Reset DB stats suggestion pg_stat_reset() - Mailing list pgsql-general

From	postggen2020 s
Subject	Reset DB stats suggestion pg_stat_reset()
Date	February 22, 2020 11:26:15
Msg-id	CAJ=omAg4ZaCpC4gaE8GM8w7vHf+gVF1z_TYCjV=koAaqaF23Cw@mail.gmail.com Whole thread Raw
Responses	Re: Reset DB stats suggestion pg_stat_reset() (Adrian Klaver <adrian.klaver@aklaver.com>) Re: Reset DB stats suggestion pg_stat_reset() (Adrian Klaver <adrian.klaver@aklaver.com>) Re: Reset DB stats suggestion pg_stat_reset() (Michael Lewis <mlewis@entrata.com>)
List	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.

From: "Andrus"
Date: 22 February 2020, 10:43:10
Subject: Re: How to fix 0xC0000005 exception in Postgres 9.0

From: Adrian Klaver
Date: 22 February 2020, 20:17:18
Subject: Re: Reset DB stats suggestion pg_stat_reset()