PG query management in simple query snippets

query_management.sql

-- This queries were tested on PostgreSQL 9.3.4

-- Provides detailed information about servers current connections
SELECT  datname as database, 
        pid, 
        user as username, 
        application_name as application, 
        client_addr as client_address, 
        query 
  FROM pg_stat_activity;

-- Terminates all connections to specific database
SELECT pg_terminate_backend(pid)
  FROM pg_stat_activity
  WHERE datname = 'foo';

-- Terminates all connections tied to specific user
SELECT pg_terminate_backend(pid)
  FROM pg_stat_activity
  WHERE user = 'user';

-- Terminates all connections except your own process
SELECT pg_terminate_backend(pid) 
  FROM pg_stat_activity 
  WHERE pid <> pg_backend_pid();

-- Terminates all connections except your own user
SELECT pg_terminate_backend(pid)
  FROM pg_stat_activity
  WHERE user <> current_user;

-- Cancels all connections to specific database
SELECT pg_cancel_backend(pid)
  FROM pg_stat_activity
  WHERE datname = 'foo';