Postgres Sessioni: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con "=Elenca le sessioni= select pid as process_id, usename as username, datname as database_name, client_addr as client_address, application_n...") |
|||
(3 versioni intermedie di uno stesso utente non sono mostrate) | |||
Riga 1: | Riga 1: | ||
=Elenca le sessioni= |
==Elenca le sessioni== |
||
Riga 14: | Riga 14: | ||
from pg_stat_activity; |
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'; |
|||
⚫ | |||
⚫ |
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';