Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Postgresql: List connections and their SSL status
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment