{"Entry":{"collection":"metric","key":"pg_stat_ssl-client_dn","name":"pg_stat_ssl.client_dn","aliases":["client_dn","pg_stat_ssl"],"metadata":{"aliases":["client_dn","pg_stat_ssl"],"category":"pg_stat_ssl","content_hash":"c961133ec0730300081cfd75e02bf3cf662036805d1c91abdaa0e74cee6e7cc7","imported_at":"2026-09-30T00:40:46.164456+08:00","name":"pg_stat_ssl.client_dn","name_zh":"","slug":"pg_stat_ssl-client_dn","summary":"Distinguished Name (DN) field from the client certificate used, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated if the DN field is longer than NAMEDATALEN (64 characters in a standard build)."}},"Definition":{"Collection":"metric","Key":"pg_stat_ssl-client_dn","SourceDatabase":"center","Version":"18","SourceTable":"statistics_metric","SourceKey":"pg_stat_ssl-client_dn","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"comparison_data":{"field":"client_dn","sql_type":"text","units_mentioned":[],"view":"pg_stat_ssl"},"comparison_hash":"4d44823b21a83076117476f33a7300d66a424ab69ec27c50ef07660e267ba96a","description":["Distinguished Name (DN) field from the client certificate used, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated if the DN field is longer than NAMEDATALEN (64 characters in a standard build)."],"documented":true,"facts":[{"label":"View","value":"pg_stat_ssl"},{"label":"Field","value":"client_dn"},{"label":"SQL type","value":"text"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"No stats_reset field is documented for this view"}],"field":"client_dn","manual_html":"","manual_path":"/docs/18/monitoring-stats.html","related":[{"label":"pg_stat_ssl columns","url":"/wiki/catalog/pg_stat_ssl/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[{"paragraphs":["The pg_stat_ssl view will contain one row per backend or WAL sender process, showing statistics about SSL usage on this connection. It can be joined to pg_stat_activity or pg_stat_replication on the pid column to get more details about the connection."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT client_dn FROM pg_catalog.pg_stat_ssl;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"signature":"SELECT client_dn FROM pg_catalog.pg_stat_ssl;","source_only":false,"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#PG-STAT-SSL-VIEW"}],"sql_type":"text","tables":[],"units_mentioned":[],"view":"pg_stat_ssl"},"ManualEvidence":{"manual_path":"/docs/18/monitoring-stats.html","release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#PG-STAT-SSL-VIEW"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_ssl-client_dn","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_ssl.client_dn","Summary":"Distinguished Name (DN) field from the client certificate used, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated if the DN field is longer than NAMEDATALEN (64 characters in a standard build).","BodyHTML":"\u003cp\u003eDistinguished Name (DN) field from the client certificate used, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated if the DN field is longer than NAMEDATALEN (64 characters in a standard build).\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"e28f5bd6f932a86f160919486b99a937c3c1f244f2f987335a95e7185e41416a","Payload":{"description":["Distinguished Name (DN) field from the client certificate used, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated if the DN field is longer than NAMEDATALEN (64 characters in a standard build)."],"manual_html":"","related":[{"label":"pg_stat_ssl columns","url":"/wiki/catalog/pg_stat_ssl/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"sections":[{"paragraphs":["The pg_stat_ssl view will contain one row per backend or WAL sender process, showing statistics about SSL usage on this connection. It can be joined to pg_stat_activity or pg_stat_replication on the pid column to get more details about the connection."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT client_dn FROM pg_catalog.pg_stat_ssl;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"tables":[]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}