Graph information
PostgreSQL locks
| Field | Internal name | Type | Warning | Critical | Info |
|---|---|---|---|---|---|
| AccessShareLock | accesssharelock | gauge | Used by read only queries | ||
| RowShareLock | rowsharelock | gauge | Used by SELECT FOR SHARE and SELECT FOR UPDATE queries | ||
| RowExclusiveLock | rowexclusivelock | gauge | Used by UPDATE, DELETE and INSERT queries | ||
| ShareUpdateExclusiveLock | shareupdateexclusivelock | gauge | Used by VACUUM, ANALYZE and CREATE INDEX CONCURRENTLY queries | ||
| ShareLock | sharelock | gauge | Used by CREATE INDEX queries | ||
| ShareRowExclusiveLock | sharerowexclusivelock | gauge | Only issued explicitly from applications | ||
| ExclusiveLock | exclusivelock | gauge | Infrequently issued on system tables, or by applications | ||
| AccessExclusiveLock | accessexclusivelock | gauge | Used by ALTER TABLE, DROP TABLE, TRUNCATE, REINDEX, CLUSTER and VACUUM FULL queries |
Zooming is very easy, it's done in 3 clicks (regular clicks, no drag&drop):
- Click to define the start of zoom.
- Click to define the ending of zoom.
- Refresh.
You can use the interactive form too.