Was this helpful?
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
Last modified date: 11/09/2022