The logging_stats table contains logging system activity statistics for the current installation. One row is returned for each vnode in the current IMA management domain. 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 |
| delta_seconds | 0 | integer4 | Elapsed time (seconds) since the previous refresh. |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| dual_read_ios | 0 | integer4 | Count read operations from the dual transaction log since installation startup. |
| dual_read_ios_d | 0 | integer4 | Count of read operations from the dual transaction log in the last interval. |
| dual_write_ios | 0 | integer4 | Count of write operations to the dual transaction log since installation startup. |
| dual_write_ios_d | 0 | integer4 | Count of write operations to the dual transaction log in the last interval. |
| txn_ends | 0 | integer4 | Count of transactions completed since installation startup. |
| txn_ends_d | 0 | integer4 | Count of transactions completed in the last interval. |
| log_forces | 0 | integer4 | Count of force operations to the current transaction log since installation startup. |
| log_forces_d | 0 | integer4 | Count of force operations to the current transaction log in the last interval. |
| kbytes | 0 | integer4 | Measure of logging data written to the transaction log since installation startup, units are Kbytes. |
| kbytes_d | 0 | integer4 | Measure of logging data written to the transaction log in the last interval, units are Kbytes. |
| log_read_ios | 0 | integer4 | Count of read operations from the primary transaction log since installation startup. |
| log_read_ios_d | 0 | integer4 | Count of read operations from the primary transaction log in the last interval. |
| log_write_ios | 0 | integer4 | Count of physical writes to the primary transaction log. |
| log_write_ios_d | 0 | integer4 | Count of physical writes to the primary transaction log in the last interval. |
| split_waits | 0 | integer4 | Count of log waits initiated by split write operations. |
| split_waits_d | 0 | integer4 | Count of log waits initiated by split write operations in the last interval. |
| log_waits | 0 | integer4 | Count of log wait operations since installation startup. |
| log_waits_d | 0 | integer4 | Count of log wait operations in the last interval. |
| log_writes | 0 | integer4 | Count of logical writes to logging system buffers. |
| log_writes_d | 0 | integer4 | Count of logical writes to logging system buffers in the last interval. |
| writeio | 0 | integer4 | Count of physical writes to the transaction log. |
| writeio_d | 0 | integer4 | Count of physical writes to the transaction log in the last interval. |
| prim_last_block | 0 | integer4 | Most recent block written to the primary transaction log. |
| dual_last_block | 0 | integer4 | Last block read or written to/from the primary transaction log. |
| lfbb_size | 0 | integer4 | Maximum number of log file blocks which can be allocated by the logging system. |
| ldb_inuse | 0 | integer4 | Number of log database blocks currently in use, this is the number of open databases. |
| ldbb_count | 0 | integer4 | Number of log database blocks allocated by the logging system. |
| lfbb_count | 0 | integer4 | Count of lof file block allocated by the logging system. |
| lpb_inuse | 0 | integer4 | Count of log process blocks currently in use. |
| lpb_allocated | 0 | integer4 | Count of log process blocks allocated by the logging system. |
| lpd_inuse | 0 | integer4 | Count of log process database blocks currently in use. |
| lpd_allocated | 0 | integer4 | Count of log process database blocks allocated by the logging system. |
| lxb_inuse | 0 | integer4 | Count of transaction blocks currently in use. |
| lxbb_allocated | 0 | integer4 | Count of transaction blocks allocated by the logging system. |
| no_bcp | 0 | integer4 | If 1, consistency point is in progress and a new one cannot be started. |
| protect_count | 0 | integer4 | Current count of protect transactions, that is transactions which must be rolled back if aborted. |
| db_add | 0 | integer4 | Count of database add operations since installation startup. |
| db_add_d | 0 | integer4 | Count of database add operations in the last interval. |
| bcp_stall_waits | 0 | integer4 | Log stalls caused by BCP (begin consistency point) writes. |
| bcp_stall_waits_d | 0 | integer4 | Log stalls caused by BCP (begin consistency point) writes in the last interval. |
| txn_begins | 0 | integer4 | Count of transactions started since installation startup. |
| txn_begins_d | 0 | integer4 | Count of transactions started in the last interval. |
| dual_readio | 0 | integer4 | Count of read operations from the dual transaction log since installation startup. |
| dual_readio_d | 0 | integer4 | Count of read operations from the dual transaction log in the last interval. |
| dual_writeio | 0 | integer4 | Count of write operations to the dual transaction log since installation startup. |
| dual_writeio_d | 0 | integer4 | Count of write operations to the dual transaction log in the last interval. |
| lgd_txn_ends | 0 | integer4 | Count of transactions completed by the logging system since installation startup. |
| lgd_txn_ends_d | 0 | integer4 | Count of transactions completed by the logging system in the last interval. |
| force | 0 | integer4 | Count of log buffers forced to the transaction log. |
| force_d | 0 | integer4 | Count of log buffers forced to the transaction log in the last interval. |
| free_waits | 0 | integer4 | Count of waits for free log buffers since installation startup. |
| free_waits_d | 0 | integer4 | Count of waits for free log buffers in the last interval. |
| group_count | 0 | integer4 | Count of log buffers written during group commit processing. |
| group_count_d | 0 | integer4 | Count of log buffers written during group commit processing in the last interval. |
| group_force | 0 | integer4 | Count of log buffers forced to the transaction log during group commit processing. |
| group_force_d | 0 | integer4 | Count of log buffers forced to the transaction log during group commit processing in the last interval. |
| inconsistent_db | 0 | integer4 | Count of databases marked inconsistent since installation startup. |
| inconsistent_db_d | 0 | integer4 | Count of databases marked inconsistent in the last interval. |
| kbytes_written | 0 | integer4 | Measure of logging data written to all active transaction logs since installation startup, units are Kbytes. |
| kbytes_written_d | 0 | integer4 | Measure of logging data written to all active transaction logs in the last interval, units are Kbytes. |
| log_readio | 0 | integer4 | Count of read operations from all configured transaction logs since installation startup. |
| log_readio_d | 0 | integer4 | Count of read operations from all configured transaction logs in the last interval. |
| log_writeio | 0 | integer4 | Count of physical writes to the transaction log. |
| log_writeio_d | 0 | integer4 | Count of physical writes to the transaction log in the last interval. |
| pgyback_check | 0 | integer4 | Count of piggyback write checks since installation startup. |
| pgyback_check_d | 0 | integer4 | Count of piggyback write checks in the last interval. |
| pgyback_write | 0 | integer4 | Count of write operations initiated by piggyback write. |
| pgyback_write_d | 0 | integer4 | Count of write operations initiated by piggyback write in the last interval. |
| readio | 0 | integer4 | Count of physical read operations from the transaction log. |
| readio_d | 0 | integer4 | Count of physical read operations from the transaction log in the last interval. |
| db_remove | 0 | integer4 | Count of database remove operations since installation startup. |
| db_remove_d | 0 | integer4 | Count of database remove operations in the last interval. |
| split | 0 | integer4 | Count of split write operations since installation startup. |
| split_d | 0 | integer4 | Count of split write operations in the last interval. |
| stall_wait | 0 | integer4 | Count of log write operations stalled. |
| stall_wait_d | 0 | integer4 | Count of log write operations stalled in the last interval. |
| wait | 0 | integer4 | Count of log waits since installation startup. |
| wait_d | 0 | integer4 | Count of log waits in the last interval. |
| log_write | 0 | integer4 | Count of logical log writes performed since installation startup. |
| log_write_d | 0 | integer4 | Count of logical log writes performed in the last interval. |
| lgd_writeio | 0 | integer4 | Count of physical writes to all transaction logs performed by the logging system since installation startup. |
| lgd_writeio_d | 0 | integer4 | Count of physical writes to all transaction logs performed by the logging system in the last interval. |