citusdata / citusdata/citus

the same query in the worker node is 100x fater than in coordinator node

Open
#7,772 6 comments 0 reactions 0 assignees View on GitHub
performance Support
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.