[PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope

From: Tatsuya Kawata <kawatatatsuya0913(at)gmail(dot)com>
To: Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope
Date: 2026-06-13 04:15:49
Message-ID: CAHza6qdKo9dcPy70QBi88vpqhS2gYWViS8=Uj=-+QQbR=ONgSQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

While developing the pg_stat_lock improvement proposed in (*1), I
noticed that the documentation of the fastpath_exceeded column in
pg_stat_lock could be more explicit about its scope.

The current documentation describes it as:

Number of times a lock of this type could not be acquired via fast
path because the fast path slot limit was exceeded. Increasing
max_locks_per_transaction can reduce this number.

This omits the fact that fast-path locking only applies to relation
locks acquired in the weak modes (AccessShareLock, RowShareLock,
RowExclusiveLock), so the counter is always zero for any other
locktype.

The attached patch adds a short clarification to the pg_stat_lock entry
in monitoring.sgml.

(*1) [PATCH] pg_stat_lock: add blocker mode dimension
https://www.postgresql.org/message-id/flat/CAHza6qeixfLeM3AqEkjgkE%2BBAqxB%3D5p227fo6JR60cG4mj8O8A%40mail.gmail.com#3592fb428248b200452b900468dc6d65

Regards,
Tatsuya Kawata

Attachment Content-Type Size
v1-0001-doc-clarify-pg_stat_lock.fastpath_exceeded-scope.patch application/octet-stream 1.6 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-06-13 06:01:40 Re: Fix SET EXPRESSION for virtual columns with whole-row dependencies
Previous Message Tatsuya Kawata 2026-06-13 03:13:04 Re: [PATCH] pg_stat_lock: add blocker mode dimension