Re: Exhaustive list of what takes what locks

On Wed, Feb 2, 2011 at 3:29 PM, Nikolas Everett <nik9000(at)gmail(dot)com> wrote:

>
>
> On Wed, Feb 2, 2011 at 2:53 PM, Nikolas Everett <nik9000(at)gmail(dot)com> 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