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
compressionremoved (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