Created
May 14, 2018 18:20
-
-
Save GraphBear/5003e99d56a0b9644ad044af8cbc89a8 to your computer and use it in GitHub Desktop.
what's locking?
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
waiting.locktype AS waiting_locktype, | |
waiting.relation::regclass AS waiting_table, | |
waiting_stm.query AS waiting_query, | |
waiting.mode AS waiting_mode, | |
waiting.pid AS waiting_pid, | |
other.locktype AS other_locktype, | |
other.relation::regclass AS other_table, | |
other_stm.query AS other_query, | |
other.mode AS other_mode, | |
other.pid AS other_pid, | |
other.GRANTED AS other_granted | |
FROM | |
pg_catalog.pg_locks AS waiting | |
JOIN | |
pg_catalog.pg_stat_activity AS waiting_stm | |
ON ( | |
waiting_stm.pid = waiting.pid | |
) | |
JOIN | |
pg_catalog.pg_locks AS other | |
ON ( | |
( | |
waiting."database" = other."database" | |
AND waiting.relation = other.relation | |
) | |
OR waiting.transactionid = other.transactionid | |
) | |
JOIN | |
pg_catalog.pg_stat_activity AS other_stm | |
ON ( | |
other_stm.pid = other.pid | |
) | |
WHERE | |
NOT waiting.GRANTED | |
AND | |
waiting.pid <> other.pid |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment