PostHog / posthog

🦔 PostHog provides open-source product analytics, session recording, feature flagging and A/B testing that you can self-host.
https://posthog.com
Other
19.35k stars 1.13k forks source link

feat(web-analytics): Add LCP to sessions table v2, and fix mismatch between order by and group by #23347

Closed robbie-c closed 1 day ago

robbie-c commented 4 days ago

Problem

Changes

Add the first_lcp column, and in the processing of removing and recreating the MV, fix up this difference.

Does this work well for both Cloud and self-hosted?

How did you test this code?

On master, with a fresh db, created the demo project. Then checked out this branch and migrated it, making sure that things still work. Also added to test coverage.