vmalert

Rule: pg:db:xlock_countok

Expr

sum without (mode) (pg_lock_count{mode!~"AccessShareLock|RowShareLock|RowExclusiveLock"})

Labels

Group

Last 20/20 updates:

Updated at	Series returned	Series fetched	Duration	Execution timestamp	cURL
2026-07-15T10:31:28Z	2	10	0.001s	2026-07-15T10:30:50Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A30%3A50Z'
2026-07-15T10:31:18Z	2	10	0.000s	2026-07-15T10:30:40Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A30%3A40Z'
2026-07-15T10:31:08Z	2	10	0.000s	2026-07-15T10:30:30Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A30%3A30Z'
2026-07-15T10:30:58Z	2	10	0.001s	2026-07-15T10:30:20Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A30%3A20Z'
2026-07-15T10:30:48Z	2	10	0.000s	2026-07-15T10:30:10Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A30%3A10Z'
2026-07-15T10:30:38Z	2	10	0.001s	2026-07-15T10:30:00Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A30%3A00Z'
2026-07-15T10:30:29Z	2	10	0.001s	2026-07-15T10:29:50Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A29%3A50Z'
2026-07-15T10:30:18Z	2	10	0.001s	2026-07-15T10:29:40Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A29%3A40Z'
2026-07-15T10:30:08Z	2	10	0.000s	2026-07-15T10:29:30Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A29%3A30Z'
2026-07-15T10:29:59Z	2	10	0.000s	2026-07-15T10:29:20Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A29%3A20Z'
2026-07-15T10:29:48Z	2	10	0.001s	2026-07-15T10:29:10Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A29%3A10Z'
2026-07-15T10:29:38Z	2	10	0.001s	2026-07-15T10:29:00Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A29%3A00Z'
2026-07-15T10:29:28Z	2	10	0.000s	2026-07-15T10:28:50Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A28%3A50Z'
2026-07-15T10:29:18Z	2	10	0.000s	2026-07-15T10:28:40Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A28%3A40Z'
2026-07-15T10:29:08Z	2	10	0.001s	2026-07-15T10:28:30Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A28%3A30Z'
2026-07-15T10:28:58Z	2	10	0.001s	2026-07-15T10:28:20Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A28%3A20Z'
2026-07-15T10:28:48Z	2	10	0.000s	2026-07-15T10:28:10Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A28%3A10Z'
2026-07-15T10:28:38Z	2	10	0.000s	2026-07-15T10:28:00Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A28%3A00Z'
2026-07-15T10:28:28Z	2	10	0.001s	2026-07-15T10:27:50Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A27%3A50Z'
2026-07-15T10:28:18Z	2	10	0.000s	2026-07-15T10:27:40Z	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=sum+without+%28mode%29+%28pg_lock_count%7Bmode%21~%22AccessShareLock%7CRowShareLock%7CRowExclusiveLock%22%7D%29&step=300s&time=2026-07-15T10%3A27%3A40Z'