﻿# EXPLAIN (ANALYZE, BUFFERS) for keyset history pagination
generated_at_utc: 2026-11-06T21:33:40.352590Z
messages_in_chat: 10000
chat_id: ce8f7912-30b3-44c6-98f3-aae338209bea
query: WHERE chat_id = ? AND (created_at, id) > (?, ?) ORDER BY created_at, id LIMIT 51

Limit  (cost=0.29..11.81 rows=51 width=77) (actual time=0.024..0.032 rows=51 loops=1)
  Buffers: shared hit=4
  ->  Index Scan using messages_chat_created_at_id_idx on messages  (cost=0.29..973.31 rows=4305 width=77) (actual time=0.023..0.028 rows=51 loops=1)
        Index Cond: ((chat_id = 'ce8f7912-30b3-44c6-98f3-aae338209bea'::uuid) AND (ROW(created_at, id) > ROW('2026-01-01 00:00:09.501+00'::timestamp with time zone, '806c83dc-f566-4736-8ef4-094bdcd28f33'::uuid)))
        Buffers: shared hit=4
Planning:
  Buffers: shared hit=7
Planning Time: 0.208 ms
Execution Time: 0.138 ms
