Postgresql: List connections and their SSL status

connection_status.sql

select pg_stat_ssl.pid, client_addr, datname, usename, application_name, ssl
from pg_stat_activity
join pg_stat_ssl
on pg_stat_activity.pid = pg_stat_ssl.pid;