pg_stat_ssl
A statistics view showing information about the SSL status of client connections
pg_stat_ssl is a statistics view showing information about the SSL status of client connections.
pg_stat_ssl was introduced in PostgreSQL 9.5.
Definition by PostgreSQL version
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 | | |
Documentation: 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 | | |
Documentation: 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 | | |
Documentation: 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 | | |
Documentation: 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 |
Documentation: 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 |
Documentation: pg_stat_ssl
Change history
- 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
- added (commit 9029f4b3)
References
- PostgreSQL documentation: pg_stat_ssl