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.

**Table 1** GS_WLM_OPERATOR_INFO columns
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: Sort/SetOp/HashAgg/HashJoin spill Spill file size large than 256MB Broadcast size large than 100MB Early spill Spill times is greater than 3 Spill on memory adaptive Hash table conflict

Parent Topic: System Views

Previous topic: PGXC_WLM_OPERATOR_HISTORY

Next topic: PGXC_WLM_OPERATOR_STATISTICS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot