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 |