On Wed, Feb 2, 2011 at 3:29 PM, Nikolas Everett <nik9000@xxxxxxxxx> wrote:
On Wed, Feb 2, 2011 at 2:53 PM, Nikolas Everett <nik9000@xxxxxxxxx> wrote:Given that the a list would be difficult to maintain, is there some way I can make Postgres spit out the list of what locks are taken?--NikI just answered my own question -compile with -DLOCK_DEBUG in your src/Makefile.custom and then SET TRACK_LOCKS=true when you want it.--Nik
I just wrote a script to parse the output of postgres' log file into something more useful to me. I'm not sure that it is right but it certainly seems to be working.
I shoved the script here in case it is useful to anyone: https://github.com/nik9000/Postgres-Tools
