17.00 - Native Object Store Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K
Column Name Mode Description Data Type
NosPhysReadIOs count Number of physical read IOs issued against Native Object Store tables. FLOAT
NosPhysReadIOKB count Total KB physically read from Native Object Store tables. FLOAT
NosFiles count Number of Native Object Store files read in satisfying queries against Native Object Store tables. FLOAT
NosFilesSkipped count Number of Native Object Store files skipped due to errors. FLOAT
NosRecordsReturned count Number of records returned in satisfying queries against Native Object Store tables. FLOAT
NosRecordsReturnedKB count Total KB of records returned from Native Object Store files (after any decompression and character conversion performed). FLOAT
NosRecordsSkipped count Number of Native Object Store records skipped due to errors FLOAT
NosTotalIOWaitTime count Total time in seconds waiting for IOs when reading Native Object Store files. FLOAT
NosMaxIOWaitTime max Maximum single IO wait time in seconds when reading Native Object Store files. FLOAT
NosCPUTime count Total CPU time in seconds spend decompressing, translating, or otherwise processing Native Object Store data as part of reading it. FLOAT