SELECT
pid,
usename,
pg_blocking_pids(pid) AS blocked_by,
query,
state,
backend_start,
xact_start,
query_start
FROM pg_stat_activity
WHERE wait_event_type = 'Lock'
OR state = 'idle in transaction';
SELECT pg_cancel_backend(176007); -- 부드러운 종료
SELECT pg_terminate_backend(176007); -- 강제 종료