Skip to main content

transactionid

Short Description

Waiting for a transaction to finish.

Detailed Description

This wait is seen when the transaction is blocked by another transaction’s row lock. Row locks information is stored in the row itself and shows as “transactionid” wait.

How to reduce this wait

Make sure there are no long running transactions blocking your session. The blocking lock may be in this table, or in a table referenced by a foreign key.

PostgreSQL Docs - Wait Events of Type Lock

PostgreSQL Community - INSERTS waiting with wait_event is "transactionid"

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.