Re: Database Stats getting reset after server restart

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "Sujith Kumar(dot)S" <sujiplr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Database Stats getting reset after server restart
Date: 2020-08-17 08:38:08
Message-ID: 7692b845b77aaf4ebeb85bde6b781e356925dd21.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sujith Kumar.S 2020-08-17 09:52:44 Re: Database Stats getting reset after server restart
Previous Message dbatoCloud Solution 2020-08-17 08:29:02 Re: Database Stats getting reset after server restart