SQL Language Guide : B. System Catalogs : X100 Query Profiling System Catalogs : iivwprof_expr Catalog
 
Share this page                  
iivwprof_expr Catalog
The iivwprof_expr table contains the following columns. Each entry represents one vector function used during execution of a query.
Column Name
Type
Description
query_id
bigint
Unique identifier of a query within a session, ascending
op_id
bigint
Identifier of a relational operator within a query tree, pre-order, starting with 0
ticks
bigint
Total time spent (in CPU clock cycles) in this function
processed_cnt
bigint
Number of tuples processed
call_cnt
bigint
Number of vectors processed
function_name
varchar(60)
Function name
name
varchar(30)
Name of the expression executing the function
context
varchar(100)
Encoded names of functions in the expression tree and the operator executing this function