I’m using Postgres 9.1 and enabled the log configuration param ‘log_lock_waits’.
However, it only logs the session which is waiting for the lock longer than ‘deadlock_timeout’. It doesn’t log the session which acquired the lock?
Is there a way to log the session that acquired the lock along with the session which is waiting for the lock?
Thanks,
Raj