Home / ClickBench
ClickHouse/ClickBench
ClickBench: a Benchmark For Analytical Databases
ShellCategories: Developer tools
Our summary
ClickBench is a benchmark for analytical databases. It uses a single flat table of web analytics traffic data and a set of 43 queries covering full scans, filtered scans, index lookups and relational operations.
Who it is for: Developers and evaluators comparing analytical database systems
What the README claims
- The benchmark can be reproduced quickly, in as little as 20 minutes for some systems
in as little as 20 minutes (although some systems may take several hours)
Not checked - The dataset contains exactly 99,997,497 records
The table consists of exactly 99'997'497 records.
Not checked - The workload consists of 43 queries
The workload consists of 43 queries and test the efficiency of full scan and filtered scan
Not checked - The dataset is derived from production data and keeps realistic distributions
The dataset is derived from production data.
Too broad to verify - The test setup uses inexpensive cloud VMs
The test setup is documented and uses inexpensive cloud VMs.
Too broad to verify
Written by AI from the project's README on 2026-11-22. It does not affect the verdict.
Watching: no other rule matched yet.
7-day star gain 3, down from 6 the week before.
Gaining 3 stars this week. Last push today.
Verdict
SLEEPER scored 53m ago
- Hype
- 25
- Reality
- 97
- Hype Gap
- -72
- Momentum
- -
- Confidence
- 60%
- Maintained moves Reality +26 points.
- Responsive moves Reality +10 points.
Rule verdict-2.0, scoring score-2.0. How we score. Backtest.
Repository on GitHub Project homepage
Maintained by
Maintained by a team with no developer above half of all commits, 2 external contributors in the last 90 days.
- ClickHouse is a GitHub organization.
- Official organization: verified by GitHub.
- GitHub account created September 2019.
- Top contributors by commits: github-actions[bot] 42%, alexey-milovidov 24%, rschu1ze 5%.
Why now 0% of its stars arrived in the last 7 days. No Hacker News posts in the last 7 days.
- Stars StarsThe number of GitHub stars on the repository at our latest reading.
- 1,171
- Gain 7d Gain 7dStars gained since our latest reading from at least 7 days ago.
- +3
- Pace Velocity (Nx usual pace)This week's star gain divided by the project's usual weekly gain. The usual gain is the average weekly gain over the 4 weeks before (days 8 to 35 ago), counted as at least 10 stars. 2.0x means twice the usual pace. Without a reading from 35 days ago, the ranking assumes 2% of the stars the project had 7 days ago as its usual weekly gain. More on the methodology page
- 0.1x
- HN points HN pointsHacker News points added up across posts that mention the project, published in the last 7 days.
- 0 7 days
- Downloads DownloadsDownloads per day of the project's package, as the registry (npm or PyPI) reports them.
- n/a
- Contributors Contributors, all timePeople and anonymous contributors who have ever committed to the repository, as GitHub counts them. A small number is context, not a flaw: many solid projects are kept by one or two people.
- 174
- Last release Latest releaseDays since the latest GitHub release was published.
- n/a
Gain 24h Gain 24hStars gained since our latest reading from at least 24 hours ago. 0. Forks ForksThe number of GitHub forks of the repository at our latest reading. 340. Open issues Open issuesThe number of open issues on the repository at our latest reading, as GitHub counts them. 46. Days since push Days since pushDays since the last push to the repository. 0 days. Archived ArchivedWhether the owner has archived the repository on GitHub. An archived repository is read-only. no. Hacker News posts in 7 days Hacker News postsThe number of Hacker News posts that mention the project, published in the last 7 days.: 0. Watchers WatchersThe number of GitHub users watching the repository for notifications, at our latest reading. 24.
Facts
Nerd stuff
Docker
- Deployment
- Docker (detected)
The Receipts
| Source | Evidence | Date |
|---|---|---|
| Hacker News | Thread, 197 points, 166 comments | 23 Oct 2026 |
What changed recently
GitHub release dates we stored. We do not track license changes yet.
Cite this
ClickBench is a GitHub project at https://github.com/ClickHouse/ClickBench written mainly in Shell, described there as "ClickBench: a Benchmark For Analytical Databases".
Source: https://midorreal.com/project/clickhouse-clickbench, checked 22 November 2026. The same facts as JSON: /project/clickhouse-clickbench.json.
Rank history
Peak day: +4 stars on 6 Nov 2026, 16 days ago.
Stars
Events in this window
Dated items we stored, last 30 days. They sit near the chart, they do not explain it.
Packages
- We checked npm, PyPI, Docker Hub, crates.io and Homebrew and found no package that links to this repository.
Signals
| Source | What we measured | Checked |
|---|---|---|
| GitHub | 1,171 stars, 3 gained in 7 days | 22 Nov 2026 |
| Hacker News | 1 post stored, 0 points in the last 7 days | 30 Oct 2026 |
| Feed mentions | Not tracked yet | - |
| npm | No linked package found | - |
| PyPI | No linked package found | - |
| Docker Hub | No linked package found | - |
| crates.io | No linked package found | - |
| Homebrew | No linked package found | - |
| deps.dev | Not tracked yet | - |
| Hugging Face | Not tracked yet | - |
| Bluesky | Not tracked yet | - |
| Stack Exchange | Not tracked yet | - |
| YouTube | Not tracked yet | - |
Attention vs adoption
Attention: above 30% of tracked projects
Star velocity against all tracked projects
Adoption: not enough data to rank
Downloads, dependents and pulls
Not enough comparable data yet to set attention against adoption. This describes the numbers; it is not a verdict.
Compared with Developer tools
| Measure | This project | Category median |
|---|---|---|
| Star velocity | 0.1 | 0.5 |
| Days since release | no data | 9.2 |
| Contributors, all time | 174 | 3 |
| Median time to first reply on issues | no data | 12 hours |
| Commits in the last 30 days | 2,112 | 41.5 |
Star velocity: above 30% of Developer tools projects
Contributors, all time: above 88% of Developer tools projects
Commits in the last 30 days: above 96% of Developer tools projects
Compared with the project's first category only. A percentile line appears only where at least 30 projects in the category have the measure. This describes the numbers; it is not a verdict.
Compare with
Hacker News
| Post | Points PointsThe points the post has on Hacker News. | Comments CommentsThe number of comments on the post on Hacker News. | Date |
|---|---|---|---|
| Hacker News post | 197 | 166 | 23 Oct 2026 |
Caveats
Repo health
- Languages LanguagesShare of the repository's code by bytes, as GitHub's language detection reports it. The five biggest languages are named and the rest are grouped as Other.Shell 52%, Python 19%, HTML 17%, C++ 7%, Rust 3%, Other 2%
- License LicenseThe SPDX license id GitHub detects, and a class: Open source (OSI) if the license is on the Open Source Initiative approved list, Source-available if the code is readable but the license limits use, Unclear if GitHub cannot match a known license, No license detected if it finds none. A public repository without a license is not open source.Unclear
- Repository age Repository ageTime since the repository was created on GitHub. This is the repository, not necessarily the project, which may have existed elsewhere before.4 years, created 11 Jul 2022
Development
- Commits in the last 7 days Commits in the last 7 daysCommits to the repository in the last 7 days, as GitHub counts them.453
- Commits in the last 30 days Commits in the last 30 daysCommits to the repository in the last 30 days, as GitHub counts them.2,112
- Commits in the last 90 days Commits in the last 90 daysCommits to the repository in the last 90 days, as GitHub counts them.5,160
- Contributors, all time Contributors, all timePeople and anonymous contributors who have ever committed to the repository, as GitHub counts them. A small number is context, not a flaw: many solid projects are kept by one or two people.174
- Releases ReleasesThe number of GitHub releases, and how many days ago the latest one was published.0
- Issues in the last 30 days Issues in the last 30 daysIssues opened and issues closed in the last 30 days, as GitHub search counts them.5 opened, 3 closed
- Pull requests merged in the last 30 days Pull requests merged in the last 30 daysPull requests merged in the last 30 days, as GitHub search counts them.715
Maintenance
- Stale open issues Stale open issuesOpen issues with no update in the last 90 days, as GitHub search counts them.13
- Open pull requests Open pull requestsPull requests open now, as GitHub search counts them.26
Hygiene
- Automated tests or builds (CI) Automated tests or builds (CI)Whether the repository has at least one GitHub Actions workflow file in .github/workflows.Yes
- A tests folder A tests folderWhether the repository has a top-level folder named tests, test, __tests__ or spec.No
- A license A licenseWhether GitHub detects a license file in the repository.Yes
- Contributing guide Contributing guideWhether the repository has a contributing guide.No
- Code of conduct Code of conductWhether GitHub finds a code of conduct in the repository.No
- CODEOWNERS file CODEOWNERS fileWhether the repository has a CODEOWNERS file, which names who reviews changes to which files.No
- A Dockerfile A DockerfileWhether the repository has a Dockerfile at its top level.No
Security
- Security policy Security policyWhether the repository has a SECURITY.md or SECURITY.rst file.No
- Unpatched high or critical advisories Unpatched high or critical advisoriesPublished GitHub security advisories rated high or critical on this repository that list a vulnerable version with no patched version.0
Badge
For maintainers: one measured fact, no verdict.
Markdown
[](https://midorreal.com/project/clickhouse-clickbench)
HTML
<a href="https://midorreal.com/project/clickhouse-clickbench"><img src="https://midorreal.com/badge/clickhouse-clickbench.svg" alt="Mid or Real"></a>
Verdict badge: It shows the verdict as this page shows it today.
Markdown
[](https://midorreal.com/project/clickhouse-clickbench)
HTML
<a href="https://midorreal.com/project/clickhouse-clickbench"><img src="https://midorreal.com/badge/clickhouse-clickbench.svg?style=verdict" alt="Mid or Real: SLEEPER"></a>
Passport
Copy these facts into a post, a README or a page. Cite as "Source: Mid or Real". Full record: JSON.
First tracked 23 Oct 2026 at 1,139 stars.
- GitHub data 3 h old
- Hacker News data 23 d old
Is this your project? Claim it
Figures by method 1.0