Re: Reset DB stats suggestion pg_stat_reset()
| От | Adrian Klaver |
|---|---|
| Тема | Re: Reset DB stats suggestion pg_stat_reset() |
| Дата | |
| Msg-id | e9e9e02d-7df5-60e9-c101-3208716bc00d@aklaver.com обсуждение исходный текст |
| Ответ на | Reset DB stats suggestion pg_stat_reset() (postggen2020 s <postggen2020@gmail.com>) |
| Ответы |
Re: Reset DB stats suggestion pg_stat_reset()
Re: Reset DB stats suggestion pg_stat_reset() |
| Список | 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.klaver@aklaver.com
В списке pgsql-general по дате отправления: