Finding and releasing locks on Redshift

find_release_locks.sql

select * from
    stv_locks
    left join stv_recents on pid = lock_owner_pid;

-- http://docs.aws.amazon.com/redshift/latest/dg/PG_TERMINATE_BACKEND.html
select * from svv_transactions t
	left join stv_recents r on r.pid = t.pid
	order by txn_start;

-- Query for killing jobs:
-- cancel 29078;

-- Terminating entire process
-- https://stackoverflow.com/questions/18866865/difference-between-terminating-and-cancelling-a-process
-- select pg_terminate_backend(29078);