Re: Vacuum statistics

From: Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Jim Nasby <jnasby(at)upgrade(dot)com>, Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, Sami Imseih <samimseih(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Andrei Zubkov <zubkov(at)moonset(dot)ru>, Andrei Lepikhov <lepihov(at)gmail(dot)com>
Subject: Re: Vacuum statistics
Date: 2026-07-13 00:58:27
Message-ID: b66b05f4-a7c6-4254-9c40-34528f0a841d@yandex.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, all!

On 18.06.2026 06:32, Alena Rybakina wrote:
>
> A few other changes in this version, beyond the five points above:
>
> * I split the patch set so that each commit introduces one category
> of statistics.
> In particular, recently_dead_tuples now lives in the same commit
> as missed_dead_tuples (patch 0003), where
> it logically belongs - both are dead-tuple counters derived the
> same way, so keeping them together makes
> the series easier to review.
> * I also changed the order in which the counters are added across
> the commits. I'm still working out the right way
> to verify the buffer statistics, timings and he frozen /
> visibility-map counters.
>
> Thanks again for the review.

I have noticed that patches need to be rebased, so I have rebased them.

I have noticed that I messed up with version indexes before and fixed it
now - added 40th versions.

--
-----------
Best regards,
Alena Rybakina
Yandex Cloud

Attachment Content-Type Size
v40-0001-Track-table-VM-stability.patch text/plain 21.7 KB
v40-0002-Extended-vacuum-statistics-core-heap-and-tuple-metri.patch text/plain 46.0 KB
v40-0003-Extended-vacuum-statistics-recently-dead-and-missed-.patch text/plain 15.6 KB
v40-0004-Extended-vacuum-statistics-WAL-metrics-and-the-sampl.patch text/plain 72.5 KB
v40-0005-Extended-vacuum-statistics-interrupted-vacuums-and-t.patch text/plain 27.5 KB
v40-0006-Extended-vacuum-statistics-visibility-map-page-trans.patch text/plain 13.7 KB
v40-0007-Extended-vacuum-statistics-total-shared-buffer-acces.patch text/plain 29.1 KB
v40-0008-Extended-vacuum-statistics-per-relation-buffer-acces.patch text/plain 17.8 KB
v40-0009-Extended-vacuum-statistics-timing-metrics-for-tables.patch text/plain 38.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2026-07-13 01:09:39 Re: [PATCH v1 0/7] Wait event timing and tracing instrumentation
Previous Message Michael Paquier 2026-07-13 00:56:05 Re: Change checkpoint‑record‑missing PANIC to FATAL