# Behind the music: How Chartmetric is scaling music analytics with ClickHouse

DevFeed: [Behind the music: How Chartmetric is scaling music analytics with ClickHouse](<https://devfeed.tech/articles/behind-the-music-how-chartmetric-is-scaling-music-analytics-with-clickhouse-5025.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/chartmetric-scaling-music-analytics>)

Author: ClickHouse

Published: 2026-01-08T14:17:18Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [data](<https://devfeed.tech/topics/data.md>), [Time Series](<https://devfeed.tech/topics/time-series.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [Streaming](<https://devfeed.tech/topics/streaming.md>), [API](<https://devfeed.tech/topics/api.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [Web app](<https://devfeed.tech/topics/webapp.md>), [airflow](<https://devfeed.tech/topics/airflow.md>), [elasticsearch](<https://devfeed.tech/topics/elasticsearch.md>), [Web](<https://devfeed.tech/topics/web.md>)

Tags: [airflow](<https://devfeed.tech/tags/airflow.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [api](<https://devfeed.tech/tags/api.md>), [app](<https://devfeed.tech/tags/app.md>), [apple](<https://devfeed.tech/tags/apple.md>), [cache](<https://devfeed.tech/tags/cache.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data](<https://devfeed.tech/tags/data.md>), [elasticsearch](<https://devfeed.tech/tags/elasticsearch.md>), [music](<https://devfeed.tech/tags/music.md>), [scale](<https://devfeed.tech/tags/scale.md>), [search](<https://devfeed.tech/tags/search.md>), [series](<https://devfeed.tech/tags/series.md>), [speed](<https://devfeed.tech/tags/speed.md>), [streaming](<https://devfeed.tech/tags/streaming.md>), [time](<https://devfeed.tech/tags/time.md>), [time-series](<https://devfeed.tech/tags/time-series.md>), [web](<https://devfeed.tech/tags/web.md>)

## AI overview

Chartmetric uses ClickHouse Cloud to scale real-time music analytics across billions of rows from streaming services, social media, and music charts. The migration from Postgres and Snowflake improved query speed and reduced storage costs, while ClickHouse now supports LLM-facing queries and a playlist cache ingesting more than 15 million rows daily.

## Source excerpt

"ClickHouse works very well as part of our multi-system data stack. It's excellent for time-series data, and the VersionedCollapsingMergeTree engine was a game-changer for us, speeding up queries from 20 seconds in Snowflake to 1.5 seconds in ClickHouse."