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.