PGXC_WLM_OPERATOR_STATISTICS
PGXC_WLM_OPERATOR_STATISTICS displays the operator information of jobs being executed on CNs.
Only the system administrator or the preset role gs_role_read_all_stats can access this view.
Name |
Type |
Description |
---|---|---|
queryid |
bigint |
Internal query_id used for statement execution. |
pid |
bigint |
ID of the backend thread. |
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 default value is 0. The unit is MB. |
max_spill_size |
integer |
Maximum spilled data among all DNs when a spill occurs. The default value is 0. The unit is MB. |
average_spill_size |
integer |
Average spilled data among all DNs when a spill occurs. The default value is 0. The unit is MB. |
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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot