ExecuteGather
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.
Additional Links​
PostgreSQL documentation - How Parallel Query Works
PostgreSQL documentation - The Statistics Collector
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.