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-05-10T16:48:19+08:00	2	10	0.001s	2026-05-10T16:47: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-05-10T16%3A47%3A40%2B08%3A00'
2026-05-10T16:48:09+08:00	2	10	0.000s	2026-05-10T16:47: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-05-10T16%3A47%3A30%2B08%3A00'
2026-05-10T16:47:59+08:00	2	10	0.001s	2026-05-10T16:47: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-05-10T16%3A47%3A20%2B08%3A00'
2026-05-10T16:47:49+08:00	2	10	0.000s	2026-05-10T16:47: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-05-10T16%3A47%3A10%2B08%3A00'
2026-05-10T16:47:39+08:00	2	10	0.001s	2026-05-10T16:47: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-05-10T16%3A47%3A00%2B08%3A00'
2026-05-10T16:47:29+08:00	2	10	0.001s	2026-05-10T16:46: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-05-10T16%3A46%3A50%2B08%3A00'
2026-05-10T16:47:19+08:00	2	10	0.001s	2026-05-10T16:46: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-05-10T16%3A46%3A40%2B08%3A00'
2026-05-10T16:47:09+08:00	2	10	0.001s	2026-05-10T16:46: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-05-10T16%3A46%3A30%2B08%3A00'
2026-05-10T16:46:59+08:00	2	10	0.001s	2026-05-10T16:46: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-05-10T16%3A46%3A20%2B08%3A00'
2026-05-10T16:46:49+08:00	2	10	0.001s	2026-05-10T16:46: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-05-10T16%3A46%3A10%2B08%3A00'
2026-05-10T16:46:39+08:00	2	10	0.000s	2026-05-10T16:46: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-05-10T16%3A46%3A00%2B08%3A00'
2026-05-10T16:46:29+08:00	2	10	0.001s	2026-05-10T16:45: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-05-10T16%3A45%3A50%2B08%3A00'
2026-05-10T16:46:19+08:00	2	10	0.000s	2026-05-10T16:45: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-05-10T16%3A45%3A40%2B08%3A00'
2026-05-10T16:46:09+08:00	2	10	0.001s	2026-05-10T16:45: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-05-10T16%3A45%3A30%2B08%3A00'
2026-05-10T16:45:59+08:00	2	10	0.000s	2026-05-10T16:45: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-05-10T16%3A45%3A20%2B08%3A00'
2026-05-10T16:45:49+08:00	2	10	0.001s	2026-05-10T16:45: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-05-10T16%3A45%3A10%2B08%3A00'
2026-05-10T16:45:39+08:00	2	10	0.000s	2026-05-10T16:45: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-05-10T16%3A45%3A00%2B08%3A00'
2026-05-10T16:45:29+08:00	2	10	0.001s	2026-05-10T16:44: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-05-10T16%3A44%3A50%2B08%3A00'
2026-05-10T16:45:19+08:00	2	10	0.000s	2026-05-10T16:44: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-05-10T16%3A44%3A40%2B08%3A00'
2026-05-10T16:45:09+08:00	2	10	0.000s	2026-05-10T16:44: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-05-10T16%3A44%3A30%2B08%3A00'