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-10-08T05:37:54-07:00	0.001s	2026-10-08T05:37:20-07: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-10-08T05%3A37%3A20-07%3A00'
2026-10-08T05:37:44-07:00	0.000s	2026-10-08T05:37:10-07: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-10-08T05%3A37%3A10-07%3A00'
2026-10-08T05:37:34-07:00	0.001s	2026-10-08T05:37:00-07: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-10-08T05%3A37%3A00-07%3A00'
2026-10-08T05:37:24-07:00	0.001s	2026-10-08T05:36:50-07: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-10-08T05%3A36%3A50-07%3A00'
2026-10-08T05:37:14-07:00	0.001s	2026-10-08T05:36:40-07: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-10-08T05%3A36%3A40-07%3A00'
2026-10-08T05:37:04-07:00	0.001s	2026-10-08T05:36:30-07: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-10-08T05%3A36%3A30-07%3A00'
2026-10-08T05:36:54-07:00	0.001s	2026-10-08T05:36:20-07: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-10-08T05%3A36%3A20-07%3A00'
2026-10-08T05:36:44-07:00	0.001s	2026-10-08T05:36:10-07: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-10-08T05%3A36%3A10-07%3A00'
2026-10-08T05:36:34-07:00	0.001s	2026-10-08T05:36:00-07: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-10-08T05%3A36%3A00-07%3A00'
2026-10-08T05:36:24-07:00	0.001s	2026-10-08T05:35:50-07: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-10-08T05%3A35%3A50-07%3A00'
2026-10-08T05:36:14-07:00	0.001s	2026-10-08T05:35:40-07: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-10-08T05%3A35%3A40-07%3A00'
2026-10-08T05:36:04-07:00	0.001s	2026-10-08T05:35:30-07: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-10-08T05%3A35%3A30-07%3A00'
2026-10-08T05:35:54-07:00	0.001s	2026-10-08T05:35:20-07: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-10-08T05%3A35%3A20-07%3A00'
2026-10-08T05:35:44-07:00	0.000s	2026-10-08T05:35:10-07: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-10-08T05%3A35%3A10-07%3A00'
2026-10-08T05:35:34-07:00	0.001s	2026-10-08T05:35:00-07: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-10-08T05%3A35%3A00-07%3A00'
2026-10-08T05:35:24-07:00	0.001s	2026-10-08T05:34:50-07: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-10-08T05%3A34%3A50-07%3A00'
2026-10-08T05:35:14-07:00	0.001s	2026-10-08T05:34:40-07: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-10-08T05%3A34%3A40-07%3A00'
2026-10-08T05:35:04-07:00	0.001s	2026-10-08T05:34:30-07: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-10-08T05%3A34%3A30-07%3A00'
2026-10-08T05:34:54-07:00	0.001s	2026-10-08T05:34:20-07: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-10-08T05%3A34%3A20-07%3A00'
2026-10-08T05:34:44-07:00	0.001s	2026-10-08T05:34:10-07: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-10-08T05%3A34%3A10-07%3A00'