Database Administrator Guide > Database Administrator Guide > A. System Catalogs > System Catalogs for X100 Query Profiling Views > iivwprof_parse_tree Catalog
Was this helpful?
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
 
Last modified date: 01/30/2023