PGXC_WLM_OPERATOR_HISTORY
PGXC_WLM_OPERATOR_HISTORY displays operator information when a job is finished on all CNs. This view is used to query data from GaussDB(DWS), and the data in the database is cleared periodically every 3 minutes.
Only the system administrator or the preset role gs_role_read_all_stats can access this view. For details about columns in the view, see Table 1.
| Column | Type | Description |
|---|---|---|
| nodename | Text | Name of the CN where the statement is executed |
| queryid | Bigint | Internal query_id used for statement execution |
| pid | Bigint | Backend thread ID |
| 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. |
| query_dop | Integer | Degree of parallelism (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 among 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:
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
