[receiver/postgresql] Additional metric: deadlocks.

[bjandras]

Component(s)

receiver/postgresql

Is your feature request related to a problem? Please describe.

When monitoring a PostgreSQL database, a useful metric is the number of deadlocks detected in each database.

Describe the solution you'd like

The postgresql receiver already queries the pg_stat_database table for information on transactions commited and rolled-back. I would add deadlocks as additional database stat in getDatabaseStats and emit it as postgresql.deadlocks metric.

Describe alternatives you've considered

No response

Additional context

No response

[github-actions]

Pinging code owners:

• receiver/postgresql: @djaglowski

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[github-actions]

Pinging code owners for receiver/postgresql: @djaglowski. See Adding Labels via Comments if you do not have permissions to add labels yourself.