The log_procs table contains logging system statistics specific to each server registered with the logging system. One row is returned for each registered logging system server, this includes the archive, recovery, and database servers. Delta columns represent changes in counter values since 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. |
| lpb_index | 2 | integer4 | Internal log process block identifier. |
| buffer_mgr_id | 0 | integer4 | Internal identifier of the buffer manager used by the server. |
| cond | 0 | integer4 | Fast commit server condition, 1 LPB_CPREADY, 2 LPB_CPWAIT, 3 LPB_RECOVER. |
| force_abort_sid | 0 | integer4 | Session id of the servers Force Abort Thread. |
| gcmt_asleep | 0 | integer4 | Group commit thread sleep counter. |
| gcmt_sid | 0 | integer4 | Session id for the server Group Commit Thread. |
| instance | 0 | integer4 | Internal instance identifier for the process block. |
| lpd_count | 0 | integer4 | Count of databases currently opened by the server. |
| lpd_count_d | 0 | integer4 | Change in the open database count in the last interval. |
| pid | 0 | integer4 | Operating system process id for the server. |
| txn_begins | 0 | integer4 | Count of transactions started by the server. |
| txn_begins_d | 0 | integer4 | Count of transactions started by the server in the last interval. |
| txn_ends | 0 | integer4 | Count of transactions completed by the server. |
| txn_ends_d | 0 | integer4 | Count of transactions completed by the server in the last interval. |
| log_forces | 0 | integer4 | Count of log force operations performed by the server. |
| log_forces_d | 0 | integer4 | Count of log force operations performed by the server in the last interval. |
| log_readios | 0 | integer4 | Count of log read operations performed by the server. |
| log_readios_d | 0 | integer4 | Count of log read operations performed by the server in the last interval. |
| log_waits | 0 | integer4 | Count of log waits for the server. |
| log_waits_d | 0 | integer4 | Count of log waits for the server in the last interval. |
| log_writes | 0 | integer4 | Count of logical log write operations initiated by the server. |
| log_writes_d | 0 | integer4 | Count of logical log write operations initiated by the server in the last interval. |
| lpb_status_s | 0 | varchar(64) | Server status string. |
| lpb_status | 0 | integer4 | Numeric status for server. |