SQL Language Guide > SQL Language Guide > B. System Catalogs > X100 Query Profiling System Catalogs > iivwprof_io Catalog
Was this helpful?
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
Last modified date: 06/28/2024