However, this query is very simple. It is literally just select column one column two column 3 from table and then there is an order by and a fetch and an offset. That's it. The point was to essentially output all records but chunked into 7 million at a time.
Are you the same person as the OP? If so, why did you create a new account?
What seems like a simple query to you may be giving the query engine a headache because your table is not indexed in a way which supports the query. This would explain why the partial extraction is slower than extracting the whole table and also explains why I asked about the execution plan.