Was this helpful?
iiwlm_log Table
Each row in the iiwlm_log table corresponds to a session’s query.
Column Name
Type
Length
Nulls
Description
sid
char
16
no
Session ID
client_host
char
64
no
Client host
“user”
char
32
no
User name
“group”
char
32
no
Group name
role
char
32
no
Role name
queue
char
32
no
Queue containing the current query
query
char
32000
no
Current query
est_tuples
float
8
no
Estimated number of tuples of current query
act_tuples
integer
8
no
Actual number of tuples returned by current query
queue_max_est_tuples
float
8
no
Highest estimated total tuples for the queue
queue_cur_tuples
float
8
no
Estimated total tuples for all queries running in the queue
est_cpu
float
4
no
Estimated CPU usage of current query
est_dio
float
4
no
Highest estimated disk I/O of all queries run in the queue
active_queries
integer
4
no
Current active queries of the current queue
max_active_queries
integer
4
no
Maximum active queries ever running in the current queue
flags
integer
4
no
Field reserved for future use.
queue_max_est_cpu
float
4
no
Highest total estimated CPU for the queue
queue_max_est_dio
float
4
no
Highest total estimated disk
I/O for the queue
queue_cur_est_cpu
float
4
no
Current total estimated CPU for all queries running in the queue
queue_cur_est_dio
float
4
no
Current total estimated disk I/O for all queries running in the queue
queue_ratio
integer
4
no
Queue ratio number for the current queue
queue_cur_ratio
float
4
no
Current queue ratio value for the current queue (if exceeded ratio limit)
start_time
timestamp(6) wtz
 
no
Execution start time of current query
end_time
timestamp(6) wtz
 
no
Execution end time of current query
session_start_time
timestamp(6) wtz
 
no
Session start /connection time
wait_time
timestamp(6) wtz
 
yes
Time spent in queue’s wait list for query
run_time
interval dtos(0)
 
no
Time spent executing query
queue_time
interval dtos(0)
 
yes
Total time spent in queue (wait_time + run_time)
wait_num
integer
4
yes
Wait number of the query when it entered the wait list
queue_pri
char
1
no
Queue priority of the current queue
user_pri
char
1
no
Wait list priority for the current queue for the session
data
char
3
no
Reserved for future use
 
Last modified date: 08/29/2024