LIMIT / OFFSET

 
    Rows read so far: 0 · Repeats: 0

    Keyset (WHERE id < last)

     
      Rows read so far: 0 · Repeats: 0

      A feed of 40 posts, 5 per page. "Rows read" counts how many rows the database must touch: OFFSET reads the skipped rows plus the page; keyset jumps to its bookmark and reads just the page.