Re: Vacuum statistics

Alena Rybakina <a.rybakina@postgrespro.ru>

From: Alena Rybakina <a.rybakina@postgrespro.ru>

To: Alexander Korotkov <aekorotkov@gmail.com>, jian he <jian.universality@gmail.com>, Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>

Cc: Andrei Zubkov <zubkov@moonset.ru>, Alena Rybakina <lena.ribackina@yandex.ru>, pgsql-hackers <pgsql-hackers@postgresql.org>, a.lepikhov@postgrespro.ru

Date: 2024-09-04T17:23:00Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Move wal_buffers_full from PgStat_PendingWalStats to WalUsage
- eaf502747bac 18.0 cited

Attachments

v7-0001-Machinery-for-grabbing-an-extended-vacuum-statistics.patch (text/x-patch) patch v7-0001
v7-0002-Machinery-for-grabbing-an-extended-vacuum-statistics.patch (text/x-patch) patch v7-0002
v7-0003-Machinery-for-grabbing-an-extended-vacuum-statistics.patch (text/x-patch) patch v7-0003
v7-0004-Add-documentation-about-the-system-views-that-are-us.patch (text/x-patch) patch v7-0004
minor-vacuum.no-cbot (text/plain)

Hi, all!

I noticed that the pgstat_accumulate_extvac_stats function may be 
declared as static in the pgstat_relation.c file rather than in the 
pgstat.h file.

I fixed part of the code with interrupt counters. I believe that it is 
not worth taking into account the number of interrupts if its level is 
greater than ERROR, for example PANIC. Our server will no longer be 
available to us and statistics data will not help us.

I have attached the new version of the code and the diff files 
(minor-vacuum.no-cbot).