On Mon, Apr 3, 2023 at 12:13 AM Pavel Luzanov <p.luza...@postgrespro.ru> wrote: > > Hello, > > I found that the 'standalone backend' backend type is not documented > right now. > Adding something like (from commit message) would be helpful: > > Both the bootstrap backend and single user mode backends will have > backend_type STANDALONE_BACKEND.
Thanks for the report. Attached is a tiny patch to add standalone backend type to pg_stat_activity documentation (referenced by pg_stat_io). I mentioned both the bootstrap process and single user mode process in the docs, though I can't imagine that the bootstrap process is relevant for pg_stat_activity. I also noticed that the pg_stat_activity docs call background workers "parallel workers" (though it also mentions that extensions could have other background workers registered), but this seems a bit weird because pg_stat_activity uses GetBackendTypeDesc() and this prints "background worker" for type B_BG_WORKER. Background workers doing parallelism tasks is what users will most often see in pg_stat_activity, but I feel like it is confusing to have it documented as something different than what would appear in the view. Unless I am misunderstanding something... - Melanie
From d9218d082397d9b87a3e126bce4a45e9ec720ff2 Mon Sep 17 00:00:00 2001 From: Melanie Plageman <melanieplage...@gmail.com> Date: Mon, 3 Apr 2023 16:38:47 -0400 Subject: [PATCH v1] Document standalone backend type in pg_stat_activity Reported-by: Pavel Luzanov <p.luza...@postgrespro.ru> Discussion: https://www.postgresql.org/message-id/fcbe2851-f1fb-9863-54bc-a95dc7a0d946%40postgrespro.ru --- doc/src/sgml/monitoring.sgml | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index d5a45f996d..a00fe9c6a3 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -989,10 +989,12 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser <literal>parallel worker</literal>, <literal>background writer</literal>, <literal>client backend</literal>, <literal>checkpointer</literal>, <literal>archiver</literal>, - <literal>startup</literal>, <literal>walreceiver</literal>, - <literal>walsender</literal> and <literal>walwriter</literal>. - In addition, background workers registered by extensions may have - additional types. + <literal>startup</literal>, + <literal>standalone backend</literal> (which includes both the + <xref linkend="app-postgres-single-user"/> process and bootstrap + process), <literal>walreceiver</literal>, <literal>walsender</literal> + and <literal>walwriter</literal>. In addition, background workers + registered by extensions may have additional types. </para></entry> </row> </tbody> -- 2.37.2