SQL Language Guide > SQL Language Guide > B. System Catalogs > X100 Query Profiling System Catalogs
Was this helpful?
X100 Query Profiling System Catalogs
The predefined views (iivwquery, iivwprof, iivwprof_last) that provide profiling information on X100 queries are based on the following system catalogs:
iivwprof_query
iivwprof_op
iivwprof_io
iivwprof_stage
iivwprof_expr
iivwprof_parse_tree
Note:  System catalogs with the name iivwprof_*_global (for example iivwprof_query_global) contain information on all sessions (rather than just the current session). These tables have an additional attribute “session_id”, which is an 8-byte integer.
Last modified date: 11/09/2022