pg_stat_ssl

显示连接SSL状态信息的视图

pg_stat_ssl 是一个统计视图，显示客户端连接的SSL状态信息。

pg_stat_ssl 在 PostgreSQL 9.5 中添加。

按PostgreSQL版本定义

pg_stat_ssl (PostgreSQL 18)

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

文档: pg_stat_ssl

pg_stat_ssl (PostgreSQL 17)

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

文档: pg_stat_ssl

pg_stat_ssl (PostgreSQL 16)

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

文档: pg_stat_ssl

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

文档: 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    |           |          |

文档: 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    |           |          |

文档: 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    |           |          |

文档: 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    |           |          |

文档: 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    |           |          |

文档: 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    |

文档: 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    |

文档: pg_stat_ssl

变更历史

PostgreSQL 14
- 删除 compression 列 (提交 f9264d15)
PostgreSQL 13
- 仅显示具有连接的进程，即排除不接收网络连接的各种辅助进程 (提交 5c46e7d8)
PostgreSQL 12
- 添加 client_serial 列 (提交 f60a0e96)
- 添加 issuer_dn 列 (提交 f60a0e96)
- 将 clientdn 列重命名为 client_dn (提交 f60a0e96)
- 非特权用户现在只能查看自己的行 (提交 f9692a76)
PostgreSQL 9.5
- 添加 (提交 9029f4b3)

示例

示例内容 (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)

参考文献

PostgreSQL 文档： pg_stat_ssl

参见

sslinfo, pg_stat_gssapi

反馈

提交关于 "pg_stat_ssl" 的任何评论、建议或更正 此处.

版本图表

有用概述

有用链接

咖啡

目录

pg_stat_ssl

按PostgreSQL版本定义

pg_stat_ssl (PostgreSQL 18)

pg_stat_ssl (PostgreSQL 17)

pg_stat_ssl (PostgreSQL 16)

pg_stat_ssl (PostgreSQL 15)

pg_stat_ssl (PostgreSQL 14)

pg_stat_ssl (PostgreSQL 13)

pg_stat_ssl (PostgreSQL 12)

pg_stat_ssl (PostgreSQL 11)

pg_stat_ssl (PostgreSQL 10)

pg_stat_ssl (PostgreSQL 9.6)

pg_stat_ssl (PostgreSQL 9.5)

变更历史

示例

参考文献

分类

参见

反馈