Skip to content

sql: incomplete vectorized traces #59555

@glennfawcett

Description

@glennfawcett

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.

Screen Shot 2021-01-19 at 11 18 57 AM

[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.

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions