Horton

patch-2-updates-locks.txt

text/plain

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