[HN Gopher] Show HN: Postgres query lock explainer ___________________________________________________________________ Show HN: Postgres query lock explainer This is like 4 years old, but I'm braver now and ready to share stuff with this community. I've been a lurker for a while. I made this tool - it's kind of like "explain" but it tells you about what locks would be required by the query. I was making it as part of a larger tool that would try to prevent deadlocks during migrations at my last company, I never finished it. Author : admtal Score : 20 points Date : 2023-05-17 21:02 UTC (1 hours ago) (HTM) web link (github.com) (TXT) w3m dump (github.com) | miohtama wrote: | Related to this: would anyone know how to figure out which 1) | applications and 2) queries where holidng locks after a dead lock | happened, post mortem? As the default PSQL deadlock log output is | very sparse to the point being useless. ___________________________________________________________________ (page generated 2023-05-17 23:00 UTC)