Re: Lock Wait Statistics (next commitfest)
Jaime Casanova <jcasanov@systemguards.com.ec>
From: Jaime Casanova <jcasanov@systemguards.com.ec>
To: Mark Kirkwood <markir@paradise.net.nz>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2009-07-11T00:56:20Z
Lists: pgsql-hackers
Attachments
- lockstats-2.patch (text/x-diff) patch
On Fri, Jul 10, 2009 at 12:23 PM, Jaime Casanova<jcasanov@systemguards.com.ec> wrote: > On Sun, Jan 25, 2009 at 6:57 PM, Mark Kirkwood<markir@paradise.net.nz> wrote: >> >> So here is my initial attempt at this, at this point merely to spark >> discussion (attached patch) >> > > this patch doesn't apply cleanly to head... can you update it, please? > i did it myself, i think this is something we need... this compile and seems to work... something i was wondering is that having the total time of lock waits is not very accurate because we can have 9 lock waits awaiting 1 sec each and one awaiting for 1 minute... simply sum them all will give a bad statistic or am i missing something? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157