Slow session recording playback loading

[alexkim205]

In what situation are you experiencing subpar performance?

Session recording playback loading times are slow because we're querying for a large amount of session recording events for long sessions. This delay starts getting noticeable when recordings > 1hr on my 32GB Macbook Pro, but I can imagine it gets worse for slower computers.

Should be fixed as part of #6077 epic

How to reproduce

1. Click "Watch session" for a long session recording
2. Wait a long time until you can start watching the recording

Environment

• PostHog Cloud
• self-hosted PostHog, version/commit: please provide

Additional context

Thank you for your performance issue report – we want PostHog to go supersonic!