[Redshift] ロックを検出、プロセスの停止

gistfile1.sql

select current_time, c.relname, l.database, l.transaction, l.pid, a.usename, l.mode, l.granted from pg_catalog.pg_locks l join pg_catalog.pg_class c on c.oid = l.relation join pg_catalog.pg_stat_activity a on a.procpid = l.pid;

set query_group to 'superuser';
select pg_terminate_backend(<pid>);
reset query_group;