Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · Database Lab Engine (DLE)
PostgreSQL lock trees - DEV Community
Key Things to Monitor in PostgreSQL - Analyzing Your Workload | Severalnines
Locks in PostgreSQL: 1. Relation-level locks / Habr
Lock monitoring in Postgres: Find blocking queries in a lock tree with pganalyze