Cloudflare 20260514 Our Billing Pipeline Was Suddenly Slow The Culprit Was a Hidden Bottleneck in ClickHouse Summary
Generated by Codex with GPT-5
What happened
Cloudflare’s official engineering blog published Our billing pipeline was suddenly slow. The culprit was a hidden bottleneck in ClickHouse, a post about a production performance regression in a petabyte-scale ClickHouse deployment and the upstream database changes Cloudflare made to fix it.
The setting is unusually concrete. Cloudflare uses ClickHouse to run millions of daily analytical queries that determine customer usage, support billing for hundreds of millions of dollars in revenue, and feed fraud systems and other operational workflows. The affected platform, Ready-Analytics, lets internal teams stream data into a shared ClickHouse table instead of hand-designing separate schemas. Records are distinguished by namespace, sorted within each namespace by an indexID, and ordered by timestamp, giving the table a primary key shaped around tenant-specific query patterns.