Re: Lock Wait Statistics (next commitfest)

Pierre Frédéric Caillaud <lists@peufeu.com>

View thread View on postgr.es

From: Pierre Frédéric Caillaud <lists@peufeu.com>

To: "Stephen Frost" <sfrost@snowman.net>, "Mark Kirkwood" <markir@paradise.net.nz>

Cc: pgsql-hackers@postgresql.org

Date: 2009-09-18T18:44:39Z

Lists: pgsql-hackers

Attachments

lwlock_instrument_v4.patch (application/octet-stream) patch v4

I have this patch, if you're interested.

LWLock Instrumentation Patch

- counts locks and waits in shared and exclusive mode
- for selected locks, measures wait and hold times
- for selected locks, displays a histogram of wait and hold times
- information is printed at backend exit

Configurable by #define's in lwlock.c

Regards,
pierre