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.
Additional Links​
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.