the same query in the worker node is 100x fater than in coordinator node
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
I have setup citus(v12.1.15) cluster using postgreSQL16.4 with one coordinator and tow worker in 3 physical machine,with node run in docker. coordinator has 27TB size,worker1 has 22TB,worker2 has 6TB,while excute spatial query,in any of the worker node will get result in 400ms and 185 rows ,but excute in the coordinator node will cost 40s.
I have using bellow code to explain costs.
```
set citus.explain_all_tasks = 1;
explain (analyze,verbose,buffers,summary,settings,costs,timing,wal)
select * from "table_name" where st_intersects(geom,st_makeenvlope(x,x,x,x,4326))
```
on coordinator the explain result like those:
all task planing and execution time in 0.x ms, but all task will took 40s
Contributor guide
Assessment
This issue has not been assessed yet.