Postgres Sessioni
Jump to navigation
Jump to search
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';