SQL Language Guide : B. System Catalogs : X100 Query Profiling System Catalogs : iivwprof_io Catalog
 
Share this page                  
iivwprof_io Catalog
The iivwprof_io table contains the following columns. Each entry contains I/O statistics for one PAX group read by a scan operator executed by queries in the current session.
Column Name
Type
Description
query_id
bigint
Unique identifier of a query within a session, ascending
op_id
integer
Identifier of a relational operator within a query tree, pre-order, starting with 0
table
varchar(32)
Scanned table name
columns
varchar(64)
Scanned column name
async_fetch
bigint
Number asynchronous block requests generated by the scan
async_miss
bigint
Number of asynchronous requests for blocks not found in the cache
sync_fetch
bigint
Number of synchronous block requests generated by the scan
sync_miss
bigint
Number of synchronous requests for blocks not found in the cache