← Questions

Design a user activity query system

0
AirbnbSystem designLast asked Dec 2025

Design a system that stores user activity events at scale and lets services query a user's activity, for example everything a user did in a time range, filtered by type. Cover the write path, the storage layout and partitioning, indexes for the common queries, retention, and latency at high volume.

Your canvas
Draw your answer hereBoxes, arrows and notes, saved for you to come back to.Sign in to start drawing