[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)