b2b.transaction_view spans every customer, so an unfiltered query carries
no selective predicate. What keeps the first page cheap is the ordering plus
this cap: the default created_at DESC lets Postgres walk back from now and
stop once it has a page, so cost scales with the page rather than the table.
This replaced a 30-day created_at floor the service injected whenever a
caller bounded nothing itself. The floor bought the same cheap first page,
but by silently answering a narrower question: on 2026-09-19 a
methods=PLATFORM (before it became a subType) search came back empty while ten matching rows
existed, every one of them older than the floor, and the empty state blamed
the filters the operator could see. A cap cannot hide a row; it only ends
the page.
The largest page an admin search will serve.
b2b.transaction_viewspans every customer, so an unfiltered query carries no selective predicate. What keeps the first page cheap is the ordering plus this cap: the defaultcreated_at DESClets Postgres walk back from now and stop once it has a page, so cost scales with the page rather than the table.This replaced a 30-day
created_atfloor the service injected whenever a caller bounded nothing itself. The floor bought the same cheap first page, but by silently answering a narrower question: on 2026-09-19 amethods=PLATFORM (before it became a subType)search came back empty while ten matching rows existed, every one of them older than the floor, and the empty state blamed the filters the operator could see. A cap cannot hide a row; it only ends the page.