终止所有与指定表 table_name 相关的活动会话

SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE state = 'active'
AND pid != pg_backend_pid()
AND pid IN (
SELECT a.pid
FROM pg_locks a
JOIN pg_class b ON a.relation = b.oid
WHERE lower(b.relname) = 'table_name')