Optimization Showdown: Keyset vs Offset Pagination

Choose better query and provide final SQL for page after last seen (created_at,id). Query A: SELECT order_id, created_at FROM orders WHERE status='PAID' ORDER BY created_at DESC LIMIT 50 OFFSET 5000; Query B: SELECT order_id, created_at FROM orders WHERE status='PAID' AND (created_at, order_id) < (TIMESTAMP '2025-01-10 10:00:00', 800001) ORDER BY created_at DESC, order_id DESC LIMIT 50;

orders(order_id, status, created_at)