PGXC_WLM_OPERATOR_INFO
PGXC_WLM_OPERATOR_INFO displays the operator information of completed jobs executed on CNs. The data in this view is obtained from GS_WLM_OPERATOR_INFO.
Only the system administrator or the gs_role_read_all_stats role can access this view.
The PGXC_WLM_OPERATOR_INFO view can be queried only in the postgres database. If the view is queried in other databases, an error is reported.
GS_WLM_OPERATOR_INFO lists the columns in the PGXC_WLM_OPERATOR_INFO view.
|
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.
