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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1iRcN0-0001sI-K7
	for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Nov 2019 13:26:10 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1iRcMy-0000e5-Mm
	for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Nov 2019 13:26:08 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1iRcMy-0000dy-E9
	for pgsql-hackers@lists.postgresql.org; Mon, 04 Nov 2019 13:26:08 +0000
Received: from mail-qt1-x829.google.com ([2607:f8b0:4864:20::829])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1iRcMu-0004Bo-5I
	for pgsql-hackers@lists.postgresql.org; Mon, 04 Nov 2019 13:26:07 +0000
Received: by mail-qt1-x829.google.com with SMTP id l24so5564374qtp.10
        for <pgsql-hackers@lists.postgresql.org>;
 Mon, 04 Nov 2019 05:26:03 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=k1pBwcuNhLxbWnnao9XXslWiPcsSwDVb8vG3uizHVp0=;
        b=d1PKWgTfi16tg/gIAsFKICN7wySxM6kyJFgL/DcIyq4pSDKDtgh1mI499vbp0ZCvTJ
         K1wRS2cTxwDN66rD3aDvmZMuA3VqGsH/7CpEO2ZRC9hInY6KiqDFSOt8L3ovuBJWsKxE
         0K/OACVwmgFEk/M1dIFAN3C1gttRMAYSd8ds+zYtydsR3zpQYOjoIZww5rwVavST8Nc7
         hkMWjfG/8qsX/RbOXgfPzC67w9TpfHShvQyHPTmfELvTxwcyhd09MxF2TVDbrdh9lalv
         KU5ZSSQ/tjKal18YUbuVQZzjnZ0nCtB9rHEro9TeoZaa+5Jqv1c6HfPL0Z7pTf3ikLw0
         tDjQ==
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:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=k1pBwcuNhLxbWnnao9XXslWiPcsSwDVb8vG3uizHVp0=;
        b=q6O2ZlGojKaaJdoZNPQCF0vupJbkNC9rsfQoZimEFeTG2zSaZ9tD0gw+Ayn6eAUkw8
         m3JFfF2nX3pH/NMYSbIfsA2f6Op7v3TDK2jzy9puY1dUDjgM9KGsEgOkceGUozhNNtBo
         F6gLSfv4CixCe+cFoqlWRV14ru4mgykQOkJcp9Y+VwKVHwlzRQ2q6AmEx5YST7+LfSGC
         MNY7uj7F3jdtAq6dRdfZ1HNqe/DddPjhipvuxHed9nRE3rVeKpBdyFHqLdNPgCVJ2MFI
         PEXSleDwmlLenJiA64ilfLXQMD1qBo9AWWqaik3v1Ijbrbx0BYIU103eGjGZyOmXQj2e
         oLWw==
X-Gm-Message-State: APjAAAXR/LSmpGt56/BKCZOXJAh+m4oyPg+z951PqpSRoNLaT7c7iLrX
	lZ8x55RaVLR7TTQtl567IjOH7g==
X-Google-Smtp-Source: 
 APXvYqzduh1SIA+nHNfb9YLZJbTHj/XA0uWsvm4a3jIXZJ9T9WSaKjyKLj4NF942w89aUiIsIQWPzQ==
X-Received: by 2002:aed:3225:: with SMTP id
 y34mr12335136qtd.353.1572873962098;
        Mon, 04 Nov 2019 05:26:02 -0800 (PST)
Received: from nimloth.alvh.no-ip.org ([179.56.30.174])
        by smtp.gmail.com with ESMTPSA id
 b54sm11530131qta.38.2019.11.04.05.26.01
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Mon, 04 Nov 2019 05:26:01 -0800 (PST)
Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000)
	id 77C68300AB1; Mon,  4 Nov 2019 10:25:59 -0300 (-03)
Date: Mon, 4 Nov 2019 10:25:59 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Robert Haas <robertmhaas@gmail.com>,
	Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Subject: Re: auxiliary processes in pg_stat_ssl
Message-ID: <20191104132559.GA18441@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20190904151535.GA29108@alvherre.pgsql>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

On 2019-Sep-04, Alvaro Herrera wrote:

> I just noticed that we list auxiliary processes in pg_stat_ssl:
[...]
> But this seems pointless.  Should we not hide those?  Seems this only
> happened as an unintended side-effect of fc70a4b0df38.  It appears to me
> that we should redefine that view to restrict backend_type that's
> 'client backend' (maybe include 'wal receiver'/'wal sender' also, not
> sure.)

[crickets]

Robert, Kuntal, any opinion on this?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services