Redrock Postgres Documentation
Home Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

IPC - ExecuteGather

Short Description

Waiting for activity from a child process while executing a Gather plan node.

Additional Information

Gather waits are seen in parallel query plans where the leader is merging data from background worker processes. The planner will use at most the max_parallel_workers_per_gather for the query and the total number of workers available on the system is controlled by max_worker_processes and max_parallel_workers

How to reduce this wait

Check that the total parallelism use in all queries does not saturate the CPUs available.

Check that the I/O load caused by the parallel queries can be sustained by the system.