pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPg_stat_user_tables
3+ messages / 2 participants
[nested] [flat]
* Pg_stat_user_tables
@ 2023-11-08 08:42 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Rajesh Kumar @ 2023-11-08 08:42 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Pg_stat_user_tables
@ 2023-11-08 10:18 SAS <sas.postgresql@gmail.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: SAS @ 2023-11-08 10:18 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Pg_stat_user_tables
@ 2023-11-08 10:22 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
parent: SAS <sas.postgresql@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rajesh Kumar @ 2023-11-08 10:22 UTC (permalink / raw)
To: SAS <sas.postgresql@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-11-08 10:22 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-08 08:42 Pg_stat_user_tables Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-11-08 10:18 ` SAS <sas.postgresql@gmail.com>
2023-11-08 10:22 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox