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

Categories

Management / adminstration, Security, Statistics / monitoring view

See also

sslinfo, pg_stat_gssapi