Postgres Sessioni: differenze tra le versioni
Jump to navigation
Jump to search
(2 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'; |
|||
[[Categoria:Database]] |
[[Categoria:Database]] |
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';