Updated on 2023-10-31 GMT+08:00

GS_WLM_OPERATOR_INFO

GS_WLM_OPERATOR_INFO records operators of completed jobs. The data is dumped from the kernel to a system catalog. If the GUC parameter enable_resource_record is set to on, the system imports records in GS_WLM_OPERATOR_HISTORY to this system catalog every three minutes. You are not advised to enable this function because it occupies storage space and affects performance.

  • This system catalog's schema is dbms_om.
  • This system catalog has a distribution column, the gaussdb column, in PostgreSQL databases only, not other databases.
  • The pg_catalog has the GS_WLM_OPERATOR_INFO view.
Table 1 GS_WLM_OPERATOR_INFO columns

Name

Type

Description

nodename

text

Name of the CN where the statement is executed

queryid

bigint

Internal query_id used for statement execution

pid

bigint

Thread ID of the backend

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:

  1. Sort/SetOp/HashAgg/HashJoin spill
  2. Spill file size large than 256MB
  3. Broadcast size large than 100MB
  4. Early spill
  5. Spill times is greater than 3
  6. Spill on memory adaptive
  7. Hash table conflict