# EXPLAIN (ANALYZE, BUFFERS) for keyset history pagination
generated_at_utc: 2026-11-06T19:27:08.308823Z
messages_in_chat: 10000
chat_id: 009edfde-74bf-4dd7-8e55-a665d2d6f38a
query: WHERE chat_id = ? AND (created_at, id) > (?, ?) ORDER BY created_at, id LIMIT 51

Limit  (cost=0.29..94.71 rows=51 width=78) (actual time=0.020..0.029 rows=51 loops=1)
  Buffers: shared hit=4
  ->  Index Scan using messages_chat_created_at_id_idx on messages  (cost=0.29..926.01 rows=500 width=78) (actual time=0.019..0.025 rows=51 loops=1)
        Index Cond: ((chat_id = '009edfde-74bf-4dd7-8e55-a665d2d6f38a'::uuid) AND (ROW(created_at, id) > ROW('2026-01-01 00:00:09.501+00'::timestamp with time zone, 'd8f60f44-b107-4f1a-bae2-4fcf80d33d70'::uuid)))
        Buffers: shared hit=4
Planning:
  Buffers: shared hit=6
Planning Time: 0.138 ms
Execution Time: 0.124 ms
PASS: index used on 10000 messages; evidence written to /tmp/explain_history.txt
