pgsql: Instrument freezing in autovacuum log reports.

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Instrument freezing in autovacuum log reports.
Date: 2022-09-08 17:31:01
Message-ID: E1oWLMj-0021ug-2a@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Instrument freezing in autovacuum log reports.

Add a new line to log reports from autovacuum (as well as VACUUM VERBOSE
output) that shows information about freezing. Emphasis is placed on
the total number of heap pages that had one or more tuples frozen by
VACUUM. The total number of tuples frozen is also shown.

Author: Peter Geoghegan <pg(at)bowt(dot)ie>
Reviewed-By: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAH2-WznTY6D0zyE8VLrC6Gd4kh_HGAXxnTPtcOQOOsxzLx9zog@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d977ffd923d207164eef78ed107d5293aee6c660

Modified Files
--------------
src/backend/access/heap/vacuumlazy.c | 27 ++++++++++++++++++++-------
1 file changed, 20 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2022-09-08 18:50:56 Re: pgsql: Choose FK name correctly during partition attachment
Previous Message Tom Lane 2022-09-08 15:30:04 Re: pgsql: doc: clarify recursion internal behavior