smplmark

ClickBench — analytical databases

Analytical-database runtimes for 43 SQL queries over a ~100M-row web-analytics dataset.

The latest published result per system and machine from ClickBench (github.com/ClickHouse/ClickBench), a benchmark of analytical databases over 43 fixed queries on a ~100M-row web-analytics dataset. Load time and data size are as recorded in the source's result files; the cold and hot totals are sums, computed here, of the source's 43 per-query timings (cold = each query's first run, hot = the best of its second and third). Lower is faster. The source's own headline 'relative' score is not reproduced.

Metrics

  • hot_total_s
  • cold_total_s
  • load_time_s
  • data_size_bytes
  • concurrent_qps

Targets (300)

  • Arc (c6a.2xlarge)
  • Arc (c6a.4xlarge)
  • Arc (c6a.metal)
  • Arc (c7a.metal-48xl)
  • Arc (c8g.4xlarge)
  • Arc (c8g.metal-48xl)
  • Bigquery (serverless)
  • ByConity (c6a.4xlarge)
  • CedarDB (c6a.4xlarge)
  • CedarDB (c6a.metal)
  • CedarDB (c7a.metal-48xl)
  • CedarDB (c8g.metal-48xl)
  • CedarDB (Parquet) (c6a.4xlarge)
  • CedarDB (Parquet) (c6a.metal)
  • CedarDB (Parquet) (c7a.metal-48xl)
  • CedarDB (Parquet) (c8g.4xlarge)
  • CedarDB (Parquet) (c8g.metal-48xl)
  • chDB (c6a.4xlarge)
  • chDB (c6a.metal)
  • chDB (c7a.metal-48xl)
  • chDB (c8g.4xlarge)
  • chDB (c8g.metal-48xl)
  • chDB (Parquet, partitioned) (c6a.4xlarge)
  • chDB (Parquet, partitioned) (c6a.metal)
  • chDB (Parquet, partitioned) (c7a.metal-48xl)
  • chDB (Parquet, partitioned) (c8g.4xlarge)
  • chDB (Parquet, partitioned) (c8g.metal-48xl)
  • CHYT (40GiB)
  • CHYT (48GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 120GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 120GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 236GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 236GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 32GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 32GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 356GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 356GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 64GiB)
  • ClickHouse ☁️ (aws) (ClickHouse ☁️: 64GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 120GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 120GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 236GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 236GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 32GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 32GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 356GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 356GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 64GiB)
  • ClickHouse ☁️ (azure) (ClickHouse ☁️: 64GiB)
  • ClickHouse (c6a.4xlarge)

…and 250 more.

Published by ClickBench.