pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Postgres log configuration for locking 2+ messages / 2 participants [nested] [flat]
* Postgres log configuration for locking @ 2014-12-03 20:07 Raj Gandhi <raj01gandhi@gmail.com> 2014-12-03 21:26 ` Re: Postgres log configuration for locking Jerry Sievers <gsievers19@comcast.net> 0 siblings, 1 reply; 2+ messages in thread From: Raj Gandhi @ 2014-12-03 20:07 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres log configuration for locking 2014-12-03 20:07 Postgres log configuration for locking Raj Gandhi <raj01gandhi@gmail.com> @ 2014-12-03 21:26 ` Jerry Sievers <gsievers19@comcast.net> 0 siblings, 0 replies; 2+ messages in thread From: Jerry Sievers @ 2014-12-03 21:26 UTC (permalink / raw) To: Raj Gandhi <raj01gandhi@gmail.com>; +Cc: pgsql-admin Raj Gandhi <raj01gandhi@gmail.com> 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@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-12-03 21:26 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-12-03 20:07 Postgres log configuration for locking Raj Gandhi <raj01gandhi@gmail.com> 2014-12-03 21:26 ` Jerry Sievers <gsievers19@comcast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox