https://pawelurbanek.com/rails-postgresql-locks

PostgreSQL database locks usually work seamlessly until they don’t. Before your app’s dataset and traffic reach a certain scale, you’re unlikely to face any locks-related issues. But if your app suddenly slows down to a crawl, deadlocks likely are to blame. In this blog post, I’ll describe how to monitor database locks and propose best practices to prevent them from causing issues.