| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | postggen2020 s <postggen2020(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Reset DB stats suggestion pg_stat_reset() |
| Date: | 2020-02-22 17:17:18 |
| Message-ID: | e9e9e02d-7df5-60e9-c101-3208716bc00d@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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 | postggen2020 s | 2020-02-23 02:40:33 | Re: Reset DB stats suggestion pg_stat_reset() |
| Previous Message | Christopher Bartley | 2020-02-22 13:31:29 | Pay my cash app |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Richter | 2020-02-22 17:25:08 | Replication: slave server has 3x size of production server? |
| Previous Message | postggen2020 s | 2020-02-22 08:26:15 | Reset DB stats suggestion pg_stat_reset() |