And that's a plan flip! The histogram tells the planner the data spans 2019–2024, so '2024-06-01' matches a narrow tail. A small fraction of 50 million rows. The index scan that was ignored before is now the obvious choice. Table-level stats set the scale, column-level stats shaped the selectivity, and together they changed the plan.
And before we end, I want to share that I am releasing cgp-serde today, with a companion article to this talk. So do check out the blog post after this, and help spread the word on social media.
。新收录的资料是该领域的重要参考
2025-07-25 20:05:00 +02:00
Release Engineering