vmalert

Rule: PostgresIdleInXactok

Expr

pg:db:ixact_backends > 1

For

180 seconds

Labels

category=pgsql level=2 severity=INFO

Annotations

description:

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

summary:

Info PostgresIdleInXact: {{ $labels.ins }}@{{ $labels.instance }} [{{ $labels.datname }}]

Debug

false

Group

8916821703685786351

Last 20/20 updates:

Updated at	Series fetched	Duration	Execution timestamp	cURL
2026-07-15T10:03:14Z	2	0.001s	2026-07-15T10:02:40Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A02%3A40Z'
2026-07-15T10:03:04Z	2	0.001s	2026-07-15T10:02:30Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A02%3A30Z'
2026-07-15T10:02:54Z	2	0.001s	2026-07-15T10:02:20Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A02%3A20Z'
2026-07-15T10:02:44Z	2	0.001s	2026-07-15T10:02:10Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A02%3A10Z'
2026-07-15T10:02:34Z	2	0.000s	2026-07-15T10:02:00Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A02%3A00Z'
2026-07-15T10:02:24Z	2	0.001s	2026-07-15T10:01:50Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A01%3A50Z'
2026-07-15T10:02:14Z	2	0.001s	2026-07-15T10:01:40Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A01%3A40Z'
2026-07-15T10:02:04Z	2	0.001s	2026-07-15T10:01:30Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A01%3A30Z'
2026-07-15T10:01:54Z	2	0.000s	2026-07-15T10:01:20Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A01%3A20Z'
2026-07-15T10:01:44Z	2	0.001s	2026-07-15T10:01:10Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A01%3A10Z'
2026-07-15T10:01:34Z	2	0.000s	2026-07-15T10:01:00Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A01%3A00Z'
2026-07-15T10:01:24Z	2	0.001s	2026-07-15T10:00:50Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A00%3A50Z'
2026-07-15T10:01:14Z	2	0.001s	2026-07-15T10:00:40Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A00%3A40Z'
2026-07-15T10:01:04Z	2	0.001s	2026-07-15T10:00:30Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A00%3A30Z'
2026-07-15T10:00:54Z	2	0.002s	2026-07-15T10:00:20Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A00%3A20Z'
2026-07-15T10:00:44Z	2	0.000s	2026-07-15T10:00:10Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A00%3A10Z'
2026-07-15T10:00:34Z	2	0.001s	2026-07-15T10:00:00Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T10%3A00%3A00Z'
2026-07-15T10:00:24Z	2	0.000s	2026-07-15T09:59:50Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T09%3A59%3A50Z'
2026-07-15T10:00:14Z	2	0.001s	2026-07-15T09:59:40Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T09%3A59%3A40Z'
2026-07-15T10:00:04Z	2	0.001s	2026-07-15T09:59:30Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=pg%3Adb%3Aixact_backends+%3E+1&step=300s&time=2026-07-15T09%3A59%3A30Z'