SQL Language Guide : B. System Catalogs : X100 Query Profiling System Catalogs : iivwprof_parse_tree Catalog
 
Share this page                  
iivwprof_parse_tree Catalog
The iivwprof_parse_tree table contains the following columns. Each entry represents a node in the tree representation of the internally constructed query (query_text) of the current session queries.
Column Name
Type
Description
query_id
bigint
Unique identifier of a query within a session, ascending
is_operator
boolean
The node representing a relational operator
name
varchar(24)
Name of the node type
value
varchar(40)
Value stored in the node (depends on the type, for example function name or literal value)
est_card
bigint
For operator nodes - output number of tuples estimated by the optimizer
level
bigint
Level of the node in the tree
node_num
bigint
Node index in the pre-order sequence