Table statistics (_TableStat)

The _TableStat VST displays statistics on the number of accesses to a specific range of tables.1

Field name Data type Description
_TableStat-Create INT64 Number of times create access has occurred to the table
_TableStat-Delete INT64 Number of times delete access has occurred to the table
_TableStat-Read INT64 Number of times read access has occurred to the table
_TableStat-id INT64 Represents the table number. The _TableStat table is identified by the table number. The _TableStat-id field of the first row of the _TableStat table is equal to or greater than the value specified by the -basetable startup parameter.
_TableStat-OSRead INT64 Number of table reads from disk since the database was started; only valid for tables in a Type II area
_TableStat-PartitionID INTEGER Partition Id of the table
_TableStat-Update INT64 Number of times update access has occurred to the table