Add system view pg_stat_ssl

Enterprise / PostgreSQL - Magnus Hagander [hagander.net] - 12 April 2015 12:07 UTC

This view shows information about all connections, such as if the connection is using SSL, which cipher is used, and which client certificate (if any) is used.

Reviews by Alex Shulgin, Heikki Linnakangas, Andres Freund & Michael Paquier

9029f4b Add system view pg_stat_ssl
doc/src/sgml/monitoring.sgml | 77 ++++++++++++++++++++++++
src/backend/catalog/system_views.sql | 11 ++++
src/backend/libpq/be-secure-openssl.c | 104 +++++++++++++++++++++++++++++++++
src/backend/postmaster/pgstat.c | 60 +++++++++++++++++++
src/backend/utils/adt/pgstatfuncs.c | 33 ++++++++++-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.h | 2 +-
src/include/libpq/libpq-be.h | 5 ++
src/include/pgstat.h | 21 +++++++
src/test/regress/expected/rules.out | 12 +++-
10 files changed, 320 insertions(+), 7 deletions(-)

Upstream: git.postgresql.org

  • Share