Raj Gandhi <raj01gandhi@xxxxxxxxx> writes: > 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? Do you assume there is but 1 single session blocking the waiter? False in cases where some N number of sessions are all holding less invasive locks and you are pending on a heavier one. To wit; share locks granted and an exclusive locker pending. The question in regards to whether it's possible to log more info here in any case isn't something I can answer personally. HTH >  > Thanks, > Raj > >  > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
