Re: backend type in log_line_prefix?

Hi,

On 2020-02-13 09:56:38 +0100, Peter Eisentraut wrote:
> Attached is a demo patch that adds a placeholder %b for log_line_prefix (not
> in the default setting) that contains the backend type, the same that you
> see in pg_stat_activity and in the ps status. I would have found this
> occasionally useful when analyzing logs, especially if you have a lot of
> background workers active. Thoughts?

I wished for this several times.

> @@ -342,7 +342,7 @@ AuxiliaryProcessMain(int argc, char *argv[])
> statmsg = "??? process";
> break;
> }
> - init_ps_display(statmsg, "", "", "");
> + init_ps_display((backend_type_str = statmsg), "", "", "");
> }

But I'm decidedly not a fan of this.

Greetings,

Andres Freund