pg_stat_ssl 是一个 统计视图，显示有关客户端连接SSL状态的信息。
pg_stat_ssl 在 PostgreSQL 9.5 中添加。
按 PostgreSQL 版本定义
pg_stat_ssl (PostgreSQL 19)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
client_dn | text | | |
client_serial | numeric | | |
issuer_dn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 18)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
client_dn | text | | |
client_serial | numeric | | |
issuer_dn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 17)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
client_dn | text | | |
client_serial | numeric | | |
issuer_dn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 16)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
client_dn | text | | |
client_serial | numeric | | |
issuer_dn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 15)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
client_dn | text | | |
client_serial | numeric | | |
issuer_dn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 14)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
client_dn | text | | |
client_serial | numeric | | |
issuer_dn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 13)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
compression | boolean | | |
client_dn | text | | |
client_serial | numeric | | |
issuer_dn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 12)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
compression | boolean | | |
client_dn | text | | |
client_serial | numeric | | |
issuer_dn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 11)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
compression | boolean | | |
clientdn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 10)
View "pg_catalog.pg_stat_ssl"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
pid | integer | | |
ssl | boolean | | |
version | text | | |
cipher | text | | |
bits | integer | | |
compression | boolean | | |
clientdn | text | | |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 9.6)
View "pg_catalog.pg_stat_ssl"
Column | Type | Modifiers
-------------+---------+-----------
pid | integer |
ssl | boolean |
version | text |
cipher | text |
bits | integer |
compression | boolean |
clientdn | text |
文档: pg_stat_ssl
pg_stat_ssl (PostgreSQL 9.5)
View "pg_catalog.pg_stat_ssl"
Column | Type | Modifiers
-------------+---------+-----------
pid | integer |
ssl | boolean |
version | text |
cipher | text |
bits | integer |
compression | boolean |
clientdn | text |
文档: pg_stat_ssl
变更历史
- PostgreSQL 14
- 列
compression已移除 (commit f9264d15)
- 列
- PostgreSQL 13
- only shows processes with a connection, i.e. excluding various auxiliary processes which do not receive network connections (commit 5c46e7d8)
- PostgreSQL 12
- PostgreSQL 9.5
- 已添加 (commit 9029f4b3)
示例
示例内容 (PostgreSQL 11)
postgres=# SELECT * FROM pg_stat_ssl; pid | ssl | version | cipher | bits | compression | clientdn ------+-----+---------+------------------------+------+-------------+---------- 695 | f | | | | | 692 | f | | | | | 704 | t | TLSv1.3 | TLS_AES_256_GCM_SHA384 | 256 | f | 3424 | f | | | | | 690 | f | | | | | 689 | f | | | | | 691 | f | | | | | (7 rows)
参考资料
- PostgreSQL 文档: pg_stat_ssl