Pagination Cost Estimator
Quantify deep-page query overhead and identify when keyset pagination is worth adopting.
Guidance
- Switch to keyset for high page numbers, especially when `OFFSET` exceeds tens of thousands.
- Keep sort keys deterministic (`created_at`, `id`) to avoid duplicates and misses.
- Combine pagination strategy with covering indexes for lower read amplification.