ClickHouse performance audit
A fixed-price, fixed-scope audit of your production ClickHouse deployment — for teams whose analytics have outgrown the schema they started with.
Last updated:A ClickHouse performance audit is a fixed-scope assessment of a production ClickHouse deployment: schema and table-engine choices, ordering and partitioning keys, materialised views, merge health, query patterns, and cluster topology. Revenant Systems delivers a severity-ranked findings report with a prioritised remediation roadmap — at a fixed price agreed up front.
Who is a ClickHouse audit for?
A ClickHouse performance audit fits teams running ClickHouse in production — analytics platforms, event pipelines, observability stacks — without a ClickHouse specialist on staff. The usual symptoms: dashboards slowing as data grows, merge and parts pressure, storage growing faster than expected, or high-cardinality queries that flatten the cluster.
- Production ClickHouse, self-hosted or ClickHouse Cloud
- Analytics, telemetry, and event workloads
- Growing data, no dedicated specialist
What does the audit assess?
The audit examines the decisions that govern ClickHouse performance: schema and table-engine choices, ORDER BY and partitioning keys, materialised views and projections, compression codecs, merge and parts health, the query patterns behind the heaviest load, and replication and cluster topology — with headline cost observations for storage and compute.
In prior roles the founder ran ClickHouse through hundreds of billions of high-cardinality rows — schema design, merges, and query patterns at a scale most estates never reach.
- Schema and table-engine choices
- ORDER BY and partitioning keys
- Materialised views and projections
- Compression codecs
- Merge and parts health
- Query patterns and load
- Replication and cluster topology
- Storage and compute cost observations
What you receive
- A written findings report — severity-ranked, each finding with estimated impact and a concrete recommendation
- A prioritised remediation roadmap — quick wins vs structural work
- A findings walkthrough call
- A “further investigation recommended” section for anything material outside the fixed scope
How the engagement runs
- Typical turnaround: two weeks from start to report
- Fixed scope and fixed price, agreed before work starts
What we need from you
- Read-only access to system tables — schema, parts, merges, query log — or exports
- Cluster topology and instance details
- A short walkthrough with whoever owns the deployment
Access and client data are handled under our information security statement.
Frequently asked questions
Is this really a fixed price?
It is. The scope and the price are agreed before the audit begins, and neither moves — however large the tables turn out to be.
What if you find problems beyond the audit's scope?
They are noted in the report under further investigation, with enough context to judge their weight, and can be scoped separately if you want them tackled.
Can you implement the recommendations too?
Yes — fixed-price implementation of selected findings is available as follow-on work. The audit stands alone either way: the report and roadmap are written for your own team to act on.
Each package is an audit or assessment offered on its own — the process behind it is covered in how we work.