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

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)

Categories

Management / adminstration, Security, Statistics / monitoring view

See also

sslinfo, pg_stat_gssapi