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.