How to view a PostgreSQL connection SSL status

This query will report on connections and ssl status. The pg_stat_ssl view reports on  connection SSL  . Adding the join to pg_stat_activity   gives some extra connection information.

SELECT backend_start,ssl,version,datname as "Database name", usename as "User name", ssl, client_addr, application_name, backend_type,*

FROM pg_stat_ssl

JOIN pg_stat_activity

ON pg_stat_ssl.pid = pg_stat_activity.pid

ORDER BY backend_start DESC,ssl;

There are different sslmodes available for connections to PostgreSQL. Deciding on which mode used there are different consequences for Man in the Middle (MITM) and Eavesdropping type of attacks.    

disable

allow

prefer

require

verify-ca

verify-full 

Using the query from above it is possible to view the SSL status of a connection.