Postgres log configuration for locking

From: Raj Gandhi <raj01gandhi(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres log configuration for locking
Date: 2014-12-03 20:07:12
Message-ID: CALU_HCOwRjbpbH1yg71nqOV4Fc1HkK6Bj1rdBS2p2hs4gT=EuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2014-12-03 21:26:06 Re: Postgres log configuration for locking
Previous Message Vasilis Ventirozos 2014-12-03 10:06:52 Re: WAL log management w/ multiple slaves