vmalert

Rule: PostgresConnUsageHighok

Expr

pg:db:conn_usage > 0.70

For

180 seconds

Labels

category=pgsql level=1 severity=WARN

Annotations

description:

pg:db:conn_usage[ins={{ $labels.ins }}, instance={{ $labels.instance }}, datname={{ $labels.datname }}] = {{ $value | printf "%.3f" }} > 0.70

summary:

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

Debug

false

Group

8916821703685786351

Last 20/20 updates:

Updated at	Series fetched	Duration	Execution timestamp	cURL
2026-05-12T05:52:04+08:00	4	0.001s	2026-05-12T05:51:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A51%3A30%2B08%3A00'
2026-05-12T05:51:54+08:00	4	0.001s	2026-05-12T05:51:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A51%3A20%2B08%3A00'
2026-05-12T05:51:44+08:00	4	0.001s	2026-05-12T05:51:10+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A51%3A10%2B08%3A00'
2026-05-12T05:51:34+08:00	4	0.001s	2026-05-12T05:51:00+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A51%3A00%2B08%3A00'
2026-05-12T05:51:24+08:00	4	0.001s	2026-05-12T05:50:50+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A50%3A50%2B08%3A00'
2026-05-12T05:51:14+08:00	4	0.001s	2026-05-12T05:50:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A50%3A40%2B08%3A00'
2026-05-12T05:51:04+08:00	4	0.001s	2026-05-12T05:50:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A50%3A30%2B08%3A00'
2026-05-12T05:50:54+08:00	4	0.001s	2026-05-12T05:50:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A50%3A20%2B08%3A00'
2026-05-12T05:50:44+08:00	4	0.001s	2026-05-12T05:50:10+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A50%3A10%2B08%3A00'
2026-05-12T05:50:34+08:00	4	0.001s	2026-05-12T05:50:00+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A50%3A00%2B08%3A00'
2026-05-12T05:50:24+08:00	4	0.001s	2026-05-12T05:49:50+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A49%3A50%2B08%3A00'
2026-05-12T05:50:14+08:00	4	0.001s	2026-05-12T05:49:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A49%3A40%2B08%3A00'
2026-05-12T05:50:04+08:00	4	0.001s	2026-05-12T05:49:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A49%3A30%2B08%3A00'
2026-05-12T05:49:54+08:00	4	0.001s	2026-05-12T05:49:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A49%3A20%2B08%3A00'
2026-05-12T05:49:44+08:00	4	0.001s	2026-05-12T05:49:10+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A49%3A10%2B08%3A00'
2026-05-12T05:49:34+08:00	4	0.001s	2026-05-12T05:49:00+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A49%3A00%2B08%3A00'
2026-05-12T05:49:24+08:00	4	0.001s	2026-05-12T05:48:50+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A48%3A50%2B08%3A00'
2026-05-12T05:49:14+08:00	4	0.001s	2026-05-12T05:48:40+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A48%3A40%2B08%3A00'
2026-05-12T05:49:04+08:00	4	0.001s	2026-05-12T05:48:30+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A48%3A30%2B08%3A00'
2026-05-12T05:48:54+08:00	4	0.001s	2026-05-12T05:48:20+08:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aconn_usage+%3E+0.70&step=300s&time=2026-05-12T05%3A48%3A20%2B08%3A00'