Skip to content

Instantly share code, notes, and snippets.

@jhonylucas74

jhonylucas74/show_all_connections.sql

Created August 10, 2018 17:17
Show Gist options
  • Save jhonylucas74/864995f0f6dd7fcb5e4aa267a80b0595 to your computer and use it in GitHub Desktop.
Save jhonylucas74/864995f0f6dd7fcb5e4aa267a80b0595 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
show_all_connections.sql
SELECT
pid
,datname
,usename
,application_name
,client_hostname
,client_port
,query
,state
FROM pg_stat_activity
WHERE datname='daas';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment