| From: | postggen2020 s <postggen2020(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Reset DB stats suggestion pg_stat_reset() |
| Date: | 2020-02-23 02:40:33 |
| Message-ID: | CAJ=omAhbyW3V5vxjcHqeD9MPkGipsvJcviVEjALamwN5C2BvMg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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 <adrian(dot)klaver(at)aklaver(dot)com>
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(dot)klaver(at)aklaver(dot)com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2020-02-23 10:19:28 | Re: DB running out of memory issues after upgrade |
| Previous Message | Adrian Klaver | 2020-02-22 17:17:18 | Re: Reset DB stats suggestion pg_stat_reset() |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2020-02-23 09:06:09 | Re: How to get error message details from libpq based psqlODBC driver (regression) |
| Previous Message | Adrian Klaver | 2020-02-22 23:44:48 | Re: How to fix 0xC0000005 exception in Postgres 9.0 |