Content Deep Dive

Why Front migrated from Elasticsearch to ClickHouse for “pixel-perfect” analytics at scale

Blog post from ClickHouse

Post Details
Company
Date Published
Author
-
Word Count
1,512
Company Posts That Month
28
Language
English
Hacker News Points
-
Post removed?
No
Summary

Front migrated its customer-facing analytics from Elasticsearch to ClickHouse Cloud on AWS to manage 25 TB of data across 200 Elasticsearch nodes and reduce the engineering effort required to create metrics. The customer service platform processes tens of millions of messages daily for more than 9,000 companies, and its analytics must remain accurate even when conversations are later edited, deleted, or merged. Front moved gradually, running both systems in parallel and comparing results, then built a framework that defines each of roughly 70 metrics once and generates queries for different visualizations. ClickHouse’s SQL support and composable query design made metric development more accessible across the company, while a VersionedCollapsingMergeTree engine helps reconcile changes to underlying data. In a test involving a large customer’s tag report, a 30-second query expanded from 11 days of data in Elasticsearch to about a month and a half in ClickHouse, using roughly half as many machines of comparable performance. A metric that could take a senior engineer several weeks to build now takes a junior engineer about three days, and cloud-region transfers that previously took days can be completed in minutes. Front plans to use the platform for additional reporting capabilities, including backlog metrics and potential AI-assisted metric creation.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Developer Experience 1 231 155 47 -52%
Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.