Postgres Sessioni: differenze tra le versioni
Jump to navigation
Jump to search
(Una versione intermedia di uno stesso utente non è mostrata) | |||
Riga 1: | Riga 1: | ||
=Elenca le sessioni= |
==Elenca le sessioni== |
||
Riga 16: | Riga 16: | ||
==Terminare sessione== |
==Terminare sessione== |
||
select pg_terminate_backend(pid) |
select pg_terminate_backend(pid); |
||
Oppure usando la tabella: |
|||
select pg_terminate_backend(pid) |
|||
from pg_stat_activity |
from pg_stat_activity |
||
where pid = '18765'; |
where pid = '18765'; |
Versione attuale delle 15:41, 26 ott 2023
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';