PostgreSQL locking visibility for application developers and DBAs is in most cases related to heavyweight locks. Complex database locking operations require full instrumentation using views from the system catalog. It should be clear which object is locked by a specific database backend process. An alternative name for any lock is bottleneck. In order to make [&]

https://www.percona.com/blog/2018/10/24/postgresql-locking-part-2-heavyweight-locks/