Re: Add LWLock blocker(s) information

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Add LWLock blocker(s) information
Дата
Msg-id 20200813003934.yrm4qqngfygr6ii7@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Add LWLock blocker(s) information  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: Add LWLock blocker(s) information  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
Hi,

On 2020-08-12 16:47:13 -0700, Peter Geoghegan wrote:
> On Mon, Aug 10, 2020 at 5:41 PM Andres Freund <andres@anarazel.de> wrote:
> > Most of the cases where this kind of information really is interesting
> > seem to benefit a lot from having stack information available.  That
> > obviously has overhead, so we don't want the cost all the
> > time.  The script at
> > https://postgr.es/m/20170622210845.d2hsbqv6rxu2tiye%40alap3.anarazel.de
> > can give you results like e.g.
> > https://anarazel.de/t/2017-06-22/pgsemwait_64_async.svg
> 
> It seems to have bitrot. Do you have a more recent version of the script?

Attached. Needed one python3 fix, and to be adapted so it works with
futex based semaphores. Seems to work for both sysv and posix semaphores
now, based a very short test.

sudo python3 ./pgsemwait.py -x /home/andres/build/postgres/dev-optimize/vpath/src/backend/postgres -f
3|~/src/flamegraph/flamegraph.pl

Will add a note to the other thread.

Greetings,

Andres Freund

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: run pgindent on a regular basis / scripted manner
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Dynamic instrumentation of lwlock wait times (lwlock flamegraphs)