Re: Logging Lock Waits

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> I'm thinking to write an INFO message, so that people can choose to log
> this and/or the SQL statement if they choose. 
> e.g. INFO: lock wait time of XXX secs has been exceeded

The available timer resources are already overloaded; adding an
independent timeout for this will complicate the code more than seems
justified.  Perhaps you could add a LOG message whenever the
deadlock-check code runs (and doesn't detect an error, so is about to go
back to sleep).  This would take almost no effort, and the granularity
could still be adjusted via the deadlock check timeout.

			regards, tom lane