vmalert

Rule: PgbouncerQuerySlowok

Expr

pgbouncer:db:query_rt_1m > 0.016

For

180 seconds

Labels

category=pgsql level=1 severity=WARN

Annotations

description:

pgbouncer:db:query_rt_1m[ins={{ $labels.ins }}, instance={{ $labels.instance }}, datname={{ $labels.datname }}] = {{ $value | printf "%.3f" }} > 0.016

summary:

WARN PgbouncerQuerySlow: {{ $labels.ins }}@{{ $labels.instance }} [{{ $labels.datname }}]

Debug

false

Group

8916821703685786351

Warning: some of updates have "Series fetched" equal to 0.
It might be that either this data is missing in the datasource or there is a typo in rule's expression. For example, foo{label="bar"} > 0 could never trigger because foo{label="bar"} metric doesn't exist.
Rule's expressions without time series selector, like expr: 42 or expr: time() aren't fetching time series from datasource, so they could have "Series fetched" equal to 0 and this won't be a problem.
See more details about this detection here.

Last 20/20 updates:

Updated at	Duration	Execution timestamp	cURL
2026-02-15T22:43:14+08:00	0.000s	2026-02-15T22:42:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A42%3A40%2B08%3A00'
2026-02-15T22:43:04+08:00	0.000s	2026-02-15T22:42:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A42%3A30%2B08%3A00'
2026-02-15T22:42:54+08:00	0.000s	2026-02-15T22:42:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A42%3A20%2B08%3A00'
2026-02-15T22:42:44+08:00	0.000s	2026-02-15T22:42:10+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A42%3A10%2B08%3A00'
2026-02-15T22:42:34+08:00	0.000s	2026-02-15T22:42:00+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A42%3A00%2B08%3A00'
2026-02-15T22:42:24+08:00	0.000s	2026-02-15T22:41:50+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A41%3A50%2B08%3A00'
2026-02-15T22:42:14+08:00	0.000s	2026-02-15T22:41:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A41%3A40%2B08%3A00'
2026-02-15T22:42:04+08:00	0.000s	2026-02-15T22:41:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A41%3A30%2B08%3A00'
2026-02-15T22:41:54+08:00	0.000s	2026-02-15T22:41:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A41%3A20%2B08%3A00'
2026-02-15T22:41:44+08:00	0.000s	2026-02-15T22:41:10+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A41%3A10%2B08%3A00'
2026-02-15T22:41:34+08:00	0.000s	2026-02-15T22:41:00+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A41%3A00%2B08%3A00'
2026-02-15T22:41:24+08:00	0.000s	2026-02-15T22:40:50+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A40%3A50%2B08%3A00'
2026-02-15T22:41:14+08:00	0.004s	2026-02-15T22:40:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A40%3A40%2B08%3A00'
2026-02-15T22:41:04+08:00	0.000s	2026-02-15T22:40:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A40%3A30%2B08%3A00'
2026-02-15T22:40:54+08:00	0.000s	2026-02-15T22:40:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A40%3A20%2B08%3A00'
2026-02-15T22:40:44+08:00	0.000s	2026-02-15T22:40:10+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A40%3A10%2B08%3A00'
2026-02-15T22:40:34+08:00	0.000s	2026-02-15T22:40:00+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A40%3A00%2B08%3A00'
2026-02-15T22:40:24+08:00	0.000s	2026-02-15T22:39:50+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A39%3A50%2B08%3A00'
2026-02-15T22:40:14+08:00	0.000s	2026-02-15T22:39:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A39%3A40%2B08%3A00'
2026-02-15T22:40:04+08:00	0.002s	2026-02-15T22:39:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Aquery_rt_1m+%3E+0.016&step=300s&time=2026-02-15T22%3A39%3A30%2B08%3A00'