1

I have added 10 replicas of pgbouncer with prometheus exporter as sidecar with a deployment manifest, and this grafana chart is showing the following prom query:

sort_desc( sum by (database, pod) ( rate(pgbouncer_stats_transactions_total{database=~"$db"}[1m]) ) )

I'm confused on why this metric keeps going up for 5 days straight, can you point me to what's wrong with the query.

enter image description here

pgbouncer-exporter repo

Kaizendae
  • 853
  • 11
  • 24

1 Answers1

0

I recommend

sum(rate(pgbouncer_stats_transactions_total{database=~"$db"}[$__rate_interval])) by (database)
Yunnosch
  • 26,130
  • 9
  • 42
  • 54
Ibb
  • 1
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Nov 01 '22 at 08:14