pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: pgsql-hackers@lists.postgresql.org
Subject: auxiliary processes in pg_stat_ssl
Date: Wed, 4 Sep 2019 11:15:35 -0400
Message-ID: <20190904151535.GA29108@alvherre.pgsql> (raw)

I just noticed that we list auxiliary processes in pg_stat_ssl:

55432 13devel 28627=# select * from pg_stat_ssl ;
  pid  │ ssl │ version │         cipher         │ bits │ compression │ client_dn │ client_serial │ issuer_dn 
───────┼─────┼─────────┼────────────────────────┼──────┼─────────────┼───────────┼───────────────┼───────────
 28618 │ f   │         │                        │      │             │           │               │ 
 28620 │ f   │         │                        │      │             │           │               │ 
 28627 │ t   │ TLSv1.3 │ TLS_AES_256_GCM_SHA384 │  256 │ f           │           │               │ 
 28616 │ f   │         │                        │      │             │           │               │ 
 28615 │ f   │         │                        │      │             │           │               │ 
 28617 │ f   │         │                        │      │             │           │               │ 
(6 filas)

55432 13devel 28627=# select pid, backend_type from pg_stat_activity ;
  pid  │         backend_type         
───────┼──────────────────────────────
 28618 │ autovacuum launcher
 28620 │ logical replication launcher
 28627 │ client backend
 28616 │ background writer
 28615 │ checkpointer
 28617 │ walwriter
(6 filas)

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.)

-- 
Álvaro Herrera                                http://www.twitter.com/alvherre





view thread (8+ messages)  latest in thread

Message-ID: <20190904151535.GA29108@alvherre.pgsql>
Permalink:  ../20190904151535.GA29108@alvherre.pgsql/
Also on:    postgresql.org/message-id/20190904151535.GA29108@alvherre.pgsql

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: alvherre@2ndquadrant.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: auxiliary processes in pg_stat_ssl
  In-Reply-To: <20190904151535.GA29108@alvherre.pgsql>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox