Case Study: Chartmetric scaled music analytics 10-15x faster on ClickHouse Cloud

Key results

The challenge

Chartmetric provides analytics on artists, tracks, and playlists across streaming platforms, with data volumes growing rapidly. Its Postgres and Snowflake stack carried high storage costs, and queries scanning historical data frequently timed out.

The solution

The team migrated time-series workloads from Postgres and Snowflake to ClickHouse Cloud, using projections and WHERE + IN filters to optimize query patterns.

The results, in context

Chartmetric reported that queries now run 10-15x faster at much lower cost, and that migrating eight time-series tables cut its AWS RDS footprint from 28 TB to 18 TB, a 36% saving. Figures are quoted from the published ClickHouse story and dated.

Products used