Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- активные запросы
- select pid, trim(user_name), starttime, query
- from stv_recents
- where status='Running' order by starttime;
- -- блокировки
- select *
- from admin.v_check_transaction_locks
- order by pid;
- -- убить бэкенд
- select pg_terminate_backend(pid);
Add Comment
Please, Sign In to add comment