INSERT 0 0 INSERT 0 0 INSERT 0 0 INSERT 0 10000 ANALYZE === message count === messages ---------- 10000 (1 row) === EXPLAIN (ANALYZE, BUFFERS): keyset page in the middle of history === QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=0.42..17.91 rows=50 width=70) (actual time=0.006..0.014 rows=50 loops=1) Buffers: shared hit=5 -> Index Scan using messages_chat_created_id_idx on messages (cost=0.42..1719.51 rows=4913 width=70) (actual time=0.006..0.011 rows=50 loops=1) Index Cond: ((chat_id = '00000000-0000-4000-8000-0000000000aa'::uuid) AND (ROW(created_at, id) > ROW((now() - '01:23:20'::interval), '00000000-0000-4000-8000-000000000000'::uuid))) Buffers: shared hit=5 Planning: Buffers: shared hit=20 Planning Time: 0.056 ms Execution Time: 0.028 ms (9 rows) === EXPLAIN (ANALYZE, BUFFERS): first page (no cursor) === QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=0.41..11.29 rows=50 width=70) (actual time=21.930..21.937 rows=50 loops=1) Buffers: shared hit=266 read=126 dirtied=126 -> Index Scan using messages_chat_created_id_idx on messages (cost=0.41..2176.76 rows=10000 width=70) (actual time=21.929..21.933 rows=50 loops=1) Index Cond: (chat_id = '00000000-0000-4000-8000-0000000000aa'::uuid) Buffers: shared hit=266 read=126 dirtied=126 Planning Time: 0.022 ms Execution Time: 21.948 ms (7 rows)