Blazing fast
Processes analytical queries faster than traditional row and column oriented systems.
Linearly scalable
Scales efficiently with hardware resources horizontally and vertically to petabyte scale.
Highly reliable
Supports asyncronous replication and can be deployed across multiple datacenters.
Flexible architecture
Supports shared-nothing clusters as well as separation of storage and compute.
Feature-rich
The most complete analytical database with support for joins, federated queries, and more.
Easy to use
Simplifies writing queries with a user-friendly SQL dialect, optimized for common analytical use cases.
Hardware efficient
ClickHouse processes analytical queries 100-1000x faster than traditional row-oriented systems with the same available I/O throughput and CPU capacity. Columnar storage format allows fitting more hot data in RAM, which leads to shorter response times.
Vectorization
Maximizes CPU efficiency
Vectorized query execution leverages SIMD processor instructions and runtime code generation. Processing data in columns increases CPU cache line hit rate.
Locality
Optimizes disk access
ClickHouse minimizes the number of seeks for range queries to increase efficiency of using disk drives and maintain locality of reference for continually stored data.
Throughput
Minimizes data transfers
ClickHouse enables companies to manage their data and create reports without using specialized networks that are aimed at high-performance computing.
From your laptop to petabyte scale
ClickHouse scales well both vertically and horizontally. It is easily adaptable to perform on your laptop, small virtual machine, a single server, or a cluster with hundreds or thousands of nodes.
There are many ClickHouse clusters consisting of multiple hundreds of nodes, while the largest known ClickHouse cluster is well over a thousand nodes. There are installations of ClickHouse with more multiple trillion rows or hundreds of terabytes of data per single node.
ClickHouse at scale
ClickHouse is used in a variety of industries for a broad set of use cases on top of both customer-facing and internally-facing workloads.
Web and app analytics
E-commerce and finance
Time series
Advertising networks and RTB
Information security
Business intelligence
Telecommunications
Monitoring and telemetry
Online games
Internet of Things (IoT)
Observability
User behavior analytics
Start using ClickHouse in minutes
Install ClickHouse for MacOS, Linux, and FreeBSD.
$ curl https://clickhouse.com/ | sh
Or install for Windows, Docker or see other install options.
Watch this getting started video to learn more about ClickHouse.
Products
Resources
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.