Thread: Tracking the # of deadlocks

Tracking the # of deadlocks

From

Bill Moran

Date:

27 October 2010, 13:00:45

Does PG store the # of deadlocks internally anywhere?  (like it does
with statistics on how many UPDATE/SELECT/DELETE ops occur on each
table, for example)

I'd like to be tracking this, that way we have an easy way to know if
our software is hitting performance problems by having to retry deadlocked
transactions frequently.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

Re: Tracking the # of deadlocks

From

Scott Marlowe

Date:

27 October 2010, 13:25:12

On Wed, Oct 27, 2010 at 10:00 AM, Bill Moran <wmoran@potentialtech.com> wrote:
>
> Does PG store the # of deadlocks internally anywhere?  (like it does
> with statistics on how many UPDATE/SELECT/DELETE ops occur on each
> table, for example)

As far as I know they're only logged.