GS_WLM_OPERATOR_INFO
GS_WLM_OPERATOR_INFO displays records about operators of completed jobs. The data is dumped from the kernel to the system catalog. This system catalog can be queried by users with the sysadmin permission only in Postgres.
Table 1 GS_WLM_OPERATOR_INFO columns
Name | Type | Description |
---|
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 the plan node ID |
start_time | timestamp with time zone | Time when the operator starts to process the first data record |
duration | bigint | Total execution time of the operator, in ms |
query_dop | integer | DOP of the operator |
estimated_rows | bigint | Number of rows estimated by the optimizer |
tuple_processed | bigint | Number of elements returned by the operator |
min_peak_memory | integer | Minimum peak memory used by the operator on database nodes (unit: MB) |
max_peak_memory | integer | Maximum peak memory used by the operator on database nodes (unit: MB) |
average_peak_memory | integer | Average peak memory used by the operator on database nodes (unit: MB) |
memory_skew_percent | integer | Memory usage skew of the operator among database nodes |
min_spill_size | integer | Minimum spilled data among database nodes when a spill occurs (unit: MB) (default value: 0) |
max_spill_size | integer | Maximum spilled data among database nodes when a spill occurs (unit: MB) (default value: 0) |
average_spill_size | integer | Average spilled data among database nodes when a spill occurs (unit: MB) (default value: 0) |
spill_skew_percent | integer | Database node spill skew when a spill occurs |
min_cpu_time | bigint | Minimum execution time of the operator on database nodes (unit: ms) |
max_cpu_time | bigint | Maximum execution time of the operator on database nodes (unit: ms) |
total_cpu_time | bigint | Total execution time of the operator on database nodes (unit: ms) |
cpu_skew_percent | integer | Execution time skew among database nodes |
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
|
openGauss 2024-09-07 01:01:32