SQL Language Guide : B. System Catalogs : X100 Query Profiling System Catalogs : iivwprof_query Catalog
 
Share this page                  
iivwprof_query Catalog
The iivwprof_query table contains the following columns. Each entry represents one query executed in the current session.
Column Name
Type
Description
query_id
bigint
Unique identifier of a query within a session, ascending
start_time
timestamp(6) with local time zone
Time stamp of the start of VW query execution (millisecond precision)
execution_time
interval day to second(6)
Total real time taken by the VW server expressed as an interval (millisecond precision)
query_text
varchar(4000)
Text of the query as generated by the optimizer
mem
bigint
Memory (in bytes) allocated by the query at end of execution
mem_tot
bigint
Maximum amount of memory allocated by the query at any point of the execution
mem_vm
bigint
Virtual memory address space reserved by the query at end of execution
mem_tot_vm
bigint
Maximum amount of virtual memory address space reserved by the query at any point of execution