Index activity (_ActIndex)

The _ActIndex VST displays index activity, such as the number of entry finds, creates, and deletes, the number of locked entries removed, and the numbers of split and free blocks.1

Field name Data type Description
_Index-Create INT64 Number of new index entries generated
_Index-Delete INT64 Number of index entries deleted
_Index-Find INT64 Number of times an index entry was looked up
_Index-Free INT64 Number of index blocks freed during deletes
_Index-PartitionId INTEGER Partition Id of the index
_Index-Remove INT64 Number of locks released at transaction end
_Index-Splits INT64 Number of block splits resulting from index additions
_Index-Trans INT64 Number of transactions committed
_Index-UpTime INTEGER Number of seconds the database was up