Design a fast host listing metrics page

Q: Design a fast host listing metrics page

This is a System Design interview question from Airbnb for Software Engineer roles. View the full question and solution on PracHub.

Q: How do I approach System Design interview questions?

System Design questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master system design interviews.

Question

Design the backend for a host (landlord) listings page.

User flow:

Host opens a page showing many of their listings .
Host selects a date range .
For each listing shown, the UI displays aggregated metrics for that range, e.g.:
- Nights booked (how many nights are reserved within the range)
- Average price within the range

Assume you start with these tables:

Listings(listing_id, host_id, ... )
Reservations(reservation_id, listing_id, start_date, end_date, status, ... )
Pricing(listing_id, date, price, currency, ... )

Problem:

When a host has 100+ listings , the page becomes slow.

Task:

Propose an end-to-end design (APIs, data access patterns, storage/indexing, caching/precomputation) to make the page fast and scalable.
Specify how you would compute the metrics correctly (including edge cases like partial overlap, cancellations) and keep them up to date.
Include performance goals and how you would validate them.

Design a fast host listing metrics page

Solution

Comments (0)