-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: incomplete vectorized traces #59555
Copy link
Copy link
Closed
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
Description
Describe the problem
I ran across an interesting observation while trying to explain how queries are run in parallel within CRDB. I was using the internal KV workload and have a fair number of ranges distributed across three nodes:
root@:26257/kv> SELECT k2, count(*) FROM kv GROUP BY k2;
k2 | count
---------+----------
z | 4561620
needle | 8
I was expecting that the above query would run in parallel, but when looking at the Jaeger trace collected, it appears to not be serial.
[stmt-bundle-625911811735650305.zip](https://github.com/cockroachdb/cockroach/files/5889843/stmt-bundle-625911811735650305.zip) [stmt-bundle-628463749489590273.zip](https://github.com/cockroachdb/cockroach/files/5889847/stmt-bundle-628463749489590273.zip)At the advise of engineering, I ran this by disabling vectorization SET vectorize = off and it appeared to run as expected albeit longer.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.
