System Catalogs for X100 Query Profiling Views
The predefined views (iivwquery, iivwprof, iivwprof_last) that provide profiling information on X100 queries are based on the following Ingres 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 (not only the current session). These tables have an additional attribute "session_id", which is an 8-byte integer.
Last modified date: 01/30/2023