Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j2AZy-0001Dj-N0 for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Feb 2020 09:14:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j2AZx-0005xC-7Z for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Feb 2020 09:14:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j2AZw-0005wx-Ph for pgsql-hackers@lists.postgresql.org; Thu, 13 Feb 2020 09:14:37 +0000 Received: from mail-lj1-x233.google.com ([2a00:1450:4864:20::233]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1j2AZu-0000jY-MY for pgsql-hackers@postgresql.org; Thu, 13 Feb 2020 09:14:35 +0000 Received: by mail-lj1-x233.google.com with SMTP id y6so5725301lji.0 for ; Thu, 13 Feb 2020 01:14:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=4nKIQjDVXDKJ7/iwtQ9QuIwNz5Y7otFN9p671JM1sUs=; b=ZrzM9vrD0YSAAv9D3AZ8aKf4CfhR/23Zbo0vu7PYdCPP46XuX+dz5Ifrxp74tmSv1l bmxXrenq45wzdUrPq+micq5Veww7wDWhecjbUX/srW/pdqkvo0ru3SdeUVwrkj68YYGl +ZAvDCDZIs0hyiUw1Z3dhzfMs3sZIxNcXr0eOP8jkT9fc/pZCl4iQiYXPthy9AnfW+0z geY8imRD7/tGiR9TQIJ4JN90o1bElFs8ZOrEQV+ME2m91YjlIIkhfYk9U0aCsoM8vw4T QnUbV9QpRyGDVp38iBL6CEBSwfIhK2ng6QHrPokoBlST55WAS9nLQh92XZGTRe3C1peq Mnqw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=4nKIQjDVXDKJ7/iwtQ9QuIwNz5Y7otFN9p671JM1sUs=; b=ig//njiozfxq7XL4pZ9zen5/jwK7doWacReEsFwVtaGp+Qf0uvYxvssNMZryx96IPQ RRyAdb1wj5u47pgUeWWHl5gLJg/ZjXflG2Nde1DUvBw0Xk6wOyW2KIeeAyxSRqm33U14 9tTbKGpM5p4pk8slqJi361Ly0VVNvvJ0TsHTSXaBC+PNMajVfr0mBw99PmiYTR0r6Ub5 xt7HGbgDJp+EwXmhTv6nCF8s8nWdFHJG+EBhAYOyMR09v856BNvpqiYr5HrgVEf80ukJ HQ+CrFScuMi1wAH+4oFOxOb1KBTs4z5BPT/5HBVI0yVZmyhlvxr4L0PZAZ3igCdMArfG UWJA== X-Gm-Message-State: APjAAAV5oM6NJXwiPi0B57WDL4XXzSz347gJYyEelGzkHL1VYNkAEM54 0gsGJk+/xF/nunixDzOkP4E= X-Google-Smtp-Source: APXvYqyZxeoKQBl1+58VE/ddoNAskh6RQrCd6ey1+fqUhT7GfPvR+yQOBoMmElqNJaZposBEJ9hsGg== X-Received: by 2002:a2e:81c7:: with SMTP id s7mr10584620ljg.3.1581585272213; Thu, 13 Feb 2020 01:14:32 -0800 (PST) Received: from nol (82-64-124-11.subs.proxad.net. [82.64.124.11]) by smtp.gmail.com with ESMTPSA id k24sm1283242ljj.27.2020.02.13.01.14.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 13 Feb 2020 01:14:31 -0800 (PST) Date: Thu, 13 Feb 2020 10:14:28 +0100 From: Julien Rouhaud To: Peter Eisentraut Cc: pgsql-hackers Subject: Re: backend type in log_line_prefix? Message-ID: <20200213091428.GA15600@nol> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Feb 13, 2020 at 09:56:38AM +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? +1, I'd also have been happy to have it multiple times.