E.7 MON$RECORD_STATS

MON$RECORD_STATS displays record-level statistics. The counters are cumulative, by group, for each group of statistics.

Column Name Data Type Description
MON$STAT_ID INTEGER Statistics identifier
MON$STAT_GROUP SMALLINT Statistics group: 0 - database 1 - connection 2 - transaction 3 - statement 4 - call
MON$RECORD_SEQ_READS BIGINT Count of records read sequentially
MON$RECORD_IDX_READS BIGINT Count of records read via an index
MON$RECORD_INSERTS BIGINT Count of inserted records
MON$RECORD_UPDATES BIGINT Count of updated records
MON$RECORD_DELETES BIGINT Count of deleted records
MON$RECORD_BACKOUTS BIGINT Count of records backed out
MON$RECORD_PURGES BIGINT Count of records purged
MON$RECORD_EXPUNGES BIGINT Count of records expunged
MON$RECORD_LOCKS BIGINT Number of records locked
MON$RECORD_WAITS BIGINT Number of update, delete or lock attempts on records owned by other active transactions. Transaction is in WAIT mode.
MON$RECORD_CONFLICTS BIGINT Number of unsuccessful update, delete or lock attempts on records owned by other active transactions. These are reported as update conflicts.
MON$BACKVERSION_READS BIGINT Number of back-versions read to find visible records
MON$FRAGMENT_READS BIGINT Number of fragmented records read
MON$RECORD_RPT_READS BIGINT Number of repeated reads of records
MON$RECORD_IMGC BIGINT Number of records processed by the intermediate garbage collector