Skip to content

Instantly share code, notes, and snippets.

@fabriciocolombo

fabriciocolombo/Kill PostgreSQL sessions

Created March 21, 2012 00:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save fabriciocolombo/2142845 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save fabriciocolombo/2142845 to your computer and use it in GitHub Desktop.
Download ZIP
Kill PostgreSQL sessions
Raw
Kill PostgreSQL sessions
/* List active sessions */
select datname,
       procpid,
       usename,
       application_name,
       client_addr,
       client_hostname,
       backend_start
  from pg_stat_activity;
/* Kill one session */
select pg_terminate_backend(procpid)
/* Kill all sessions, except this*/
SELECT pg_terminate_backend(procpid)
   FROM pg_stat_activity
  WHERE procpid <> pg_backend_pid();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment