Postgres Sessioni

Elenca le sessioni

select pid as process_id, 
      usename as username, 
      datname as database_name, 
      client_addr as client_address, 
      application_name,
      backend_start,
      state,
      state_change
from pg_stat_activity;

Terminare sessione

select pg_terminate_backend(pid);

Oppure usando la tabella:

select pg_terminate_backend(pid)
from pg_stat_activity
where pid = '18765';