ClickHouse Freemium

Columnar database that answers billion-row analytics queries in under a second.

ClickHouse is an open-source column-oriented database built for real-time analytics: hundreds of millions of rows, aggregated in milliseconds, on commodity hardware. Self-hosting costs nothing; ClickHouse Cloud bills roughly $0.10-0.20 per compute hour plus storage.

What is ClickHouse?

It started inside Yandex in 2016 to power Metrica web analytics, then went open source. The core idea is old and effective: store data by column, compress each column with a codec tuned to its type, and only read the columns a query touches.

On simple filters it scans over 100 million rows per second per core. The public NYC taxi benchmark — 100+ million rows — is reproducible on a laptop, which is unusual for database marketing claims.

Product Features

  • Columnar storage with codec-aware compression, often 10x smaller than a row-store equivalent.
  • Vectorized execution that uses every available core by default.
  • Materialized views that pre-aggregate on insert so dashboards read rollups, not raw events.
  • SQL dialect with window functions, arrays, JSON functions, roughly 700 functions total.
  • ReplicatedMergeTree for sharding and replication across nodes.
  • Ingest paths for Kafka, S3, MySQL and Postgres; query object storage in place.

Product Highlights

The project is unusually honest about what it can’t do, which saves a lot of wasted evaluations. Appends are cheap, mutations are expensive, and large-to-large joins are the known weak spot.

  • Open source includes replication and sharding under an Apache 2.0 license.
  • Cloud has a serverless tier that scales to zero when idle.
  • Grafana, Metabase, Superset and Looker connectors already exist.
  • Best-in-class for logs, events and telemetry.

Use Cases

  1. Product analytics over hundreds of millions of session events.
  2. Observability backends ingesting logs and traces from thousands of services.
  3. Ad-tech reporting where thousands of advertisers need sub-second dashboards.
  4. IoT telemetry at tens of thousands of writes per second.
  5. Analytics feeds that AI agents query directly through an API.

When should you not use ClickHouse?

Transactional workloads, row-level updates and many-to-many joins across big tables belong in Postgres or a general warehouse. ClickHouse is append-heavy and read-optimized; fighting that wastes weeks. Operations is the other trap — running a replicated cluster takes real SRE time, so most teams should pay for Cloud.

How much does ClickHouse cost?

The open-source version is free forever, including cluster features. ClickHouse Cloud charges by compute hour (about $0.10-0.20/hr depending on tier) plus compressed storage, and offers a trial credit. For high-volume append data the bill usually comes in below a general warehouse at similar query volume.

Quick Summary

  • ClickHouse is a columnar OLAP database for real-time analytics.
  • Self-hosting is free and includes replication.
  • ClickHouse Cloud runs about $0.10-0.20 per compute hour.
  • Best for event, log and telemetry data at hundreds of millions of rows.
  • Poor fit for transactional updates and large joins.