E.9. MON$TABLE_STATS

MON$TABLE_STATS reports table-level statistics.

Column NameData TypeDescription

MON$STAT_ID

INTEGER

Statistics identifier

MON$STAT_GROUP

SMALLINT

Statistics group:

0 - database 1 - connection 2 - transaction 3 - statement 4 - call

MON$TABLE_NAME

CHAR(63)

Name of the table

MON$RECORD_STAT_ID

INTEGER

Link to MON$RECORD_STATS

Getting statistics at the record level for each table for the current connection 

   |SELECT
   |  t.mon$table_name,
   |  r.mon$record_inserts,
   |  r.mon$record_updates,
   |  r.mon$record_deletes,
   |  r.mon$record_backouts,
   |  r.mon$record_purges,
   |  r.mon$record_expunges,
   |  ------------------------
   |  r.mon$record_seq_reads,
   |  r.mon$record_idx_reads,
   |  r.mon$record_rpt_reads,
   |  r.mon$backversion_reads,
   |  r.mon$fragment_reads,
   |  ------------------------
   |  r.mon$record_locks,
   |  r.mon$record_waits,
   |  r.mon$record_conflicts,
   |  ------------------------
   |  a.mon$stat_id
   |FROM mon$record_stats r
   |JOIN mon$table_stats t ON r.mon$stat_id = t.mon$record_stat_id
   |JOIN mon$attachments a ON t.mon$stat_id = a.mon$stat_id
   |WHERE a.mon$attachment_id = CURRENT_CONNECTION