Aggregating one billion JSON documents

Same EC2 instance type: AWS m6i.8xlarge

ClickHouse

Cold
661 ms
Hot
578 ms

MongoDB

Cold
32m 26s
Hot
17m 16s

Query time · log scale