the {adapter} adapter cannot push {work}, so every matching row is fetched and the rest is applied in the browser. Correct, and slower than it needs to be: widening the adapter is the fix.

Warnings reference › source.pushdown.residual.*.*

Identifier

source.pushdown.residual.*.*

Raised by

The grid (core)

Since

1.12.1

What happened

Part of the query could not be expressed to the engine, so the grid asks for every matching row and finishes the work locally. The answer is right; the cost is the full download on every query. The key carries the adapter and exactly which work was left over, so two different shortfalls are two lines.

The fix

Widen the adapter to handle the named work, or narrow the query to what it can push. lastPlan().unpushed names it programmatically.

Reference

Covered in full at the API reference.