>
> 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.
>
Yes, you could reset stats every mo
On 2/23/20 10:19 AM, Adrian Klaver wrote:
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
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.
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?.
Thanks,
Postgann.
On Sat, Feb 22, 2020 at 10:47 PM Adrian Klaver
wrote:
> On 2/22/20 12:26 AM, postggen2020 s wrote:
> > Hi Team,
> >
> > Good Afternoon,
> >
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 pro
