Обсуждение: Tracking the # of deadlocks

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/

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.