| From: | "Sujith Kumar(dot)S" <sujiplr(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Database Stats getting reset after server restart |
| Date: | 2020-08-17 09:52:44 |
| Message-ID: | CACqrAMDjL+SLmP-bjRnkxPCvx4zDCtiGmumxPLP139bKfM1SxQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)albe(at)cybertec(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Firthouse banu | 2020-08-17 11:17:06 | Select query taking forever |
| Previous Message | Laurenz Albe | 2020-08-17 08:38:08 | Re: Database Stats getting reset after server restart |