date: 2026-11-05T21:56:23.714059+00:00 commit: 07965a2fb67b57f6031fed70a9a3ae963571269f
$ docker compose exec -T api python <<'PY'
import asyncio
import sqlalchemy
from uuid import UUID
from sqlalchemy import literal, make_url, select, text, tuple_
from sqlalchemy.ext.asyncio import create_async_engine
from messenger.messaging.infrastructure.postgres import ChatRow, MessageRow
from messenger.shared.config import PlatformSettings

async def main():
    engine = create_async_engine(make_url(PlatformSettings().database_url.get_secret_value()).set(drivername="postgresql+asyncpg"), hide_parameters=True)
    try:
        async with engine.connect() as connection:
            print("SQLAlchemy", sqlalchemy.__version__)
            print(await connection.scalar(select(sqlalchemy.func.version())))
            chat = await connection.scalar(select(ChatRow.id).where(ChatRow.title.startswith("k6 ")).order_by(ChatRow.created_at.desc()).limit(1))
            if chat is None:
                raise RuntimeError("run track1 first")
            first = select(MessageRow.id, MessageRow.chat_id, MessageRow.sender_id, MessageRow.text, MessageRow.created_at).where(MessageRow.chat_id == chat).order_by(MessageRow.created_at, MessageRow.id).limit(51)
            cursor = (await connection.execute(select(MessageRow.created_at, MessageRow.id).where(MessageRow.chat_id == chat).order_by(MessageRow.created_at, MessageRow.id).offset(1000).limit(1))).first()
            queries = [("first page", first)]
            if cursor is not None:
                queries += [("keyset after 1001", first.where(tuple_(MessageRow.created_at, MessageRow.id) > tuple_(literal(cursor[0]), literal(UUID(int=cursor[1].int))))), ("offset 1001 (comparison only)", first.offset(1001))]
            for label, statement in queries:
                compiled = str(statement.compile(dialect=engine.dialect, compile_kwargs={"literal_binds": True}))
                print(label, compiled, sep="\n")
                for row in await connection.execute(text("EXPLAIN (ANALYZE, BUFFERS) " + compiled)):
                    print(row[0])
    finally:
        await engine.dispose()

asyncio.run(main())
PY

SQLAlchemy 2.0.45
PostgreSQL 17.11 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 15.2.0) 15.2.0, 64-bit
first page
SELECT messages.id, messages.chat_id, messages.sender_id, messages.text, messages.created_at
FROM messages
WHERE messages.chat_id = '01a1adb3-a03e-7172-85b9-f7c54b7d443c' ORDER BY messages.created_at, messages.id
 LIMIT 51
Limit  (cost=0.56..91.85 rows=51 width=81) (actual time=0.005..0.016 rows=51 loops=1)
  Buffers: shared hit=56
  ->  Index Scan using messages_history_idx on messages  (cost=0.56..11104.46 rows=6203 width=81) (actual time=0.005..0.013 rows=51 loops=1)
        Index Cond: (chat_id = '01a1adb3-a03e-7172-85b9-f7c54b7d443c'::uuid)
        Buffers: shared hit=56
Planning:
  Buffers: shared hit=8
Planning Time: 0.047 ms
Execution Time: 0.021 ms
keyset after 1001
SELECT messages.id, messages.chat_id, messages.sender_id, messages.text, messages.created_at
FROM messages
WHERE messages.chat_id = '01a1adb3-a03e-7172-85b9-f7c54b7d443c' AND (messages.created_at, messages.id) > ('2026-11-05 21:53:19.099252+00:00', '01a1adb3-b8bf-7142-8926-0a5f9c9125d5') ORDER BY messages.created_at, messages.id
 LIMIT 51
Limit  (cost=0.56..8.58 rows=1 width=81) (actual time=0.009..0.135 rows=51 loops=1)
  Buffers: shared hit=43 read=13 dirtied=12
  I/O Timings: shared read=0.035
  ->  Index Scan using messages_history_idx on messages  (cost=0.56..8.58 rows=1 width=81) (actual time=0.009..0.133 rows=51 loops=1)
        Index Cond: ((chat_id = '01a1adb3-a03e-7172-85b9-f7c54b7d443c'::uuid) AND (ROW(created_at, id) > ROW('2026-11-05 21:53:19.099252+00'::timestamp with time zone, '01a1adb3-b8bf-7142-8926-0a5f9c9125d5'::uuid)))
        Buffers: shared hit=43 read=13 dirtied=12
        I/O Timings: shared read=0.035
Planning Time: 0.021 ms
Execution Time: 0.158 ms
offset 1001 (comparison only)
SELECT messages.id, messages.chat_id, messages.sender_id, messages.text, messages.created_at
FROM messages
WHERE messages.chat_id = '01a1adb3-a03e-7172-85b9-f7c54b7d443c' ORDER BY messages.created_at, messages.id
 LIMIT 51 OFFSET 1001
Limit  (cost=1792.44..1883.73 rows=51 width=81) (actual time=0.143..0.151 rows=51 loops=1)
  Buffers: shared hit=1044
  ->  Index Scan using messages_history_idx on messages  (cost=0.56..11104.46 rows=6203 width=81) (actual time=0.006..0.130 rows=1052 loops=1)
        Index Cond: (chat_id = '01a1adb3-a03e-7172-85b9-f7c54b7d443c'::uuid)
        Buffers: shared hit=1044
Planning Time: 0.018 ms
Execution Time: 0.161 ms
exit: 0
