Retention insights loading can be slow

[hazzadous]

In what situation are you experiencing subpar performance?

For example:

• Viewing retention insights
• With breakdowns on high cardinality fields

I haven't looked in detail on the exact scenarios. This is more a placeholder to ensure we consider this case.

• add stats on real queries to get an understanding of how much an issue this is

How to reproduce

This one for instance

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!

[macobo]

Should measure this after we have the events table migration done - the new sort key will help here quite a bit :)

[posthog-bot]

This issue hasn't seen activity in two years! If you want to keep it open, post a comment or remove the stale label – otherwise this will be closed in two weeks.

[posthog-bot]

This issue was closed due to lack of activity. Feel free to reopen if it's still relevant.