Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time
Дата
Msg-id CAFj8pRDpSgjVyRnvPBtHQDwcejyjr9pguJvhWxa_Y3oaUbAE7Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers
Дерево обсуждения


2016-02-14 17:46 GMT+01:00 Tom Lane <tgl@sss.pgh.pa.us>:
Pavel Stehule <pavel.stehule@gmail.com> writes:
> We have a patch, that inject logs about the time waiting on locks before
> query execution. This feature helps us lot of, and I hope, it can be
> generally useful.

Doesn't log_lock_waits cover that territory already?

It does. But It creates different log entry - and can be hard to join slow query with log entry sometimes lot of lines before. This proposal is about taking important information comfortably - and log parsing and processing is simpler.

Regards

Pavel


                        regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bool btree_gin index not chosen on equality contraint, but on greater/lower?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Introduce group locking to prevent parallel processes from deadl