|
Would connections to a database require crating an extra
ExclusiveLock? We have some connections to the database that happen to be “idle
in transaction” and their pids have a granted “Exclusive Lock”
in pg_locks. I cannot discern the tables where the ExclusiveLock is being
held because the relation field is blank. Moreover, there are other connections to the database coming
from the same ip address as that of the connection with the ExclusiveLock.
Some of the pids of these other connections seem to have different kinds of
locks (AccessShareL0ck) so I am not quite sure why the pids with the
ExclusiveLock’s are necessary. How could I find out the tables that are being locked when I
see an “ExclusiveLock” in pg_locks. |
