OFFSET Doesn't Skip Rows: What 10M Rows in PostgreSQL Actually Cost

OFFSET 9999980 LIMIT 20 does not skip 9,999,980 rows. It reads every one of them, builds each tuple,...