{"Entry":{"collection":"catalog","key":"pg_stat_ssl","name":"pg_stat_ssl","aliases":[],"metadata":{"changed_in":["12","14"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.4","order":false,"removed":[],"status":"added","to":"9.5","types":[]},{"added":["client_dn","client_serial","issuer_dn"],"attributes":[],"description_changed":false,"descriptions":[],"from":"11","listing":[],"order":false,"removed":["clientdn"],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"13","listing":[],"order":false,"removed":["compression"],"status":"changed","to":"14","types":[],"unlisted":[]}],"column_count":8,"content_hash":"80b8db560a4549963db53bef65abd5748c7625084fcbeada1f17a5084b684dc9","derived_content_hash":"453ba71b4889884471e1813166eab8d19821a76b5c4005e636d791ca2a37183f","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:fddb677b7280e8604a086d1bab09b3c2ef0849aa0ae31e4df361f2eedc1faa94","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"9.5","imported_at":"2026-09-30T00:40:55.98569+08:00","kind":"statistics","last_version":"20","name":"pg_stat_ssl","position":107,"present_in":["9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:fddb677b7280e8604a086d1bab09b3c2ef0849aa0ae31e4df361f2eedc1faa94","summary":"The pg_stat_ssl view will contain one row per backend or WAL sender process, showing statistics about SSL usage on this connection.","summary_zh":"pg_stat_ssl 视图将为每一个后端或者 WAL 发送进程包含一行，用来显示这个连接上的 SSL 使用情况。可以把它与 pg_stat_activity 或者 pg_stat_replication 通过 pid 列连接来得到更多有关该连接的细节。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_ssl","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_ssl","SourceRevision":"catalog-bilingual-repair:fddb677b7280e8604a086d1bab09b3c2ef0849aa0ae31e4df361f2eedc1faa94","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of a backend or WAL sender process","description_zh":"后端或 WAL 发送进程的进程 ID","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"True if SSL is used on this connection","description_zh":"如果在此连接上使用 SSL，则为真","documented":true,"documented_name":"ssl","hidden":false,"name":"ssl","not_null":false,"references":"","type":"boolean","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Version of SSL in use, or NULL if SSL is not in use on this connection","description_zh":"使用 SSL 的版本，如果此连接上没有使用 SSL 则为空值","documented":true,"documented_name":"version","hidden":false,"name":"version","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Name of SSL cipher in use, or NULL if SSL is not in use on this connection","description_zh":"正在使用的 SSL 密码套件的名称，如果此连接上没有使用 SSL 则为空值","documented":true,"documented_name":"cipher","hidden":false,"name":"cipher","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Number of bits in the encryption algorithm used, or NULL if SSL is not used on this connection","description_zh":"使用的加密算法中的位数，如果此连接上没有使用 SSL 则为空值","documented":true,"documented_name":"bits","hidden":false,"name":"bits","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"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).","description_zh":"所用客户端证书中的区别名称（DN，Distinguished Name）字段，如果没有提供客户端证书或在此连接上没有使用 SSL，则为空值。如果 DN 字段长于 NAMEDATALEN（标准构建中为 64 个字符），则该字段将被截断。","documented":true,"documented_name":"client_dn","hidden":false,"name":"client_dn","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Serial number of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. The combination of certificate serial number and certificate issuer uniquely identifies a certificate (unless the issuer erroneously reuses serial numbers).","description_zh":"客户端证书的序列号，如果没有提供客户端证书或在此连接上没有使用 SSL，则为空值。证书序列号和证书颁发者的组合唯一标识一个证书（除非颁发者错误地重用序列号）。","documented":true,"documented_name":"client_serial","hidden":false,"name":"client_serial","not_null":false,"references":"","type":"numeric","type_modifier":-1,"type_oid":1700,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"DN of the issuer of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated like client_dn.","description_zh":"客户端证书颁发者的区别名称（DN，Distinguished Name），如果没有提供客户端证书或在此连接上没有使用 SSL，则为空值。该字段像 client_dn 一样被截断。","documented":true,"documented_name":"issuer_dn","hidden":false,"name":"issuer_dn","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"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.","description_zh":"pg_stat_ssl 视图将为每一个后端或者 WAL 发送进程包含一行，用来显示这个连接上的 SSL 使用情况。可以把它与 pg_stat_activity 或者 pg_stat_replication 通过 pid 列连接来得到更多有关该连接的细节。","description_zh_html":"\u003cp\u003epg_stat_ssl 视图将为每一个后端或者 WAL 发送进程包含一行，用来显示这个连接上的 SSL 使用情况。可以把它与 pg_stat_activity 或者 pg_stat_replication 通过 pid 列连接来得到更多有关该连接的细节。\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-SSL-VIEW\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.20. \u003ccode class=\"structname\"\u003epg_stat_ssl\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_ssl 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003epid\u003c/code\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       后端或 WAL 发送进程的进程 ID\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003essl\u003c/code\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       如果在此连接上使用 SSL，则为真\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eversion\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       使用 SSL 的版本，如果此连接上没有使用 SSL 则为空值\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ecipher\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       正在使用的 SSL 密码套件的名称，如果此连接上没有使用 SSL 则为空值\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ebits\u003c/code\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       使用的加密算法中的位数，如果此连接上没有使用 SSL 则为空值\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eclient_dn\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       所用客户端证书中的区别名称（DN，Distinguished Name）字段，如果没有提供客户端证书或在此连接上没有使用 SSL，则为空值。如果 DN 字段长于 \u003ccode class=\"symbol\"\u003eNAMEDATALEN\u003c/code\u003e（标准构建中为 64 个字符），则该字段将被截断。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eclient_serial\u003c/code\u003e \u003ccode class=\"type\"\u003enumeric\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       客户端证书的序列号，如果没有提供客户端证书或在此连接上没有使用 SSL，则为空值。证书序列号和证书颁发者的组合唯一标识一个证书（除非颁发者错误地重用序列号）。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eissuer_dn\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       客户端证书颁发者的区别名称（DN，Distinguished Name），如果没有提供客户端证书或在此连接上没有使用 SSL，则为空值。该字段像 \u003ccode class=\"structfield\"\u003eclient_dn\u003c/code\u003e 一样被截断。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","doc":{"anchor":"PG-STAT-SSL-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"documentation_revision":{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","ssl","version","cipher","bits","client_dn","client_serial","issuer_dn"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:66a660e28c700d3408dc5af8839deef8e4dbcac334d86d95cf9517dfe227d805","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-SSL-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:66a660e28c700d3408dc5af8839deef8e4dbcac334d86d95cf9517dfe227d805","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","ssl","version","cipher","bits","client_dn","client_serial","issuer_dn"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_ssl","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_ssl","Summary":"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.","BodyHTML":"\u003cp\u003eThe 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:fddb677b7280e8604a086d1bab09b3c2ef0849aa0ae31e4df361f2eedc1faa94","ContentHash":"b726077af4bb272f7a514a0491719188ddde6a6558ee6a9d0f93438cc997d97f","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of a backend or WAL sender process","description_zh":"后端或 WAL 发送进程的进程 ID","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"True if SSL is used on this connection","description_zh":"如果在此连接上使用 SSL，则为真","documented":true,"documented_name":"ssl","hidden":false,"name":"ssl","not_null":false,"references":"","type":"boolean","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Version of SSL in use, or NULL if SSL is not in use on this connection","description_zh":"使用 SSL 的版本，如果此连接上没有使用 SSL 则为空值","documented":true,"documented_name":"version","hidden":false,"name":"version","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Name of SSL cipher in use, or NULL if SSL is not in use on this connection","description_zh":"正在使用的 SSL 密码套件的名称，如果此连接上没有使用 SSL 则为空值","documented":true,"documented_name":"cipher","hidden":false,"name":"cipher","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Number of bits in the encryption algorithm used, or NULL if SSL is not used on this connection","description_zh":"使用的加密算法中的位数，如果此连接上没有使用 SSL 则为空值","documented":true,"documented_name":"bits","hidden":false,"name":"bits","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"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).","description_zh":"所用客户端证书中的区别名称（DN，Distinguished Name）字段，如果没有提供客户端证书或在此连接上没有使用 SSL，则为空值。如果 DN 字段长于 NAMEDATALEN（标准构建中为 64 个字符），则该字段将被截断。","documented":true,"documented_name":"client_dn","hidden":false,"name":"client_dn","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Serial number of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. The combination of certificate serial number and certificate issuer uniquely identifies a certificate (unless the issuer erroneously reuses serial numbers).","description_zh":"客户端证书的序列号，如果没有提供客户端证书或在此连接上没有使用 SSL，则为空值。证书序列号和证书颁发者的组合唯一标识一个证书（除非颁发者错误地重用序列号）。","documented":true,"documented_name":"client_serial","hidden":false,"name":"client_serial","not_null":false,"references":"","type":"numeric","type_modifier":-1,"type_oid":1700,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"DN of the issuer of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated like client_dn.","description_zh":"客户端证书颁发者的区别名称（DN，Distinguished Name），如果没有提供客户端证书或在此连接上没有使用 SSL，则为空值。该字段像 client_dn 一样被截断。","documented":true,"documented_name":"issuer_dn","hidden":false,"name":"issuer_dn","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"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."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}