Horton

head-2-updates-locks.txt

text/plain

Download
Filename: head-2-updates-locks.txt
Type: text/plain
Part: 0
Message: Re: SUBTRANS: Minimizing calls to SubTransSetParent() 
 wait_event_type | wait_event |   locktype    |       mode       | database | relation | count
-----------------+------------+---------------+------------------+----------+----------+-------
 Client          | ClientRead | transactionid | ExclusiveLock    |          |          |    80
                 |            | relation      | AccessShareLock  |        0 |     2671 |     1
                 |            | relation      | AccessShareLock  |    16617 |    12222 |     1
                 |            | relation      | AccessShareLock  |        0 |     2676 |     1
                 |            | relation      | AccessShareLock  |    16617 |    12073 |     1
                 |            | relation      | AccessShareLock  |        0 |     2677 |     1
 Client          | ClientRead | relation      | RowExclusiveLock |    16617 |    16714 |     1
                 |            | relation      | AccessShareLock  |        0 |     1260 |     1
                 |            | virtualxid    | ExclusiveLock    |          |          |     1
                 |            | relation      | AccessShareLock  |        0 |     2672 |     1
                 |            | relation      | AccessShareLock  |        0 |     1262 |     1
 Client          | ClientRead | relation      | RowExclusiveLock |    16617 |    16728 |     1
 Client          | ClientRead | virtualxid    | ExclusiveLock    |          |          |     1