OptiHouse
// free tool

ClickHouse Cost Calculator

Estimate how much money you can reclaim from your ClickHouse bill. Most clusters carry 18–38% reclaimable spend — across expensive queries, cold storage and background merges. Drag the slider and pick your workload profile.

~/clickhouse-cost-calculator
$15,000 /mo
$1k$100k+
Workload profile
Typically reclaimable
$2,700$5,700 /mo
$32,400$68,400 per year
Where it comes from
Cost driverReclaimable /mo
Expensive queries (compute)$1,080$2,280
Cold / unused storage$945$1,995
Parts & merges$270$570
Over-provisioned infra$405$855

Estimate based on a typical 18–38% reclaimable range. Your real figure depends on your cluster — OptiHouse measures it on your own data, read-only.

How this estimate works

The calculator takes your monthly spend and applies the typical reclaimable range (18–38%) seen on real ClickHouse clusters, then splits it across four cost drivers based on your workload profile. Query-heavy clusters lose more on compute; storage-heavy clusters lose more on disk.

This is an estimate, not an audit. Your exact figure depends on your queries, schema and codecs. For the full breakdown of where the money goes, see the guide ClickHouse cost optimization.

Frequently asked

>

Where does the 18–38% come from?

It's the typical reclaimable range we see on real clusters: expensive queries (10–25%), cold and unused storage (10–20%), parts and merges (3–8%), and over-provisioned infrastructure (5–15%). Combined, reclaiming 18–38% without rewriting your application is realistic.

>

Does this work for ClickHouse Cloud and self-hosted?

Yes. The cost drivers are the same: compute burned on over-scanning and storage paying for cold data. On ClickHouse Cloud you pay for compute directly, so query fixes often have an even bigger impact.

>

How do I get my exact number?

Connect your cluster to OptiHouse read-only — it measures the real figure on your own data and returns a ranked list of fixes with the exact SQL. You can start with the free query optimizer, no signup.

Want the exact figure on your own data? Start a free 14-day trial — read-only connection, no code changes.