Do you need managed ClickHouse?

What each ClickStack route still leaves with the team, and how Axiom treats unplanned questions, history, metrics, and investigation load.

Axiom · · 9 min read

ClickHouse is a high-performance analytical database. ClickStack is ClickHouse's product for observing software systems through their logs, traces, and metrics. The phrase "managed ClickHouse" often collapses those into one purchase.

The useful comparison begins with the commitment each platform asks the customer to make. ClickHouse rewards a team for shaping physical design and available compute around the questions it expects to ask. Axiom begins from a different premise: machine data becomes most valuable when it can answer a question that was not predictable when the data arrived.

Know what is being considered

Three ClickStack routes, and what stays with the team

ClickHouse can mean the database, a custom machine-data product built on it, or ClickStack. This article concentrates on the three flavours of ClickStack most likely to sit next to Axiom.

Running ClickStack OSS keeps availability, upgrades, security, storage, backups, scaling, collection, ingestion topology, schemas, tuning, workload isolation, and the finished operating experience in house.

Managed ClickStack is the generally available ClickStack application on ClickHouse Cloud. ClickHouse operates the database infrastructure, application, replication, upgrades, and standard backups. The collector, ingestion design, and direct control over schemas, tuning, workload isolation, and compute sizing stay with the team. Those controls are part of the product's appeal for large, cost-conscious deployments.

ClickStack Cloud is a private-preview service with managed ingestion, durable buffering, serverless query serving, and the ClickStack application. Automatic physical tuning remains in development, dedicated agent query compute is planned, and pricing has not been finalized. The fair comparison is what each platform can demonstrate today.

If the prospect means a custom platform on ClickHouse OSS or ClickHouse Cloud, the open question is who will build the schemas, collection path, product interface, alerts, access controls, and operating practice.

Prepared paths and unplanned questions

ClickHouse makes prepared paths extraordinarily efficient. Rows follow a table's "ordering key," and a sparse primary index lets aligned queries skip large regions of data. "Projections" preserve alternative representations. "Materialized views" move repeated computation to ingest or merge time. Together, these mechanisms make a known workload exceptionally fast.

The choice of fast paths carries an expectation about future use. Data ordered around time and service can serve a familiar service investigation brilliantly. A question organized around customer, deployment, or a newly important attribute inherits less of that prepared physical advantage.

"ClickHouse is faster" is a fair claim and an incomplete test. Run the prepared dashboards and give them full credit. Then have the team choose a field and an older time range that neither side prepared, and measure the answer plus every platform change required to produce it. The second question is the revealing one. It gives the prepared paths full credit and shows what happens when production creates a question nobody prepared for.

This difference becomes tangible after ingestion. Let someone change the field, the time range, and the number of people or agents investigating. Axiom is built so those changes create a new investigation without first creating a physical-design or capacity exercise.

When ClickHouse is the right call

ClickHouse can be the better decision when the buyer needs to self-host, wants broad SQL analytics, has ClickHouse expertise it intends to use, or sees direct control of the database as a strategic capability.

Stable dashboards and settled access paths are the predictability ClickHouse converts into excellent performance and economics. In-house expertise counts when a team wants to keep using it. Some teams want logging infrastructure to become an internal capability rather than a purchase, which is a strategic choice more than a technical one.

Open source, self-managed, and Cloud routes also give customers access to the database and its physical controls. Axiom does not offer the same self-hosting or general database contract today. A broad SQL engine lets teams join observability data with product, security, and business data. If those capabilities define the decision, ClickHouse may fit better.

What Axiom absorbs

Axiom keeps the physical performance system behind the product. Machine data contains two related shapes. An event is a timestamped record a team may need to retrieve and inspect in full. A metric is a sequence of numeric samples for an exact set of labels.

EventDB makes incoming events queryable while it assembles immutable blocks. For settled data, it chooses a compact columnar representation. Those blocks live on object storage and remain in the ordinary query path. Changing the field, widening the time range, or adding investigators does not require choosing an ordering key, projection, replica layout, or query-service size for each new investigation.

Long retention has limited value when older evidence requires restoration or a separate archive workflow. Settled blocks remain in the same query path as recent live state, so an investigation can extend into an older release without rehydrating the data.

Events and metrics are different machinery

ClickStack supports logs, traces, and metrics through ClickHouse and is investing rapidly in metrics, including a TimeSeries engine and PromQL. Axiom already separates event retrieval from time-series computation inside one product. EventDB preserves the full timestamped record. MetricsDB is organized around exact series, cardinality, and time-window operations.

The buyer does not have to operate two databases or commercial models. Metric costs follow bytes rather than an active-series meter.

Investigation load and query capacity

Dashboards are relatively predictable. Incidents and agents are not. Several people can fan out across hypotheses while an agent issues successive exploratory queries over logs, traces, and metrics.

In Managed ClickStack, the customer can isolate these workloads through separate services, choose capacity bounds, and allow eligible compute to idle. That control can be economically useful. In Axiom, query placement, concurrency, and worker capacity belong to the managed platform. The team experiences additional investigation rather than a new service-sizing decision. MCP gives agents a direct interface to the same retained evidence.

How the pricing comparison actually works

Managed ClickStack charges for ClickHouse Cloud compute, compressed storage, backups, and applicable transfer, rather than hosts, users, events, or active series. A well-designed and well-utilized deployment can be economical.

Axiom's usage-based pricing has to earn the difference through outcomes the customer values: questions that change after ingest, older evidence that remains active, bursty human and agent investigations, high-cardinality metrics, and less customer work managing the physical performance model. Price the workload the team runs, including older searches, burst concurrency, and the engineering work between a new question and its answer.

From an established ClickHouse estate

For a net-new decision, compare the intended primary systems directly. For an established ClickHouse estate, dual-shipping one bounded workload can create a safe displacement proof without turning the evaluation into an estate-wide migration.

The aim is to identify which operating contract will produce the better customer outcome. ClickHouse turns expected access patterns into exceptional speed. Axiom is built so a change of field, time range, or investigator count starts a new investigation rather than a physical-design exercise.

A practical validation runs the prepared dashboards on both, then lets the customer's engineers choose a field and question that neither team prepared, and extend it into an older time range. Include a high-cardinality metric if metrics are in scope. Compare answer quality, elapsed time, platform changes, specialist involvement, and the complete measured cost.

FAQs

Related Reading

See the managed version on your own workload

If the decision is which operating contract the team wants to carry, a walkthrough on data you already have will show the unplanned-question path more clearly than another comparison page. Bring a live source and a field nobody designed a primary key for, and see Axiom on your data.