search

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
20.36k stars 1.21k forks source link

Bug Report: Event values endpoint throws a timeout exception for large teams #23426

Open skoob13 opened 1 month ago

skoob13 commented 1 month ago

Bug Description

Bug description

For some large teams, the /api/events/values endpoint sometimes returns 504 or 512 errors.

Example of the 512 response:

{
    "type": "server_error",
    "code": "error",
    "detail": "Estimated query execution time (61.24618196061911 seconds) is too long. Try reducing its scope by changing the time range.",
    "attr": null
}

Additional context

Related support ticket: https://posthoghelp.zendesk.com/agent/tickets/15299 +1 from the Posthog team

webjunkie commented 1 month ago

We should check if this endpoint should still be supported by us at all... since there is also events endpoint.

Another ticket that had this problem https://posthoghelp.zendesk.com/agent/tickets/14142