September 4, 2025: PostgreSQL 18 RC 1 Released!
Supported Versions: Current (17) / 16
Development Versions: 18 / devel
66.2. Transactions and Locking
Prev Up Chapter 66. Transaction Processing Home Next

66.2. Transactions and Locking #

The transaction IDs of currently executing transactions are shown in pg_locks in columns virtualxid and transactionid. Read-only transactions will have virtualxids but NULL transactionids, while both columns will be set in read-write transactions.

Some lock types wait on virtualxid, while other types wait on transactionid. Row-level read and write locks are recorded directly in the locked rows and can be inspected using the pgrowlocks extension. Row-level read locks might also require the assignment of multixact IDs (mxid; see Section 24.1.5.1).


Prev Up Next
66.1. Transactions and Identifiers Home 66.3. Subtransactions

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

AltStyle によって変換されたページ (->オリジナル) /