# ClickHouse/ClickBench

> A benchmark for analytical (OLAP) databases based on a real anonymized dataset of ~100M web-analytics records and 43 SQL queries. It lets you run and compare DBMS on clickstream, logs, and dashboard workloads.

- Magnitude: 1.8 out of 10 — Quiet
- Stars: 1,141 total · +2 stars measured 2026-10-23, 11:50–13:26 UTC, ≈ 3 by evening
- Star trust: star growth looks organic
- Category: Data & analytics · Language: Shell · Created: 2022-07-11 · Last push: 2026-10-23
- GitHub: https://github.com/ClickHouse/ClickBench · Homepage: https://benchmark.clickhouse.com/ · Page: https://gitnova.dev/en/r/ClickHouse/ClickBench

## Useful for

- Compare different SQL DBMS on the same real dataset
- Reproduce someone else's benchmark result on your own hardware in ~20 minutes
- Test storage throughput and query speed for a new OLAP engine

## Why it’s here

- Star-counter measurements on 2026-10-23 (UTC), 11:50–13:26: 1139 → 1141 stars (+2). This is the change over that interval.
- Estimated end-of-day forecast: about +3 stars, using observed gains and the previous day.
- Hacker News: “Remove pgrust: the entry is cheating” — 80 points, 5 h ago.

## Star trust

Star growth looks organic.

Star-trust labels are heuristics based on the repository’s behavior, not a check of every stargazer.

## Numbers

- Forks: 329
- Issues and pull requests: 2,757
- Watchers: 24
- Average over the last week: 1 per day
- Usual pace: 1 per day
- Stars in the last hour (measured): 1

## Stars per day, last 30 days (oldest → newest, today is partial)

2026-09-24 … 2026-10-23: 0, 1, 1, 0, 3, 1, 3, 0, 4, 1, 2, 1, 0, 0, 0, 2, 1, 0, 1, 0, 1, 0, 2, 1, 1, 2, 2, 1, 0, 2

## Hacker News

- Remove pgrust: the entry is cheating — 80 points, 36 comments: https://news.ycombinator.com/item?id=50205816

## Spotted in now

- Spotted on Hacker News

## Similar by description

1. **ClickHouse/ClickHouse** — 2.7 · Steady · Data & analytics · C++ · +16 stars measured 2026-10-23, 00:39–13:21 UTC, ≈ 28 by evening
   ClickHouse is an open-source column-oriented DBMS for OLAP analytics that generates analytical reports over large data volumes in real time. It installs with a single curl command on Linux, macOS and FreeBSD.
   Full card: https://gitnova.dev/en/r/ClickHouse/ClickHouse.md
2. **duckdb/duckdb** — 4.0 · Steady · Data & analytics · C++ · +25 stars measured 2026-10-23, 00:37–13:17 UTC, ≈ 47 by evening
   DuckDB is an in-process analytical SQL database management system. It is designed for fast, reliable, portable data processing without a separate server.
   Full card: https://gitnova.dev/en/r/duckdb/duckdb.md

---

Magnitude (0–10) measures how fast and how unusually interest in a repository is growing right now. It is not a quality score.
Days are UTC. “So far today” is a fact; “expected by the end of the day” is a forecast.
Summaries and use cases are written by an LLM (DeepSeek V4.1 Flash) from the README and may be inaccurate: verify specific claims (benchmarks, speed, hardware) in the repository itself.
Data as of 2026-10-23 13:33 UTC, updated every 30 minutes.