Feedback-ID: i0fe9450f:Fastmail
Date: Wed, 22 Jul 2026 07:18:33 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Fujii Masao <masao.fujii@gmail.com>, pgsql-docs@lists.postgresql.org
Subject: Re: Add "io worker" as backend_type to the pg_stat_activity
 documentation
Message-ID: <al_wOWrsHfB65Zbk@paquier.xyz>
References: <5e94c0196084f648ae6a00107125494f5804318a.camel@cybertec.at>
 <al8noIYGjD_Lyyi8@paquier.xyz>
 <eb735d8aedf16ab2121af6f9b65b3274927afd2d.camel@cybertec.at>
 <CAHGQGwEDY0GkP4Tapn+qtaxB6aNtjPzqozRL8_Hf1Sg3B+H+8w@mail.gmail.com>
 <4aff5b0f5a1bf3b487d06daec5ed5a287afa7a22.camel@cybertec.at>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="rPA+NXmbXMFi+0g3"
Content-Disposition: inline
In-Reply-To: <4aff5b0f5a1bf3b487d06daec5ed5a287afa7a22.camel@cybertec.at>
Archived-At: 
 <https://www.postgresql.org/message-id/al_wOWrsHfB65Zbk%40paquier.xyz>
Precedence: bulk

--rPA+NXmbXMFi+0g3
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Jul 21, 2026 at 09:04:15PM +0200, Laurenz Albe wrote:
> You are right.  Here is patch v3 with a completed list; I hope I didn't
> forget anything.

I am counting 23 entries.  I don't see anything forgotten on top of my
mind, and we are indeed missing a lot of new entries..  I feel that
like everybody who has added a new worker in the backend has forgotten
to update this list.=20

While on it, I also feel like we may have some holes with
log_min_messages and the new process_type.  At least a bunch of them
are missing..  I'll ping that fact on a new thread.  No need to worry
about that here.

> +         <para>
> +          <literal>autovacuum worker</literal>: A background process run=
ning
> +          <command>VACUUM</command> or <command>ANALYZE</command> on a s=
ingle
> +          table.
> +         </para>

Also active when autovacuum =3D on?

> +         <para>
> +          <literal>walreceiver</literal>: The background process that re=
ceives
> +          WAL records from a WAL sender, active in streaming replication
> +          standby mode.
> +         </para>

We can only have one of these.

> +        </listitem>
> +        <listitem>
> +         <para>
> +          <literal>walsender</literal>: A background process that sends =
WAL
> +          records to receivers (during streaming replication) or decodes=
 WAL
> +          and sends the decoded information (during logical replication).
> +         </para>
> +        </listitem>

No mention of the max_wal_senders dependency?  Perhaps not worth
mentioning, still..
--
Michael

--rPA+NXmbXMFi+0g3
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmpf8DkACgkQnvQgOdby
QH19chAAhpAEHgLxGpNn9USJSYKLqmpk/l++41FBGr57/8+Nxdq0IIYOMoDDYKeC
7nlMkqGihKmFDzVtTKEviD73t8SR28jK1aze55UZlnLTlFQlnatDJi8p/zbXKtLB
Ry26+pcpIpgl12deDCRXyUG4mdrSbxfYuUU8oF4XUHRDLcBSooGWC8+2an3dZsfj
RqIQrYVbEW1fXC2C/hq4I+SJyRzK2LKjttnwR7iSZ9JpU05vyeF8D/lTlSweYb9B
NmVNT3outCafEGPudV15EFreoVo7/dHPAjSAOdSWR4OspV5xLuhVESeMuL1UebJH
t4DTCWSf2BBwqutI6/8tqCOYN0+Vd/5/SPIcqbQIOjRAoJ1xc4Fz35d4J2oH3nem
DmosjOL9ImSvil4aeHkBCYCnVO1VzGFnc3YPoWu9V++e7+qSqGqGAHv+YkZVKt4V
nghjMPGw8b0IOH02AuXWNCUnnTrbZN1uoX5XOlCoioLOFEp99MXUxbmonQCTkP6Z
fX1vvkCQT1WeRez97rMqazYIcQauq93XHxKuImg/6AgZMecWr70k229dWb4fsREM
+mnRENQLVvGbbBXnVpkZECv7fMIwzOl3C9rws6m5L3jOsCr6wWE4FwJA2l5d7hRp
d7Y8XtSniC91hePma04JEx9X4LzOCdIz6Z0q9L8PRgPLT+xklMw=
=P4uv
-----END PGP SIGNATURE-----

--rPA+NXmbXMFi+0g3--