The wait_locklists table is the collection of locklists currently in a lock wait state. This table simplifies the process of detecting and identifying users waiting on lock requests.
| Attribute Name | Key | Datatype | Description |
| timestamp | 0 | date | Date and time the data was collected |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| locklist_id | 2 | integer4 | Internal numeric locklist identifier |
| related_list_id | 0 | integer4 | Internal identifier of the related lock list, each session has two locklists |
| waiting_lock_id_id | 0 | integer4 | Internal identifier of the lock this locklist is waiting on, the blocking lock |
| max_locks | 0 | integer4 | Maximum number of locks allowed by this locklists, the transaction lock limit |
| lock_count | 0 | integer4 | Number of locks currently on the list |
| lock_count_d | 0 | integer4 | Number of locks acquired in the last interval |
| logical_count | 0 | integer4 | Number of logical locks on the list |
| logical_count_d | 0 | integer4 | Number of logical locks acquired int the last interval |
| server_pid | 0 | integer4 | Operating system process id of the server |
| session_id | 0 | varchar(32) | Internal identifier of the database server session |
| connected_wait_locklists | 0 | integer4 | Count of waiting locklists. |
| evflags | 0 | integer4 | Wait event flags. |
| ev_stamp | 0 | integer4 | Lock wait queue sequence stamp. |
| name0 | 0 | integer4 | Low order part of locklist identifier. |
| name1 | 0 | integer4 | High order part of locklist identifier. |
| related_count | 0 | integer4 | Count of related locklists. |
| related_count_d | 0 | integer4 | Change in count of related locklists in the last interval. |
| related_llb | 0 | integer4 | Internal identifier of the related locklist. |
| search_count | 0 | integer4 | Most recent deadlock search performed on the locklists. |
| search_count_d | 0 | integer4 | Change in count of deadlock searches performed in the last interval. |
| stamp | 0 | integer4 | Current lock request stamp. |
| status_s | 0 | varchar(64) | Current locklist status. |
| status | 0 | integer4 | Numeric locklist status. |
| tick | 0 | integer4 | Current clock tick at start of global deadlock search. |