Re: auxiliary processes in pg_stat_ssl

Alvaro Herrera <alvherre@2ndquadrant.com>

From: Alvaro Herrera <alvherre@2ndquadrant.com>

To: Euler Taveira <euler@timbira.com.br>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2019-11-12T21:49:33Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

pg_stat_activity: document client_port being null
- c5e8ea978d88 13.0 landed
pg_stat_{ssl,gssapi}: Show only processes with connections
- 5c46e7d82e88 13.0 landed

On 2019-Nov-04, Euler Taveira wrote:

> Yep, it is pointless. BackendType that open connections to server are:
> autovacuum worker, client backend, background worker, wal sender. I
> also notice that pg_stat_gssapi is in the same boat as pg_stat_ssl and
> we should constraint the rows to backend types that open connections.
> I'm attaching a patch to list only connections in those system views.

Thanks!  I pushed this.

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