public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Thomas Michael Engelke <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: last_analyze/last_vacuum in pg_stat_all_tables (PG 17.10)
Date: Sun, 05 Jul 2026 15:12:57 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Fri, 2026-07-03 at 10:20 +0000, Thomas Michael Engelke wrote:
> What happens *sometimes* on servers is that the age of the oldest
> maintenance increases to infinity, as the fields of last_analyze and
> last_vacuum are emptied (NULL value).
> 
> However, looking into the monitoring system I can see that there must
> have been values in these fields before. I can see the values coming
> ouf of that check 2 hours ago, the values were not infinity.
> 
> Are there any circumstances under which these fields get emptied?

A crash of the database server would do that.

Also, if somebody calls pg_stat_reset() or
pg_stat_reset_single_table_counters('table_name'), that would reset
these counters.

Yours,
Laurenz Albe

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: last_analyze/last_vacuum in pg_stat_all_tables (PG 17.10)
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox