Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wm5RB-000Zzu-1r for pgsql-docs@arkaria.postgresql.org; Tue, 21 Jul 2026 08:02:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wm5RB-006PhZ-0Z for pgsql-docs@arkaria.postgresql.org; Tue, 21 Jul 2026 08:02:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wm5RA-006PhQ-33 for pgsql-docs@lists.postgresql.org; Tue, 21 Jul 2026 08:02:48 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wm5R8-00000001Eoq-0gEW for pgsql-docs@lists.postgresql.org; Tue, 21 Jul 2026 08:02:47 +0000 Received: from phl-compute-10.internal (phl-compute-10.internal [10.202.2.50]) by mailfout.phl.internal (Postfix) with ESMTP id 3BCDDEC0104; Tue, 21 Jul 2026 04:02:46 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-10.internal (MEProxy); Tue, 21 Jul 2026 04:02:46 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1784620966; x=1784707366; bh=1/oB38DC32 8x/w60SKbXHC2XGnlf70fUGwLMIc0vxDw=; b=WG12+d0n9mR+G4dWJxHmXTunWZ IY7uGRo2focENXSL8X9m6QHmOljd/bWSuwJt2rMMG31bVobZ/r8Yyf9rsPL0w5+d 52hCWonaQzk6ZidCb4Vx4E+8Yn9lisbjxpSSfpxwlz/wq7INq/K6ZZbNS/Q0nc2J bn430yweZe87Kfqyq1sVLg2xfs+0hcIUB5xsA3K37mcPSdZ6HQTgAyEX9ZxKzv6p YnJL1JYDHTta9xoHSjknNPbeerhsFB6puFHX7lS1M7XTLm0J8waIjtx3WkeSlcXh rWU9YPrs5N8pX57jiuPj+kNduinp6WvxqsEjj23jcWo6bDe93Ws1DE/zTG/A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1784620966; x=1784707366; bh=1/oB38DC328x/w60SKbXHC2XGnlf70fUGwL MIc0vxDw=; b=KExE323KnHNcWgIJpIbNdBf0gf3ENX3mj9IXKkPfBKr867mnvgt WTuuoz2zoxeQHZQfJldUQoE8YNOL8bdcVwwGzk+wvRYVLH3WRZu3VxEybYYFAhor 5owrEPwSLXKPFYZEVZWacQw516g+IJQWuyGqWgbF8FYHnD3QE/6h0nMYsiB/n7Sz HZktG+2a7KenI1Unj3SAStnezyOtDzrz/kU114vjeE18oqrRV2pF3HZDkiBXPktt 7H2O/9XxCrLyFfncppBRRpjTZUA+iR2B2j2OfXDM6zuUVOSztv8I+rfnUCF1//aK dgU9xIYdMmFhxDC5QoAk5ISzsqxEKb0SBbg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTEeZJty5NbVN8LFdUUf1gSPO4oQFR0oX+hOOurrrTWorW5Zd1sNjd0lRUds7wmyJw 1MC9WVFaGei14oAGCfmyPjYPjYdvUbGq/UqVNIRhIqjcUGWoJj6B7RB9ZhAyvMVX2S1nJE efWd3lqRthqX/5v3tI2scUdFNz9CwZbZQkbXKjJVAyksRRSf1oCnKsO4kkn5XBmA6EtrYr iWbnXxPN/vDuNQLSk0SJqMXRWgTuDHPovlU1B0TpZlonH4s+p2IiUtX9hrm7Tii/mNhzyw LluRdDb30EhwQjFP/jpb1MKDPuc71J4leviX6zVdtMxxp3dptUVfSrAucun4PIWt48+sE9 hQrPNLarkN0IADzgLLKtQnKQhNoA7ugjHFh80zEbvTA2rwIzsp2YcnMw85XD1IQCfPRHFB WSslEzdW8G9CBSOjS1aik4Rb/F/TleNAsDZDNdZ1XyNpxbhq4fg9MzWKQL9T5OMZeAlY+C Tea44vPY10sLuFRrDshtWlXOxWa0mamQYrJBlhetVrpLxcUILFsytsSubQemk30wufuMmo oVD5Ryt9/de5GfjtomQxQVTg1TFGsYjuJhKeRZBH3daUhNp7FkvqdCjOXPSwbpZGx35WkA IUCH+RZ4qILsg4YW17/l5QmBSu4Y3u/bEx+QeAkPKfb+C3IW1Wm9xtzazHvA X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 21 Jul 2026 04:02:44 -0400 (EDT) Date: Tue, 21 Jul 2026 17:02:40 +0900 From: Michael Paquier To: Laurenz Albe Cc: pgsql-docs@lists.postgresql.org Subject: Re: Add "io worker" as backend_type to the pg_stat_activity documentation Message-ID: References: <5e94c0196084f648ae6a00107125494f5804318a.camel@cybertec.at> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="k2AvhRVzRFDOtZhQ" Content-Disposition: inline In-Reply-To: <5e94c0196084f648ae6a00107125494f5804318a.camel@cybertec.at> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --k2AvhRVzRFDOtZhQ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Jul 21, 2026 at 09:58:34AM +0200, Laurenz Albe wrote: > I happened to notice that "io worker" was missing in the list of > backend types in the pg_stat_activity documentation. Right. > Here is a patch to fix that. >=20 > I wondered vaguely if the list should be sorted alphabetically, > but didn't do it a) to keep the patch easy to read and > b) because the list is not long enough for readers to get lost. And here I just thought while looking at this section of the docs that the list is super long, and that we could reshape it the same way as "state" for the possible values, sorting it on the way. -- Michael --k2AvhRVzRFDOtZhQ Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmpfJ6AACgkQnvQgOdby QH1XkA//bqQv5tz377g21Uwur/SFI4tUNfIVl60S1jerYqHS4lN4X3MUqih9oQgC Q4P6HkPpmJ1hfKIdSuhCyloJLl2OraKpXwzoTquwX3ETRXSm+Z3MLrnMUJEEpvZ1 d6Z8ar8AbOnuVAWhSO9wN+lw1IXhAzfXuMb88dwkMMvyNcKUueI31fzUZ8BKy7VY YwPdB5/KD0PI7I73hGhYNoPVFTb5UelJ7Eam6Icy/+RLzmvVQIG3XqLUR3j2SynQ LaSB9ZA9ei/j8/x6Hsi2BIP+kda/vExahaahGzwy8lDIqKBwBqtZuOBXHwgMQ/iK weCBHq/ahL2NlhVnhX/kqaDV8MOuQxwQbySVzTo5L51DMKpMT26Z6wfG/gZrIBvh tpuaRT4jeExTgXCLWJyJqRd1xrGqjt7l1XOagP2GaLzjrnZHXkUYN7UNyoy+Yccq ZGqKd4ZJKMc9e6uD1jp4g1Jm3cfGSVvdrXc/zfpuHOJOV8gODMwKaqS25IDkAtPk VPBxrWbWy4IqBlyWdYBc7ZgEu5EPZZKBfu+zr73gVHat2mUnNoilfl7ccWw8Cz+2 8D/nGVWDVANEFEE0xkM6cB5a8svu57aM7wcy3K58+LOWDXHuuzaeAUjKV1/B4JGN zvf6OQc3B+fcLRdC/wABbJb/HlLhLjzxiHhvipr8qiLs10Ov63Q= =D8/7 -----END PGP SIGNATURE----- --k2AvhRVzRFDOtZhQ--