How DataFusion Stops Reading After Ten Rows: Limit Pushdown, Limit Absorption, and the Volcano Model's Batch Problem
DataFusion pushes LIMIT into operators that can absorb it, so a ten-row query stops the scan, the join and the sort after ten rows instead of after a full 8192-row batch.