PXDeq:ExecutionMsg,PXDeq:ExecuteReply等待事件
程序员文章站
2022-06-12 19:53:57
...
PX Deq: Execution Msg Occurs when a parallel slave is waiting to be told what to do. This is normally considered an idle event, but can cause excessive CPU in some cases. Solution Reduce the degree of parallelism in the query if excessive
PX Deq: Execution Msg
Occurs when a parallel slave is waiting to be told what to do. This is normally considered an idle event, but can cause excessive CPU in some cases.
Solution
Reduce the degree of parallelism in the query if excessive CPU usage is detected.
PX Deq: Execute Reply
Occurs when the query coordinator is waiting for a response from a parallel slave. This is normally considered an idle event, but can cause excessive CPU in some cases.
Solution
Reduce the degree of parallelism in the query if excessive CPU usage is detected.