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