Pavel Kerbel kerbelp

## current_mtu_status.sh
ip link show eth0

## redshift_cancel_query.sql
cancel 'pid';

## redshift_terminate_session.sql
select pg_terminate_backend('lock_owner_pid');

## redhisft_lock_tables.sql
SELECT table_id,
       last_update,
       lock_owner,
       lock_owner_pid,
       lock_status
FROM stv_locks;

## redshift_currnet_connections.sql
SELECT recordtime,
       username,
       dbname,
       remotehost,
       remoteport
FROM stl_connection_log
WHERE event = 'initiating session'
AND   pid NOT IN (SELECT pid
                  FROM stl_connection_log
                  WHERE event = 'disconnecting session')
	SELECT table_id,
	last_update,
	lock_owner,
	lock_owner_pid,
	lock_status
	FROM stv_locks;
	SELECT recordtime,
	username,
	dbname,
	remotehost,
	remoteport
	FROM stl_connection_log
	WHERE event = 'initiating session'
	AND pid NOT IN (SELECT pid
	FROM stl_connection_log
	WHERE event = 'disconnecting session')