Обсуждение: Database Stats getting reset after server restart

Поиск
Список
Период
Сортировка

Database Stats getting reset after server restart

От
"Sujith Kumar.S"
Дата:
Hi Team,

After the postgresql server restart, the details on the pg_stat_all_tables are showing as zero. Does that mean the stats data also gets reset after the server restart ? How can we prevent this from happening? 

Regards,
Sujith Kumar.S

Re: Database Stats getting reset after server restart

От
Laurenz Albe
Дата:
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




Re: Database Stats getting reset after server restart

От
"Sujith Kumar.S"
Дата:
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

Re: Database Stats getting reset after server restart

От
dbatoCloud Solution
Дата:
Hi Sujith

Did you set the vacuum parameter on this table automatically?

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

UAE: Faud Al sajwani building , clock Tower , Musallah, Sharjah

M: +971 54 723 0075 | A.M. +971 50 217 9910 

W: http://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com



On Mon, Aug 17, 2020 at 12:25 PM Sujith Kumar.S <sujiplr@gmail.com> wrote:
Hi Team,

After the postgresql server restart, the details on the pg_stat_all_tables are showing as zero. Does that mean the stats data also gets reset after the server restart ? How can we prevent this from happening? 

Regards,
Sujith Kumar.S