Skip to content

Instantly share code, notes, and snippets.

View kerbelp's full-sized avatar

Pavel Kerbel kerbelp

44 followers · 13 following
View GitHub Profile
@kerbelp
kerbelp / current_mtu_status.sh
Created September 9, 2016 21:44
ip link show eth0
@kerbelp
kerbelp / redshift_cancel_query.sql
Created September 9, 2016 21:37
cancel 'pid';
@kerbelp
kerbelp / redshift_terminate_session.sql
Created September 9, 2016 21:35
select pg_terminate_backend('lock_owner_pid');
@kerbelp
kerbelp / redhisft_lock_tables.sql
Created September 9, 2016 21:34
SELECT table_id,
last_update,
lock_owner,
lock_owner_pid,
lock_status
FROM stv_locks;
@kerbelp
kerbelp / redshift_currnet_connections.sql
Created September 9, 2016 21:30
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')