BUG #18046: stats collection behaviour change is affecting the usability of information. - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18046: stats collection behaviour change is affecting the usability of information.
Date
Msg-id 18046-9263842a9ec688e0@postgresql.org
Whole thread Raw
Responses Re: BUG #18046: stats collection behaviour change is affecting the usability of information.  (Hamid Akhtar <hamid.akhtar@percona.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18046
Logged by:          Jobin Augustine
Email address:      jobinau@gmail.com
PostgreSQL version: 15.3
Operating system:   CentOS/RHEL
Description:

After stats collection changes in PG 15, The behaviour stats_reset
information is changed. which is adversely affecting the usability of data
presented in the view.
```
select stats_reset from pg_stat_database;
```
Before PG15, stats_reset was always populated so that the user knows the
cumulative values presented are of how many days.
But unfortunately, PG 15 keeps it null unless there is an explicit reset
(pg_stat_reset). The value goes again null if there is a reset due to a
crash. 
So on a regular system, the User can't understand the cumulative values
presented in the view.


pgsql-bugs by date:

Previous
From: "Zechman, Derek S"
Date:
Subject: RE: pg_hba.conf "authentication file token too long, skipping"
Next
From: Amit Kapila
Date:
Subject: Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1