Re: Lock Wait Statistics (next commitfest)

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Lock Wait Statistics (next commitfest)
Дата
Msg-id 4A681444.80004@paradise.net.nz
обсуждение исходный текст
Ответ на Re: Lock Wait Statistics (next commitfest)  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Ответы Re: Lock Wait Statistics (next commitfest)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Lock Wait Statistics (next commitfest)  (Mark Kirkwood <markir@paradise.net.nz>)
Re: Lock Wait Statistics (next commitfest)  (Mark Kirkwood <markir@paradise.net.nz>)
Список pgsql-hackers
Jaime Casanova wrote:
> On Fri, Jul 17, 2009 at 3:38 AM, Mark Kirkwood<markir@paradise.net.nz> wrote:
>   
>> With respect to the sum of wait times being not very granular, yes - quite
>> true. I was thinking it is useful to be able to answer the question 'where
>> is my wait time being spent' - but it hides cases like the one you mention.
>> What would you like to see?  would max and min wait times be a useful
>> addition, or are you thinking along different lines?
>>
>>     
>
> track number of locks, sum of wait times, max(wait time).
> but actually i started to think that the best is just make use of
> log_lock_waits send the logs to csvlog and analyze there...
>
>   
Right - I'll look at adding max (at least) early next week.

Yeah, enabling log_lock_waits is certainly another approach, however you 
currently miss out on those that are < deadlock_timeout - and 
potentially they could be the source of your problem (i.e millions of 
waits all < deadlock_timeout but taken together rather significant). 
This shortcoming could be overcome by making the cutoff wait time 
decoupled from deadlock_timeout (e.g a new parameter 
log_min_lock_wait_time or similar).

I'm thinking that having the lock waits analyzable via sql easily may 
mean that for most people they don't need to collect and analyze their 
logs for this stuff (they just examine the lock stats view from Pgadmin 
or similar).

Cheers

Mark




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Itagaki Takahiro
Дата:
Сообщение: trace hooks (for 2nd commitfest)
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Extension Facility