Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit5c46e7d

Browse files
committed
pg_stat_{ssl,gssapi}: Show only processes with connections
It is pointless to show in those views auxiliary processes that don'topen network connections.A small incompatibility is that anybody joining pg_stat_activity andpg_stat_ssl/pg_stat_gssapi will have to use a left join if they want tosee such auxiliary processes.Author: Euler TaveiraDiscussion:https://postgr.es/m/20190904151535.GA29108@alvherre.pgsql
1 parent1f55eba commit5c46e7d

File tree

3 files changed

+9
-5
lines changed

3 files changed

+9
-5
lines changed

‎src/backend/catalog/system_views.sql

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -826,15 +826,17 @@ CREATE VIEW pg_stat_ssl AS
826826
S.ssl_client_dnAS client_dn,
827827
S.ssl_client_serialAS client_serial,
828828
S.ssl_issuer_dnAS issuer_dn
829-
FROM pg_stat_get_activity(NULL)AS S;
829+
FROM pg_stat_get_activity(NULL)AS S
830+
WHERES.client_portIS NOT NULL;
830831

831832
CREATEVIEWpg_stat_gssapiAS
832833
SELECT
833834
S.pid,
834835
S.gss_authAS gss_authenticated,
835836
S.gss_princAS principal,
836837
S.gss_encAS encrypted
837-
FROM pg_stat_get_activity(NULL)AS S;
838+
FROM pg_stat_get_activity(NULL)AS S
839+
WHERES.client_portIS NOT NULL;
838840

839841
CREATEVIEWpg_replication_slotsAS
840842
SELECT

‎src/include/catalog/catversion.h

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO201910251
56+
#defineCATALOG_VERSION_NO201911121
5757

5858
#endif

‎src/test/regress/expected/rules.out

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1845,7 +1845,8 @@ pg_stat_gssapi| SELECT s.pid,
18451845
s.gss_auth AS gss_authenticated,
18461846
s.gss_princ AS principal,
18471847
s.gss_enc AS encrypted
1848-
FROM pg_stat_get_activity(NULL::integer) s(datid, pid, usesysid, application_name, state, query, wait_event_type, wait_event, xact_start, query_start, backend_start, state_change, client_addr, client_hostname, client_port, backend_xid, backend_xmin, backend_type, ssl, sslversion, sslcipher, sslbits, sslcompression, ssl_client_dn, ssl_client_serial, ssl_issuer_dn, gss_auth, gss_princ, gss_enc);
1848+
FROM pg_stat_get_activity(NULL::integer) s(datid, pid, usesysid, application_name, state, query, wait_event_type, wait_event, xact_start, query_start, backend_start, state_change, client_addr, client_hostname, client_port, backend_xid, backend_xmin, backend_type, ssl, sslversion, sslcipher, sslbits, sslcompression, ssl_client_dn, ssl_client_serial, ssl_issuer_dn, gss_auth, gss_princ, gss_enc)
1849+
WHERE (s.client_port IS NOT NULL);
18491850
pg_stat_progress_cluster| SELECT s.pid,
18501851
s.datid,
18511852
d.datname,
@@ -1964,7 +1965,8 @@ pg_stat_ssl| SELECT s.pid,
19641965
s.ssl_client_dn AS client_dn,
19651966
s.ssl_client_serial AS client_serial,
19661967
s.ssl_issuer_dn AS issuer_dn
1967-
FROM pg_stat_get_activity(NULL::integer) s(datid, pid, usesysid, application_name, state, query, wait_event_type, wait_event, xact_start, query_start, backend_start, state_change, client_addr, client_hostname, client_port, backend_xid, backend_xmin, backend_type, ssl, sslversion, sslcipher, sslbits, sslcompression, ssl_client_dn, ssl_client_serial, ssl_issuer_dn, gss_auth, gss_princ, gss_enc);
1968+
FROM pg_stat_get_activity(NULL::integer) s(datid, pid, usesysid, application_name, state, query, wait_event_type, wait_event, xact_start, query_start, backend_start, state_change, client_addr, client_hostname, client_port, backend_xid, backend_xmin, backend_type, ssl, sslversion, sslcipher, sslbits, sslcompression, ssl_client_dn, ssl_client_serial, ssl_issuer_dn, gss_auth, gss_princ, gss_enc)
1969+
WHERE (s.client_port IS NOT NULL);
19681970
pg_stat_subscription| SELECT su.oid AS subid,
19691971
su.subname,
19701972
st.pid,

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp