Postgres Pro
Downloads
Home   >   mailing lists

Re: Pg_stat_user_tables - Mailing list pgsql-admin

From Rajesh Kumar
Subject Re: Pg_stat_user_tables
Date
Msg-id CAJk5AtY2p1MU2hi4bLJp6RXiHBrud2JUJHfDkDF=+ryDdxAs0A@mail.gmail.com
Whole thread Raw
In response to Re: Pg_stat_user_tables  (SAS <sas.postgresql@gmail.com>)
List pgsql-admin
Tree view
Recently we did open shift upgrade....I have not restarted anything ..

On Wed, 8 Nov, 2023, 3:48 PM SAS, <sas.postgresql@gmail.com> wrote:
Le 08/11/2023 à 09:42, Rajesh Kumar a écrit :
Hi, using postgres 15 on openshift container.

I am doing vaccum analyze and checking the timestamp for last analyze and last vaccum. It shows the time.


Later after some period, the timestamp is not there for both last vaccum and last analyze. Is that a problem? Why is it getting erased.


Regards,
Raj

Good morning,

Have you restarted your container between the 2 queries on pg_stat_user_tables, or have you reset the statistics ?
Where are data stored ?

S.

--
Dr Stéphane Schildknecht
Contact régional PostgreSQL pour l'Europe francophone
+33 617 11 37 42

pgsql-admin by date:

Previous
From: SAS
Date:
Subject: Re: Pg_stat_user_tables
Next
From: SAS
Date:
Subject: Re: Not able to connect specific database