Optimize session detail APIs and overall loading experience

[detj]

Summary

This PR improves performance and loading experience of Session detail page, including much faster Session instance plot and faster and stable Session listing/filtering/pagination.

Tasks

• [x] Create a new sessions table for storing aggregated Session data and metrics
• [x] Create a new sessions_mv materialized view for populating sessions table via events master
• [x] Update Session detail's instance plot API to load faster in most cases
• [x] Update Session detail's sessions list API to load faster in most cases
• [x] Move to better pagination mechanism using limit & offset instead of keyset pagination
• [x] Improved upon full text search function on Session details plot and listing.

Note to maintainers

Please run db migrations.

See also

• fixes #1467

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
measure-dashboard	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Nov 6, 2024 1:02pm