Index statistics (_IndexStat)

The _IndexStat VST displays statistics on the number of accesses to a specific range of indexes.1

Field name Data type Description
_IndexStat-Blockdelete INT64 Number of block deletes that have occurred to the index
_IndexStat-Delete INT64 Number of times delete access has occurred to the index
_IndexStat-Create INT64 Number of times create access has occurred to the index
_IndexStat-id INT64

Represents the index number. The _IndexStat table is identified by the index number. The _IndexStat-id field of the first row of the _IndexStat table is equal to or greater than the value specified by the -baseindex startup parameter.
_IndexStat-Read INT64 Number of times read access has occurred to the index
_IndexStat-OsRead INT64 Number of index reads from disk since the database was started.
_IndexStat-PartitionId INTEGER Partition Id of the index
_IndexStat-Split INT64 Number of split operations that have occurred to the index