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
iivwprof_vwload_load_status Catalog
The iivwprof_vwload_load_status tree table contains the following columns. Each entry represents the statistics about the ongoing load per file in the current session.
Column Name
Type
Description
accepted_rows
bigint
Number of rows processed without errors
file_name
varchar(255)
Name of the file being loaded
rejected_rows
bigint
Number of rows processed with errors
processed_bytes
bigint
Bytes processed till now
session_id
bigint
Ingres Session ID
session_userid
varchar(32)
ID of the user running the query
table_name
varchar(256)
Name of the table where data is being uploaded
total_bytes
bigint
Total bytes in a file
iivwprof_vwload_result_status Catalog
The iivwprof_vwload_result_status tree table contains the following columns. Each entry represents the result statistics for the recently completed load per file in the current session.
Column Name
Type
Description
column_name
varchar(32)
Name of the column where error occured
file_name
varchar(255)
Name of the file being loaded
failed_row_num
bigint
Number of rows processed with errors
Error_msg
bigint
Bytes processed till now
loaded_rows
bigint
Number of records loaded
session_id
bigint
Ingres Session ID
session_userid
varchar(32)
ID of the user running the query
table_name
varchar(256)
Name of the table where data is being uploaded
total_rows
bigint
Number of records in the source files.
 
Last modified date: 12/19/2024