diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-11-12 17:19:41 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2019-11-12 18:48:41 -0300 |
| commit | 5c46e7d82e88859395c2688c37bb643ae7dbbfa1 (patch) | |
| tree | a0ba6b70e22e7971be2abbf170d2230346f8f3b7 /src/backend | |
| parent | 1f55ebae27225111d0a5c4d89d7e77d917357ff4 (diff) | |
| download | postgresql-5c46e7d82e88859395c2688c37bb643ae7dbbfa1.tar.gz postgresql-5c46e7d82e88859395c2688c37bb643ae7dbbfa1.zip | |
pg_stat_{ssl,gssapi}: Show only processes with connections
It is pointless to show in those views auxiliary processes that don't
open network connections.
A small incompatibility is that anybody joining pg_stat_activity and
pg_stat_ssl/pg_stat_gssapi will have to use a left join if they want to
see such auxiliary processes.
Author: Euler Taveira
Discussion: https://postgr.es/m/20190904151535.GA29108@alvherre.pgsql
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/catalog/system_views.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 9fe4a4794a0..4456fefb38d 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -826,7 +826,8 @@ CREATE VIEW pg_stat_ssl AS S.ssl_client_dn AS client_dn, S.ssl_client_serial AS client_serial, S.ssl_issuer_dn AS issuer_dn - FROM pg_stat_get_activity(NULL) AS S; + FROM pg_stat_get_activity(NULL) AS S + WHERE S.client_port IS NOT NULL; CREATE VIEW pg_stat_gssapi AS SELECT @@ -834,7 +835,8 @@ CREATE VIEW pg_stat_gssapi AS S.gss_auth AS gss_authenticated, S.gss_princ AS principal, S.gss_enc AS encrypted - FROM pg_stat_get_activity(NULL) AS S; + FROM pg_stat_get_activity(NULL) AS S + WHERE S.client_port IS NOT NULL; CREATE VIEW pg_replication_slots AS SELECT |