Working Around a Case Where the Postgres Planner Is "Not Very Smart"
2021-08-10
Note: This post was originally published on heap’s blog
Heap is a digital insights platform that automatically captures web and mobile behavior like page views, clicks, and taps. We recently shipped Effort Analysis, a way for Heap customers to see the median number of interactions and seconds engaged between each step within a funnel. Here’s what it looks like:
To build this feature, we needed to write a query that could quickly scan more than a billion rows of event data.…