I, @TheOtherBrian1, currently work as a customer reliability engineer with a focus in Postgres management and observability.

This site represents the documentation and resources I wish existed when I was learning about locks.

My goal is to:

The whole project took a lot of effort to complete, so I hope you find it insightful.

Basic concepts of locks and how they work in Postgres. I tried to make it more digestible with animations.

Outlines table locks and provides a few demoes one can run to see them in action.

Interactive tool that shows what SQL operations lock out each other.

Lock problems and how to identify and resolve them.

Reviews of popular monitoring tools, as well as some homegrown solutions.

There are a few topics that I haven't gotten around to documenting yet, but I plan to add them soon:

Postgres Locks Explained