Database Administrator Guide > Database Administrator Guide > A. System Catalogs > System Catalogs for X100 Query Profiling Views > iivwprof_query Catalog
Was this helpful?
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
Last modified date: 01/30/2023