18. Monitoring : View Query Profile Information : System Catalogs for Vector Query Profiling Views
 
Share this page                  
System Catalogs for Vector Query Profiling Views
The views that provide profiling information on Vector 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.