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-02-14T22:27:09+08:00	2	10	0.000s	2026-02-14T22:26:30+08:00	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-02-14T22%3A26%3A30%2B08%3A00'
2026-02-14T22:26:59+08:00	2	10	0.000s	2026-02-14T22:26:20+08:00	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-02-14T22%3A26%3A20%2B08%3A00'
2026-02-14T22:26:49+08:00	2	10	0.000s	2026-02-14T22:26:10+08:00	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-02-14T22%3A26%3A10%2B08%3A00'
2026-02-14T22:26:39+08:00	2	10	0.000s	2026-02-14T22:26:00+08:00	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-02-14T22%3A26%3A00%2B08%3A00'
2026-02-14T22:26:29+08:00	2	10	0.001s	2026-02-14T22:25:50+08:00	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-02-14T22%3A25%3A50%2B08%3A00'
2026-02-14T22:26:19+08:00	2	10	0.001s	2026-02-14T22:25:40+08:00	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-02-14T22%3A25%3A40%2B08%3A00'
2026-02-14T22:26:09+08:00	2	10	0.000s	2026-02-14T22:25:30+08:00	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-02-14T22%3A25%3A30%2B08%3A00'
2026-02-14T22:25:59+08:00	2	10	0.000s	2026-02-14T22:25:20+08:00	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-02-14T22%3A25%3A20%2B08%3A00'
2026-02-14T22:25:49+08:00	2	10	0.001s	2026-02-14T22:25:10+08:00	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-02-14T22%3A25%3A10%2B08%3A00'
2026-02-14T22:25:39+08:00	2	10	0.000s	2026-02-14T22:25:00+08:00	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-02-14T22%3A25%3A00%2B08%3A00'
2026-02-14T22:25:29+08:00	2	10	0.000s	2026-02-14T22:24:50+08:00	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-02-14T22%3A24%3A50%2B08%3A00'
2026-02-14T22:25:19+08:00	2	10	0.000s	2026-02-14T22:24:40+08:00	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-02-14T22%3A24%3A40%2B08%3A00'
2026-02-14T22:25:09+08:00	2	10	0.000s	2026-02-14T22:24:30+08:00	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-02-14T22%3A24%3A30%2B08%3A00'
2026-02-14T22:24:59+08:00	2	10	0.000s	2026-02-14T22:24:20+08:00	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-02-14T22%3A24%3A20%2B08%3A00'
2026-02-14T22:24:49+08:00	2	10	0.000s	2026-02-14T22:24:10+08:00	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-02-14T22%3A24%3A10%2B08%3A00'
2026-02-14T22:24:39+08:00	2	10	0.000s	2026-02-14T22:24:00+08:00	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-02-14T22%3A24%3A00%2B08%3A00'
2026-02-14T22:24:29+08:00	2	10	0.000s	2026-02-14T22:23:50+08:00	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-02-14T22%3A23%3A50%2B08%3A00'
2026-02-14T22:24:19+08:00	2	10	0.001s	2026-02-14T22:23:40+08:00	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-02-14T22%3A23%3A40%2B08%3A00'
2026-02-14T22:24:09+08:00	2	10	0.001s	2026-02-14T22:23:30+08:00	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-02-14T22%3A23%3A30%2B08%3A00'
2026-02-14T22:23:59+08:00	2	10	0.000s	2026-02-14T22:23:20+08:00	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-02-14T22%3A23%3A20%2B08%3A00'