Re: Database Stats getting reset after server restart

Поиск
Список
Период
Сортировка
От Sujith Kumar.S
Тема Re: Database Stats getting reset after server restart
Дата
Msg-id CACqrAMDjL+SLmP-bjRnkxPCvx4zDCtiGmumxPLP139bKfM1SxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Database Stats getting reset after server restart  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Дерево обсуждения
Yes, it's a force restart of the server. Is there any option to avoid the stats data loss after an unexpected shutdown and recovery process.

On Mon, Aug 17, 2020, 14:08 Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Mon, 2020-08-17 at 03:25 -0500, Sujith Kumar.S wrote:
> After the postgresql server restart, the details on the pg_stat_all_tables are showing as zero.

That would indicate that you didn't shut down PostgreSQL cleanly.

https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-STATS-SETUP
> When recovery is performed at server start (e.g. after immediate shutdown, server crash,
> and point-in-time recovery), all statistics counters are reset.

Consult the PostgreSQL log file for confirmation.

Yours,
Laurenz Albe

В списке pgsql-admin по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Database Stats getting reset after server restart
Следующее
От: Firthouse banu
Дата:
Сообщение: Select query taking forever