You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: documentation/metrics.md
+8-8Lines changed: 8 additions & 8 deletions
Original file line number
Diff line number
Diff line change
@@ -3274,7 +3274,7 @@ Default config:
3274
3274
</tr>
3275
3275
</table>
3276
3276
3277
-
*Access Exclusive* calculates as summa of locks from `pg_locks` with mode `Access Exclusive`.
3277
+
*Access Exclusive* calculates as summa of locks from `pg_locks` with mode `Access Exclusive`. Metric describes a total number of locks acquired (or waiting) by all queries like DROP TABLE, TRUNCATE, REINDEX, CLUSTER, VACUUM FULL, REFRESH MATERIALIZED VIEW, LOCK TABLE and some forms of ALTER INDEX and ALTER TABLE.
3278
3278
3279
3279
3280
3280
-**Access Share**
@@ -3307,7 +3307,7 @@ Default config:
3307
3307
</tr>
3308
3308
</table>
3309
3309
3310
-
*Access Share* calculates as summa of locks from `pg_locks` with mode `Access Share`.
3310
+
*Access Share* calculates as summa of locks from `pg_locks` with mode `Access Share`. Metric describes a total number of locks acquired (or waiting) by queries that only reads tables and do not modify.
3311
3311
3312
3312
3313
3313
-**Exclusive**
@@ -3340,7 +3340,7 @@ Default config:
3340
3340
</tr>
3341
3341
</table>
3342
3342
3343
-
*Exclusive* calculates as summa of locks from `pg_locks` with mode `Exclusive`.
3343
+
*Exclusive* calculates as summa of locks from `pg_locks` with mode `Exclusive`. Metric describes a total number of locks acquired (or waiting) by all queries like REFRESH MATERIALIZED VIEW CONCURRENTLY.
3344
3344
3345
3345
3346
3346
-**Row Exclusive**
@@ -3373,7 +3373,7 @@ Default config:
3373
3373
</tr>
3374
3374
</table>
3375
3375
3376
-
*Row Exclusive* calculates as summa of locks from `pg_locks` with mode `Row Exclusive`.
3376
+
*Row Exclusive* calculates as summa of locks from `pg_locks` with mode `Row Exclusive`. Metric describes a total number of locks acquired (or waiting) by all queries like UPDATE, DELETE, INSERT and MERGE.
3377
3377
3378
3378
3379
3379
-**Row Share**
@@ -3406,7 +3406,7 @@ Default config:
3406
3406
</tr>
3407
3407
</table>
3408
3408
3409
-
*Row Share* calculates as summa of locks from `pg_locks` with mode `Row Share`.
3409
+
*Row Share* calculates as summa of locks from `pg_locks` with mode `Row Share`. Metric describes a total number of locks acquired (or waiting) by all queries like SELECT FOR SHARE and SELECT FOR UPDATE.
3410
3410
3411
3411
3412
3412
-**Share Row Exclusive**
@@ -3439,7 +3439,7 @@ Default config:
3439
3439
</tr>
3440
3440
</table>
3441
3441
3442
-
*Share Row Exclusive* calculates as summa of locks from `pg_locks` with mode `Share Row Exclusive`.
3442
+
*Share Row Exclusive* calculates as summa of locks from `pg_locks` with mode `Share Row Exclusive`. Metric describes a total number of locks acquired (or waiting) by all queries like CREATE TRIGGER and some forms of ALTER TABLE.
3443
3443
3444
3444
3445
3445
-**Share Update Exclusive**
@@ -3472,7 +3472,7 @@ Default config:
3472
3472
</tr>
3473
3473
</table>
3474
3474
3475
-
*Share Update Exclusive* calculates as summa of locks from `pg_locks` with mode `Share Update Exclusive`.
3475
+
*Share Update Exclusive* calculates as summa of locks from `pg_locks` with mode `Share Update Exclusive`. Metric describes a total number of locks acquired (or waiting) by all queries like VACUUM, ANALYZE, CREATE INDEX CONCURRENTLY, CREATE STATISTICS, COMMENT ON, REINDEX CONCURRENTLY, and some forms of ALTER INDEX and ALTER TABLE.
3476
3476
3477
3477
3478
3478
-**Share**
@@ -3505,7 +3505,7 @@ Default config:
3505
3505
</tr>
3506
3506
</table>
3507
3507
3508
-
*Share* calculates as summa of locks from `pg_locks` with mode `Share`.
3508
+
*Share* calculates as summa of locks from `pg_locks` with mode `Share`. Metric describes a total number of locks acquired (or waiting) by all queries like CREATE INDEX.
0 commit comments