Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceMonitoring Tables → MON$RECORD_STATS
Firebird Firebird Prev: MON$MEMORY_USAGEFirebird 2.5 Language ReferenceUp: Monitoring TablesNext: MON$STATEMENTS

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

Prev: MON$MEMORY_USAGEFirebird 2.5 Language ReferenceUp: Monitoring TablesNext: MON$STATEMENTS
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceMonitoring Tables → MON$RECORD_STATS