Content-Type: multipart/alternative;
 boundary="------------tfGmELpeNzDpZ4vEJpxE4EqE"
Message-ID: <4572cb26-c7c9-4228-afdc-3eb6b9e35fed@gmail.com>
Date: Wed, 8 Nov 2023 11:18:44 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Pg_stat_user_tables
To: pgsql-admin@lists.postgresql.org
References: 
 <CAJk5AtaWjQ3KaGASf5zDLwZw+ptw7bOVtLCgjyB31fo-a1d+pQ@mail.gmail.com>
Content-Language: fr, en-US
From: SAS <sas.postgresql@gmail.com>
Autocrypt: addr=sas.postgresql@gmail.com; keydata=
 xsFNBF1TwC8BEADzdG8ZReoeRLmPqB5Y8GFlu2Rf9RhUqHz7/aK4V07aC2rIN/AtmHd/MiqO
 dqXJ695qODcFGWwXZHnlgjZy5adgzviG06DTzqtFm0hLDglgBrfjQWKnhaYARRsNltMYL+eh
 lzDtkqI7mY6pPWQJ0vRwm/2S8HyWVPpM/kAgZdGqmdmh+ks6bNXPXqF+nIcbmWBQKwEjoSQN
 s36mIU0ZRLJnFJfMsK006TqwzEGIufrQ9OKNmEbKlFU+PHE4ro9lK19yXl/KwMjFavO5t7qF
 DT7f7fXOoFulxOHFSY6FdKe33mXVAI/6DSRi3QFtXsME/apaFeFluUCoBFmKzoe4Kat6Wr3L
 GFMI0uCLGXy9VXAKuhcIVqU3AVfJtJmnM4sty/693FcnfpoRjPkgln0XCw1lj5I9JQOwq+R7
 IGdPVVzK3QzFHPRAvVF7pha175AeE2UyfdvCIM8fBp2T3Tit6AfkxyM+6vi5T5O3lE5+XecZ
 RqrTlnUMGxSMb55/mruhqo4mV1CHQRVBPqxwHcuEQcthsepRgvyVpAoYkI6OitUoYsGIbMql
 A00egksR0V+6zjWpx+G8gDXuPGxL2JNBg1yb/jvygww1A4VrnwqS5nmKiVIOXYgML+U7rn13
 gouTaiwjDCNESVcWhxmQoiAofPauMM5itGAFHIbmSkFNmA7IiwARAQABzR5TQVMgPHNhcy5w
 b3N0Z3Jlc3FsQGdtYWlsLmNvbT7CwZQEEwEKAD4WIQQYFCr7KOpZp+rWJwjdRfi2pUecIQUC
 XVPALwIbIwUJCWYBgAULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRDdRfi2pUecITcOEAC7
 woia7Z8+OhrqtMfkCwGqVzWGw70Er1uDqifUy4RU15zvkQTkpN6UA9nPZFRT+sGiQxEt3gb+
 Oj4d/SY24GUPaK2viEG6Cfd/VyjT0KKs2ScR0c1Oka3R1czhHcCTc4oR/WcAUQW1ld28MSAk
 zYlrGH4P1FsbMpqH+QAC+KKBaIr+/E9DQbH9lgOViI+AYKoLsbz5HCTmUHZ52/njtFDkvZdv
 ihdx4kJ9Kt7J5mWxWr2f0wIClCqWouDubdRwRxSGLM1a/ivHtEl3rz2eJoLbj1SS//28Nqw0
 rPRd10ZNoWoyWpmbcw83JL8lDkMU9RmrN+PJypCBj3nUOKglcPB0dCfsKtaHbH+qtHTfFm9p
 m/07IrqTW1gOx4z2wOpuiAh4Fdy8SatoNpm6PF3T/2V2ckXlx6GqDhDeLChsinQK6VXLQbYO
 e3WPTSrREVdFgv97NlzRIY9vGBUd8EOm2YX3nRDkwLbWsqPXjiUFizR1V8EvdzzLLYmUmIyU
 HhdYecCZIzY9U6XfkXvLfBttrRSpqQ1ZCFdvuZzRN5R9Vy7O4Rxat8RyH/4D3oena43ypfbk
 ajIlrRi7ElzXJ3YIC4lq/+q12Q+We6a62nUpI8+xNpDV/qzD8jjWcfDSkrml5QWpYoRZrbJo
 VqUZDRX8mN3V59Nvw1rncXLPsOMnlt3lcc7BTQRdU8AvARAA0xCon2NJFabIdSaBAG8Qy2cJ
 MfTY6coSgQbx0EFv+P+SJc5x97QaefMr/bgkf/AYfpREi65spov8uEnn6IXWH+u+Y48/U1xU
 YsakBr2TzFDKhB8RkMuCVo+BJyahm9WlVLFWNJI7GfGeni772aI310peXBlTCDGKop1QZfAp
 IVSr7jTqNcYED/P6L2S3agiaY1HyQceGwQeJsDywrUaBzTDFg9nXHLzpdrrxUDsVOoB/4A/r
 lWtCAGnjDnOaaVkpwRjzdGaU+ed+yz13yvKjuDbDy/3EVQKUkbq6JOUuxnEhQyp1MFhTkolV
 eIS/MuToWikHzlMFAC6YZDilklnLR0GRJcRiYlLenuYwr8z3gdyuDUQ3bcCdaaIUS2M4CqzR
 1v/x9JiAIOyoEK8CXtwn9pSb/AGia0PDXyh09gn7WGyNyCrGK7vJyheLbuxIdv2czRxfvoVT
 woaXi1jVJP72j/e3OyZku/1FBmvP2x/DZSYN2+WESRxL1/WjdvvXQ8mXDrCJkoA8yQQzN5aR
 6StToPaJ4b0iIIrpqy0is2RLYccQN+5QhrG1x17TmpmaDgJK5XWSeTssraDntx5GTM/gz87j
 hot90StLYQxEcPUGij04WV+iy7r+NG1kruRwkK7ZE0H8hUyVeGBgkmBOWrc1p2v8fKI19oTL
 bKHbAQCgVz0AEQEAAcLBfAQYAQoAJhYhBBgUKvso6lmn6tYnCN1F+LalR5whBQJdU8AvAhsM
 BQkJZgGAAAoJEN1F+LalR5whRRQQAIkuq64fKnArkyTp/rWtzAn9uQ9cPVqKcol2lLaaUY97
 q0ZSefPliz4qpz4CPfQNDTCngSdBgfDLKTuuKLthHe5IgZwUiw1AA+reF7PP+HKGzVv5pqqz
 uIQJwY8xTnIuyL78JhN4Z4Mihism/iufT2MleKzUNSGr8RjASdvHTwFnAqQN7FevNK4QoCRm
 i0da9ZuJh7t0LDFtV+IysaOFvE9//gXATvnBZzQ8/TkAPaJ+Y/yWlSlKtekxhWxMxayID0Zi
 /Om90DYveRVadck6x52jvt1HEu2v5XtXIUmdjM3qaaKrPIRuMrox5vR9K6EouUndSd1/pw2Y
 1mILzogeO133yeqVf4aw9740PT51kMowCt2dj5AegYq3hBXYCv51OO0B1pM+pyDwVbgD2iif
 /rpyRPWZMk0RxmeUfH+wOIztfdtr1iMcJzYD62EuXE4DH4Bi2x0pwqPvFxbzt0V4qq7Nc8jf
 ThgKrUbfLrfcMrjdqPLnYj+EDfNrVVYqoz4Q/xjPvCiV42N1CLeUyDwm+TYrKyW+ax16XxjK
 PMnLozdWEiJ8bz3N8FYax6AfzSGGY2/BCpygnmWQAvDodZQNBnFn37aGiarLEZaUCCDsxQrx
 SK/28CU01eH1Ws5rCS5FsdNbmYQlHHYPVpXdZcA8hbnZ3BirRV88KlDcgrA2eCO8
In-Reply-To: 
 <CAJk5AtaWjQ3KaGASf5zDLwZw+ptw7bOVtLCgjyB31fo-a1d+pQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/4572cb26-c7c9-4228-afdc-3eb6b9e35fed%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------tfGmELpeNzDpZ4vEJpxE4EqE
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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

--------------tfGmELpeNzDpZ4vEJpxE4EqE
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Le 08/11/2023 à 09:42, Rajesh Kumar a
      écrit :<br>
    </div>
    <blockquote type="cite"
cite="mid:CAJk5AtaWjQ3KaGASf5zDLwZw+ptw7bOVtLCgjyB31fo-a1d+pQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="auto">Hi, using postgres 15 on openshift container.
        <div dir="auto"><br>
        </div>
        <div dir="auto">I am doing vaccum analyze and checking the
          timestamp for last analyze and last vaccum. It shows the time.</div>
        <div dir="auto"><br>
        </div>
        <div dir="auto"><br>
        </div>
        <div dir="auto">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.</div>
        <div dir="auto"><br>
        </div>
        <div dir="auto"><br>
        </div>
        <div dir="auto">Regards,</div>
        <div dir="auto">Raj</div>
      </div>
    </blockquote>
    <p><font face="Lato">Good morning,</font></p>
    <p><font face="Lato">Have you restarted your container between the 2
        queries on pg_stat_user_tables, or have you reset the statistics
        ? <br>
        Where are data stored ?</font></p>
    <p><font face="Lato">S.<br>
      </font></p>
    <div class="moz-signature">-- <br>
      <div>
        <div><font color="#00aee6">Dr Stéphane Schildknecht</font></div>
        <div>Contact régional PostgreSQL pour l'Europe francophone</div>
        <div>+33 617 11 37 42</div>
        <br>
      </div>
    </div>
    <div id="grammalecte_menu_main_button_shadow_host"
      style="width: 0px; height: 0px;"></div>
  </body>
</html>

--------------tfGmELpeNzDpZ4vEJpxE4EqE--