pg_stat_ssl
A statistics view showing information about connection SSL status
pg_stat_ssl
is a statistics view showing information about the SSL status of client connections.
pg_stat_ssl
was added in PostgreSQL 9.5.
Definition by PostgreSQL version
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 | | |
Documentation: 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 | | |
Documentation: 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 | | |
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 14
- column
compression
removed (commit f9264d15)
- column
- 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)
Examples
Sample contents (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)
References
- PostgreSQL documentation: pg_stat_ssl