From Slow Queries to Sub-Second Insights: Auditzy’s ClickHouse Migration Journey

At Auditzy, we recently migrated our real user monitoring analytics engine from PostgreSQL to ClickHouse to keep up with growing data and performance demands.

In this talk, I’ll share what pushed us to explore ClickHouse, how we approached the migration, and the impact it had on our ability to process and analyze over 200M monthly page views across 15B data points. I’ll also walk through some of the architectural decisions and lessons we learned that could help other teams scale real-time analytics.