-- run 3
-- offset, page 50000 (page size 20)
-- SELECT id, created_at, customer, total FROM orders ORDER BY created_at DESC, id DESC LIMIT 20 OFFSET $1
-- params: [999980]

Limit  (cost=63746.77..63748.05 rows=20 width=37) (actual time=340.100..340.106 rows=20 loops=1)
  Buffers: shared hit=1007665
  ->  Index Scan Backward using orders_created_at_id_idx on orders  (cost=0.42..63748.05 rows=1000000 width=37) (actual time=0.020..318.155 rows=1000000 loops=1)
        Buffers: shared hit=1007665
Planning Time: 0.034 ms
Execution Time: 340.145 ms