Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time
Date
Msg-id CAFj8pRDpSgjVyRnvPBtHQDwcejyjr9pguJvhWxa_Y3oaUbAE7Q@mail.gmail.com
Whole thread Raw
In response to Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: proposal: enhancing slow query log, and autoexplain log about waiting on lock before query exec time
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bool btree_gin index not chosen on equality contraint, but on greater/lower?
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Introduce group locking to prevent parallel processes from deadl