Re: Report bytes and transactions actually sent downtream

From: Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Report bytes and transactions actually sent downtream
Date: 2026-03-16 07:50:57
Message-ID: CAE9k0PmBdxB_bpWAT9V9TqkKzRCbPTOBTU3f5OtRVhZ64VKFhw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Mon, Mar 16, 2026 at 12:20 PM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>
> On Mon, Mar 16, 2026 at 08:55:17AM +0530, Ashutosh Bapat wrote:
> > I would post two patches
> > 1. To introduce the new column sent_bytes + clarify total_bytes in the
> > context of sent_bytes. We should consider this patch for committing.
>
> Sounds to me like two patches: one for the new column, a second for
> the docs of the existing columns. Could somebody send these patches?
> I would be OK to look at them once posted, driving things for this CF.
>

PFA patches:

1) v20260316-0001-Report-downstream-sent-bytes-in-pg_stat_replication_.patch:

This patch introduces sent_bytes to report the amount of data sent
downstream. It documents sent_bytes in a way that it clarifies how
sent_bytes differs from total_bytes, without modifying the existing
documentation for total_bytes or total_txns. The patch is purely
additive and does not alter any existing documentation.

2) v20260316-0002-Report-output-plugin-statistics-in-pg_stat_replicati.patch:

This patch adds a couple of more metrics to report the amount of
changes filtered out by the output plugin, as well as the total number
of transactions sent downstream.

--
With Regards,
Ashutosh Sharma.

Attachment Content-Type Size
v20260316-0002-Report-output-plugin-statistics-in-pg_stat_replicati.patch application/octet-stream 73.1 KB
v20260316-0001-Report-downstream-sent-bytes-in-pg_stat_replication_.patch application/octet-stream 26.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message wenhui qiu 2026-03-16 07:59:36 Re: Report oldest xmin source when autovacuum cannot remove tuples
Previous Message Dmitrii Bondar 2026-03-16 07:45:41 Re: Pgbench: remove synchronous prepare