Wrote this after seeing partition pruning silently fail with a parameterized query - the planner can’t prune on a value it doesn’t have yet at plan time. Covers the three common ways people accidentally defeat pruning and how to check EXPLAIN to tell whether it actually fired.