GS_WLM_OPERATOR_STATISTICS
GS_WLM_OPERATOR_STATISTICS displays the operators of the jobs that are being executed by the current user.
| Name | Type | Description |
|---|---|---|
| queryid | bigint | Internal query_id used for statement execution |
| pid | bigint | Thread ID of the backend |
| plan_node_id | integer | plan_node_id of the execution plan of a query |
| plan_node_name | text | Name of the operator corresponding to plan_node_id |
| start_time | timestamp with time zone | Time when an operator starts to process the first data record |
| duration | bigint | Total execution time of an operator. The unit is ms. |
| status | text | Execution status of the current operator. Its value can be finished or running. |
| query_dop | integer | DOP of the current operator |
| estimated_rows | bigint | Number of rows estimated by the optimizer |
| tuple_processed | bigint | Number of elements returned by the current operator |
| min_peak_memory | integer | Minimum peak memory used by the current operator on all DNs. The unit is MB. |
| max_peak_memory | integer | Maximum peak memory used by the current operator on all DNs. The unit is MB. |
| average_peak_memory | integer | Average peak memory used by the current operator on all DNs. The unit is MB. |
| memory_skew_percent | integer | Memory usage skew of the current operator among DNs |
| min_spill_size | integer | Minimum spilled data among all DNs when a spill occurs. The unit is MB. The default value is 0. |
| max_spill_size | integer | Maximum spilled data among all DNs when a spill occurs. The unit is MB. The default value is 0. |
| average_spill_size | integer | Average spilled data of all DNs when a spill occurs. The unit is MB. The default value is 0. |
| spill_skew_percent | integer | DN spill skew when a spill occurs |
| min_cpu_time | bigint | Minimum execution time of the operator on all DNs. The unit is ms. |
| max_cpu_time | bigint | Maximum execution time of the operator on all DNs. The unit is ms. |
| total_cpu_time | bigint | Total execution time of the operator on all DNs. The unit is ms. |
| cpu_skew_percent | integer | Skew of the execution time among DNs. |
| warning | text | Warning. The following warnings are displayed:
|
Last Article: GS_WLM_OPERATOR_HISTORY
Next Article: GS_WLM_SESSION_HISTORY
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.