Re: Exhaustive list of what takes what locks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

--Nik

I 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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux