Skip to content

Instantly share code, notes, and snippets.

View varunchitale's full-sized avatar

Varun Chitale varunchitale

  • Berlin
View GitHub Profile
@varunchitale
varunchitale / locks.sql
Created March 25, 2019 07:10
Get a list of queries and their details that hold locks over relations in a dB.
SELECT
blocked_locks.pid AS blocked_pid,
blocked_activity.usename AS blocked_user,
blocking_locks.pid AS blocking_pid,
blocking_activity.usename AS blocking_user,
blocked_activity.query AS blocked_statement,
blocking_activity.query AS current_statement_in_blocking_process,
blocked_activity.application_name AS blocked_application,
blocking_activity.application_name AS blocking_application
FROM pg_catalog.pg_locks blocked_locks