E.7. MON$RECORD

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

Prev	Up	Next
E.6. `MON$MEMORY_USAGE`	Home	E.8. `MON$STATEMENTS`