On 2/22/20 6:40 PM, postggen2020 s wrote:
Thanks Adrian.
I am aware about the functions. Here need is, can we use this?.or is
there any known effects after firing the functions?.
Yes the stats counters will be reset to 0, which means the planner will
not have accurate statistics to work with. That can be corrected with an
ANALYZE. The questions I have are:
What is the issue you are trying to deal with?
Also why do you think resetting the stats will fix it?
Thanks,
Postgann.
On Sat, Feb 22, 2020 at 10:47 PM Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
