![java - Why is an INSERT query hanging indefinitely and locking up PostgreSQL database and pgAdmin - Stack Overflow java - Why is an INSERT query hanging indefinitely and locking up PostgreSQL database and pgAdmin - Stack Overflow](https://i.stack.imgur.com/OZVzR.png)
java - Why is an INSERT query hanging indefinitely and locking up PostgreSQL database and pgAdmin - Stack Overflow
![Hussein Nasser on X: "I used to think database locks are two types, shared and exclusive. I was so wrong. few weeks back I decided to open the can of worms that Hussein Nasser on X: "I used to think database locks are two types, shared and exclusive. I was so wrong. few weeks back I decided to open the can of worms that](https://pbs.twimg.com/media/FsJ3hxcaYAAlhGp.jpg)
Hussein Nasser on X: "I used to think database locks are two types, shared and exclusive. I was so wrong. few weeks back I decided to open the can of worms that
![Zero-downtime Postgres schema migrations need this: lock_timeout and retries | Database branching for any Postgres DB · Postgres.ai · DBLab Zero-downtime Postgres schema migrations need this: lock_timeout and retries | Database branching for any Postgres DB · Postgres.ai · DBLab](https://postgres.ai/assets/blog/20210923/lock-conflicts-table.png?2)
Zero-downtime Postgres schema migrations need this: lock_timeout and retries | Database branching for any Postgres DB · Postgres.ai · DBLab
![Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · DBLab Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues) | Database branching for any Postgres DB · Postgres.ai · DBLab](https://postgres.ai/assets/thumbnails/postgresql-query-for-lock-trees-analysis-2.png)