A column-oriented database that crunches huge amounts of data in milliseconds. For dashboards, events and reports.
- Type
- Analytical database
- Storage
- Column-oriented
- Role
- Analytics & logs
What is ClickHouse?
ClickHouse is an open-source analytical database. Instead of storing data per row, ClickHouse stores it per column, heavily compressed. That makes counts, groupings and aggregations over billions of rows extremely fast. It is made for analysis, not for updating individual records day to day.
Why ClickHouse?
Lightning-fast analytics
Aggregations over billions of rows in a fraction of a second.
Strong compression
Column storage compresses data heavily, which keeps storage and costs down.
Real-time insight
New events show up in your dashboards within seconds.
What we use it for
- AReal-time dashboards and reports
- BEvent and product analytics
- CLog and monitoring data
- DAnalytics on IoT and sensor data
When do you choose ClickHouse?
Choose ClickHouse when reports get slow or you want to analyse millions of events a day. Your transactional data stays in PostgreSQL; ClickHouse does the number crunching.
ClickHouse or PostgreSQL?
PostgreSQL is made for transactions: orders, customers, invoices. ClickHouse is made for analysis: counting and grouping across huge amounts of data. We use them side by side, each for what it does best.