18. Monitoring : View Query Profile Information : iivwprof View
 
Share this page                  
iivwprof View
The iivwprof view contains the main information about the execution stages of recently executed queries. It contains the following attributes:
query_id
Internal query ID for a given query.
Note:  Multiple records from the same query presented in the iivwprof table will have the same query_id.
op_id
Operator ID within a given query. Operators are individual processing stages of a query.
name
The name of a given operator. The indentation in the name is used to present the parent/child relationship.
ticks
The time spent in a given operator, in CPU clocks. Can be used to identify the most time-consuming operators.
tuples
The number of tuples produced by a given operator. Can be used to detect "exploding" data plans, as in the case of an unintended Cartesian product.
himem
The peak memory usage of a given operator in bytes. Can be used to identify the most memory-consuming operators.
data_blocks
The number of data blocks a given operator consumed. Data blocks are discussed in [cbm] block_size parameter (see block_size) and I/O Settings (see I/O Settings).
Note:  This information is provided for MScan (table scanning) operators only, not for disk-spilling operators.
async_io
The number of blocks for which the asynchronous data loading was performed. For details, see Interpreting I/O Information in IIVWPROF View.
sync_io
The number of blocks for which the synchronous data loading was performed. For details, see Interpreting I/O Information in IIVWPROF View.