Search Ctrl K
Home / Tools
THE FEUTEX TOOLKIT

Offset Pagination Scan Work

Compare cumulative row positions traversed by offset pagination with a keyset walk.

Computer Systems workspace● Runs in your browser
01 Your input
02 Your result
View or copy raw result data
FormulaPages required = Math.ceil(rows/page); Offset traversal upper estimate = page*Math.ceil(rows/page)*(Math.ceil(rows/page)+1)/2; Keyset row traversal = rows

Made for real tasks

  • Compare cumulative row positions traversed by offset pagination with a keyset walk.
Explore step-by-step workflows →

Worked example

Inputs

Total rows
100000 rows
Rows per page
1000 rows

Expected results

Pages required
100 pages
Offset traversal upper estimate
5050000 row positions
Keyset row traversal
100000 rows

Load the example in the workspace to reproduce these results. Display rounding does not change the underlying calculation.

How to use this tool

  1. Enter total rows, rows per page in the displayed units.
  2. Calculate the scenario, then compare it with measurements before changing a system.

Try this example

{
  "rows": 100000,
  "page": 1000
}

Accuracy and scope

Conceptual scan work; last offset page may be overcounted and actual query plans can differ.

Is my data uploaded?

This tool runs locally in your browser. Input and output are not sent to a processing server. Copy or download your result before leaving the page.