vmalert

Rule: PgbouncerClientQueueok

Expr

pgbouncer:db:waiting_clients > 1

For

60 seconds

Labels

category=pgsql level=0 severity=CRIT

Annotations

description:

pgbouncer:db:waiting_clients[ins={{ $labels.ins }}, instance={{ $labels.instance }}, datname={{ $labels.datname }}] = {{ $value | printf "%.0f" }} > 1

summary:

CRIT PgbouncerClientQueue: {{ $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-05-14T00:17:14+08:00	0.000s	2026-05-14T00:16:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A16%3A40%2B08%3A00'
2026-05-14T00:17:04+08:00	0.000s	2026-05-14T00:16:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A16%3A30%2B08%3A00'
2026-05-14T00:16:54+08:00	0.001s	2026-05-14T00:16:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A16%3A20%2B08%3A00'
2026-05-14T00:16:44+08:00	0.000s	2026-05-14T00:16:10+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A16%3A10%2B08%3A00'
2026-05-14T00:16:34+08:00	0.000s	2026-05-14T00:16:00+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A16%3A00%2B08%3A00'
2026-05-14T00:16:24+08:00	0.000s	2026-05-14T00:15:50+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A15%3A50%2B08%3A00'
2026-05-14T00:16:14+08:00	0.000s	2026-05-14T00:15:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A15%3A40%2B08%3A00'
2026-05-14T00:16:04+08:00	0.000s	2026-05-14T00:15:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A15%3A30%2B08%3A00'
2026-05-14T00:15:54+08:00	0.000s	2026-05-14T00:15:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A15%3A20%2B08%3A00'
2026-05-14T00:15:44+08:00	0.000s	2026-05-14T00:15:10+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A15%3A10%2B08%3A00'
2026-05-14T00:15:34+08:00	0.000s	2026-05-14T00:15:00+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A15%3A00%2B08%3A00'
2026-05-14T00:15:24+08:00	0.000s	2026-05-14T00:14:50+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A14%3A50%2B08%3A00'
2026-05-14T00:15:14+08:00	0.000s	2026-05-14T00:14:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A14%3A40%2B08%3A00'
2026-05-14T00:15:04+08:00	0.000s	2026-05-14T00:14:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A14%3A30%2B08%3A00'
2026-05-14T00:14:54+08:00	0.000s	2026-05-14T00:14:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A14%3A20%2B08%3A00'
2026-05-14T00:14:44+08:00	0.000s	2026-05-14T00:14:10+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A14%3A10%2B08%3A00'
2026-05-14T00:14:34+08:00	0.001s	2026-05-14T00:14:00+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A14%3A00%2B08%3A00'
2026-05-14T00:14:24+08:00	0.000s	2026-05-14T00:13:50+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A13%3A50%2B08%3A00'
2026-05-14T00:14:14+08:00	0.000s	2026-05-14T00:13:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A13%3A40%2B08%3A00'
2026-05-14T00:14:04+08:00	0.000s	2026-05-14T00:13:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pgbouncer%3Adb%3Awaiting_clients+%3E+1&step=300s&time=2026-05-14T00%3A13%3A30%2B08%3A00'