From 16ae8dd1960a18f6c82973aab884a142a8901f54 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Wed, 17 May 2023 20:28:09 +0100 Subject: [PATCH] Reduce sensitivity of postgres idle transaction alert --- cookbooks/prometheus/templates/default/alert_rules.yml.erb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/cookbooks/prometheus/templates/default/alert_rules.yml.erb b/cookbooks/prometheus/templates/default/alert_rules.yml.erb index b53007521..521d2c92b 100644 --- a/cookbooks/prometheus/templates/default/alert_rules.yml.erb +++ b/cookbooks/prometheus/templates/default/alert_rules.yml.erb @@ -526,7 +526,7 @@ groups: annotations: queries: "{{ $value }}" - alert: postgresql idle transactions - expr: sum(pg_process_idle_seconds_count{state="idle in transaction"}) by (instance, server) > sum(pg_process_idle_seconds_bucket{state="idle in transaction",le="120"}) by (instance, server) + expr: sum(pg_process_idle_seconds_count{state="idle in transaction"}) by (instance, server) > sum(pg_process_idle_seconds_bucket{state="idle in transaction",le="300"}) by (instance, server) for: 5m labels: alertgroup: "{{ $labels.instance }}" -- 2.39.5