Re: Pg_stat_user_tables

Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx> · Wed, 8 Nov 2023 15:52:01 +0530

Recently we did open shift upgrade....I have not restarted anything ..

On Wed, 8 Nov, 2023, 3:48 PM SAS, <sas.postgresql@xxxxxxxxx> 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