Add pg_stat_database_conflicts

[ylacancellera]

https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-DATABASE-CONFLICTS-VIEW

It could be done only for replicas

[jobinau]

I don't know whether standby-side conflicts are a common trouble. If yes, we shall prioritize this.
So your feedback is important.
I want to avoid creating another table to hold this information. So thinking of collecting this information into another set of columns of pg_get_db

[ylacancellera]

This could be limited to a hover text in the database table
It's not critically important, it's just a piece of information that ended up necessary to get separately and I thought pg_gather could easily store it

[MichaelDBA]

Pg_stats_database is such a generalized metrics table that I don’t know how useful it would be. perhaps as a reference point over time?