Seeing High number of rollback transactions in Postgres Database

[jaiganeshp]

Hello,

We are currently running the 2.0.8.2 version of ModelBD deployed locally and we are running into an issue where about 4% of transactions to the Postgres database are rolled back. We are monitoring our Postgres database using https://github.com/wrouesnel/postgres_exporter and tracking the metrics in Prometheus. I have attached a graph showing the ratio of the number of transactions rolled back to the number of transactions committed. It is about 0.04 which would roughly turn out to be 4% of the total transactions processed by the database. The Postgres exporter fetches these metrics from the pg_stat_table and Prometheus keeps track of these metrics over time.

Please let me know if you need any more information.

Thank you,
Jaiganesh