This can easily happen if you have multiple services that can write/update in the same table/rows and rely on database coordination instead of using an external queue like Kafka.

Postgres (presumably other databases) can propagate these locks to table locks [1] and cause contention for the whole infra.

[1] https://blog.heroku.com/curious-case-table-locking-update-qu...