Was this helpful?
iivwprof_stage Catalog
The iivwprof_stage table contains the following columns. Each entry contains information about time spent by the queries in different parts of the query life cycle.
Column Name
Type
Description
query_id
bigint
Unique identifier of a query within a session, ascending
name
varchar(20)
Name of a stage. One of:
scanstate - query text tokenizer
parse - query text parser
rewrite - query execution tree rewriter
build - initializing execution operators
execute - actual query execution
profile - generating profile information
free - freeing the resources
total - total time of the above stages
substage
varchar(20)
Name of a substage for rewrite stage
ticks
bigint
Time spent in this stage in CPU clock cycles
Last modified date: 11/09/2022