The locklists table contains individual locklist statistics. Each active user/transaction has two locklists which are used to manage lock requests issued by the owner transaction. This table returns one row for each locklist in the current installation. The delta columns represent changes in counter values in the last interval.
| Attribute Name | Key | Datatype | Description |
| timestamp | 0 | date | Date and time the data was collected |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| delta_seconds | 0 | integer4 | Elapsed time (seconds) since the previous refresh. |
| 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_locklists | 0 | integer4 | Count of locklists connected to the current locklist. |
| 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 related locklist count in the last interval. |
| related_llb | 0 | integer4 | Identifier of the related locklist. |
| search_count | 0 | integer4 | Most recent deadlock search performed on the locklist. |
| 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) | Locklist status. |
| status | 0 | integer4 | Numeric locklist status. |
| tick | 0 | integer4 | Current clock tick at start of global deadlock search. |