Re: TODO request: log_long_transaction - Mailing list pgsql-hackers

From Thom Brown
Subject Re: TODO request: log_long_transaction
Date
Msg-id CAA-aLv7z8umTL_cP0ewTzu0JvQzQmZCNaSNzOCAQSsGb2qYjEA@mail.gmail.com
Whole thread Raw
In response to TODO request: log_long_transaction  (Josh Berkus <josh@agliodbs.com>)
Responses Re: TODO request: log_long_transaction
List pgsql-hackers
On 27 October 2014 19:21, Josh Berkus <josh@agliodbs.com> wrote:
Hackers,

I just realized that there is one thing we can't log currently:
transactions which last more than #ms.  This is valuable diagnostic
information when looking for issues like causes of bloat and deadlocks.

I'd like it to be on the TODO list because it seems like part of a good
GSOC project or first-time contribution.

So effectively, log_min_duration_transaction?  Sounds useful.

Thom

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: TODO request: log_long_transaction
Next
From: Tom Lane
Date:
Subject: Reducing the cost of sinval messaging