Skip to content

Instantly share code, notes, and snippets.

@beaufour

beaufour/connection_status.sql

Last active September 29, 2020 15:12
Show Gist options
  • Save beaufour/c3454dc65f8b1e362c875107bc7f3707 to your computer and use it in GitHub Desktop.
Save beaufour/c3454dc65f8b1e362c875107bc7f3707 to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql: List connections and their SSL status
Raw
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment