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';