BUG #18046: stats collection behaviour change is affecting the usability of information.

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18046: stats collection behaviour change is affecting the usability of information.
Дата
Msg-id 18046-9263842a9ec688e0@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18046: stats collection behaviour change is affecting the usability of information.
Список 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 по дате отправления:

Предыдущее
От: "Zechman, Derek S"
Дата:
Сообщение: RE: pg_hba.conf "authentication file token too long, skipping"
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1