# ClickHouse/ClickBench

ClickBench: a Benchmark For Analytical Databases

Repository: https://github.com/ClickHouse/ClickBench
Canonical: https://ross.abutalabs.com/products/clickbench
Homepage: https://benchmark.clickhouse.com/
Language: Shell
License: NOASSERTION
License Family: other
Topics: analytics, benchmark, big-data, databases, olap, sql, aws, bigquery, chdb, clickhouse, datafusion, datalake, duckdb, iceberg, lakehouse, parquet, rust, snowflake, doris
Last push: 2026-09-02T16:25:16+00:00

## Health v2 (maintenance only)
Score: 77/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 100, release rhythm 35, longevity 100
- inputs: {"age_days": 1514, "days_push": 0, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1095, forks 312 (observed 2026-09-03T02:15:05.313282+00:00)

## What it is
ClickBench is an open-source benchmark for analytical (OLAP) databases, built on a real anonymized web analytics traffic dataset with 43 realistic SQL queries. It provides reproducible scripts to install, load, and test a wide range of DBMSs, with published results on benchmark.clickhouse.com.

## Use cases
- compare analytical database performance
- benchmark OLAP DBMS like ClickHouse, DuckDB, and BigQuery
- evaluate columnar database query speed and compression
- reproduce database benchmark results on cloud VMs
- test how a database handles clickstream and log analytics workloads
- measure load time, storage size, and query latency across systems

## When to avoid
- your workload is OLTP or transactional rather than analytical
- you need benchmarks covering joins-heavy or write-heavy workloads outside ClickBench's scope
- you require a fully vendor-neutral benchmark without single-workload bias

## Facets
- artifact type: dataset
- maturity: active
- function: benchmarking, database, analytics
- domain: databases, big-data, analytics, performance
- platform: cloud
- tags: olap, sql, clickhouse, duckdb, parquet, database-benchmark, web-analytics, reproducible-benchmarks, linux, docker

## Member repositories
- ClickHouse/ClickBench (main) score 77

## Provenance
- Observed fields: from GitHub, fetched 2026-09-03T02:15:05.313282+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:49:05.279581+00:00, confidence not recorded.
  - readme: https://github.com/ClickHouse/ClickBench (fetched 2026-09-03T02:15:05.313282+00:00, sha b5f1525dbb0c)
  - homepage: https://benchmark.clickhouse.com/ (fetched 2026-08-29T12:51:01.019496+00:00, sha 16e95a5db51b)
- Data as of 2026-08-30T08:39:29.467469+00:00.