Skip to content

Instantly share code, notes, and snippets.

@liuxd
Last active March 7, 2019 21:34
Show Gist options
  • Save liuxd/600a4d238edae766786c88621d713361 to your computer and use it in GitHub Desktop.
Save liuxd/600a4d238edae766786c88621d713361 to your computer and use it in GitHub Desktop.
[PostgreSQL] #PostgreSQL
# Show processlist.
SELECT datid, datname, pid, usesysid, usename, query, backend_type FROM pg_stat_activity WHERE state = 'active'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment