Postgres Pro
Downloads
Home   >   mailing lists

Re: Database Stats getting reset after server restart - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Database Stats getting reset after server restart
Date
Msg-id 7692b845b77aaf4ebeb85bde6b781e356925dd21.camel@cybertec.at
Whole thread Raw
In response to Database Stats getting reset after server restart  ("Sujith Kumar.S" <sujiplr@gmail.com>)
Responses Re: Database Stats getting reset after server restart  ("Sujith Kumar.S" <sujiplr@gmail.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: "Sujith Kumar.S"
Date:
Subject: Database Stats getting reset after server restart
Next
From: "Sujith Kumar.S"
Date:
Subject: Re: Database Stats getting reset after server restart