[PATCH] add relation and block-level filtering to pg_waldump

From: David Christensen <david(dot)christensen(at)crunchydata(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [PATCH] add relation and block-level filtering to pg_waldump
Date: 2022-02-24 19:02:33
Message-ID: lzzgmgm6e5.fsf@veeddrois.attlocal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greetings,

This patch adds the ability to specify a RelFileNode and optional BlockNum to limit output of
pg_waldump records to only those which match the given criteria. This should be more performant
than `pg_waldump | grep` as well as more reliable given specific variations in output style
depending on how the blocks are specified.

This currently affects only the main fork, but we could presumably add the option to filter by fork
as well, if that is considered useful.

Best,

David

Attachment Content-Type Size
0001-Add-relation-block-filtering-to-pg_waldump.patch text/x-patch 7.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2022-02-24 19:26:09 Re: [PATCH] add relation and block-level filtering to pg_waldump
Previous Message Nitin Jadhav 2022-02-24 18:53:27 Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)