Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

HogQL optimization that filters events early on #21269

Open
thmsobrmlr opened this issue Apr 2, 2024 · 0 comments
Open

HogQL optimization that filters events early on #21269

thmsobrmlr opened this issue Apr 2, 2024 · 0 comments
Labels
feature/hogql feature/insights Feature Tag: Insights overall performance Has to do with performance. For PRs, runs the clickhouse query performance suite team/product-analytics

Comments

@thmsobrmlr
Copy link
Contributor

In what situation are you experiencing subpar performance?

In certain situation pushing down the event filter predicate can speed up the query time substantially.

How to reproduce

An example of this including a manual solution can be seen in the following ticket: https://posthoghelp.zendesk.com/agent/tickets/12073.

Additional context

Making this an automatic optimization with HogQL after the rewrite should likely be a performance fix we should prioritize.
@thmsobrmlr thmsobrmlr added the performance Has to do with performance. For PRs, runs the clickhouse query performance suite label Apr 2, 2024
@thmsobrmlr thmsobrmlr mentioned this issue Apr 2, 2024
Open
48 tasks
@thmsobrmlr thmsobrmlr changed the title HogQL optimization that filters event early on HogQL optimization that filters events early on Apr 2, 2024
@thmsobrmlr thmsobrmlr mentioned this issue Apr 4, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature/hogql feature/insights Feature Tag: Insights overall performance Has to do with performance. For PRs, runs the clickhouse query performance suite team/product-analytics
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@thmsobrmlr @Twixes