Skip to content

Instantly share code, notes, and snippets.

View parrish's full-sized avatar

Michael Parrish parrish

View GitHub Profile
[
{
"left": 1,
"right": 2,
"operator": "<"
},
"and",
[
{
"left": 2,
@parrish
parrish / pg_locks.sql
Created June 30, 2016 14:33
Show info on postgres locks
SELECT bl.pid AS blocked_pid,
a.usename AS blocked_user,
ka.query AS current_statement_in_blocking_process,
now() - ka.query_start AS blocking_duration,
kl.pid AS blocking_pid,
ka.usename AS blocking_user,
a.query AS blocked_statement,
now() - a.query_start AS blocked_duration
FROM pg_catalog.pg_locks bl
JOIN pg_catalog.pg_stat_activity a ON a.pid = bl.pid