# Дата (UTC): 2026-10-23 10:18:50
# Commit: 65003b6
# Команда: docker compose --env-file .env exec -T api python -m app.explain
# ---------------------------------------- вывод ----------------------------------------
PostgreSQL: 16.6 (Debian 16.6-1.pgdg120+1)
Сообщений всего: 60005
Сообщений в большом чате: 20000
Размер таблицы messages: 6784 kB
Размер индекса messages_chat_created_idx: 5992 kB

==============================================================================
1. Первая страница (без cursor), запрос приложения
==============================================================================
SELECT messages.id, messages.chat_id, messages.sender_id, messages.text, messages.created_at 
FROM messages 
WHERE messages.chat_id = $1::UUID ORDER BY messages.created_at, messages.id 
 LIMIT $2::INTEGER
-- параметры: b21f9b12-3f7c-5896-bc0d-5c48f78f3576, 51
Limit  (cost=0.41..12.38 rows=51 width=80) (actual time=0.008..0.022 rows=51 loops=1)
  Buffers: shared hit=6
  ->  Index Scan using messages_chat_created_idx on messages  (cost=0.41..4718.99 rows=20106 width=80) (actual time=0.007..0.018 rows=51 loops=1)
        Index Cond: (chat_id = 'b21f9b12-3f7c-5896-bc0d-5c48f78f3576'::uuid)
        Buffers: shared hit=6
Planning:
  Buffers: shared hit=6
Planning Time: 0.073 ms
Execution Time: 0.032 ms

==============================================================================
2. Глубокая страница: cursor после 15000-го сообщения (keyset)
==============================================================================
SELECT messages.id, messages.chat_id, messages.sender_id, messages.text, messages.created_at 
FROM messages 
WHERE messages.chat_id = $1::UUID AND (messages.created_at, messages.id) > ($2::TIMESTAMP WITH TIME ZONE, $3) ORDER BY messages.created_at, messages.id 
 LIMIT $4::INTEGER
-- параметры: b21f9b12-3f7c-5896-bc0d-5c48f78f3576, 2026-09-23 10:26:18.547526+00:00, c108c4dd-61dd-4321-8b6c-70b26623adf7, 51
Limit  (cost=0.41..38.34 rows=51 width=80) (actual time=0.009..0.022 rows=51 loops=1)
  Buffers: shared hit=6
  ->  Index Scan using messages_chat_created_idx on messages  (cost=0.41..3712.96 rows=4992 width=80) (actual time=0.008..0.019 rows=51 loops=1)
        Index Cond: ((chat_id = 'b21f9b12-3f7c-5896-bc0d-5c48f78f3576'::uuid) AND (ROW(created_at, id) > ROW('2026-09-23 10:26:18.547526+00'::timestamp with time zone, 'c108c4dd-61dd-4321-8b6c-70b26623adf7'::uuid)))
        Buffers: shared hit=6
Planning Time: 0.052 ms
Execution Time: 0.049 ms

==============================================================================
3. Для сравнения: та же страница через OFFSET (так приложение НЕ делает)
==============================================================================
SELECT * FROM messages WHERE chat_id = $1 ORDER BY created_at, id OFFSET 15000 LIMIT 51
-- параметры: b21f9b12-3f7c-5896-bc0d-5c48f78f3576
Limit  (cost=3072.67..3072.80 rows=51 width=80) (actual time=7.919..7.925 rows=51 loops=1)
  Buffers: shared hit=848
  ->  Sort  (cost=3035.17..3085.44 rows=20106 width=80) (actual time=6.788..7.505 rows=15051 loops=1)
        Sort Key: created_at, id
        Sort Method: quicksort  Memory: 3271kB
        Buffers: shared hit=848
        ->  Seq Scan on messages  (cost=0.00..1598.06 rows=20106 width=80) (actual time=0.006..5.029 rows=20000 loops=1)
              Filter: (chat_id = 'b21f9b12-3f7c-5896-bc0d-5c48f78f3576'::uuid)
              Rows Removed by Filter: 40005
              Buffers: shared hit=848
Planning Time: 0.035 ms
Execution Time: 7.938 ms

==============================================================================
4. Для сравнения: запрос приложения БЕЗ индекса (DROP INDEX в транзакции, затем ROLLBACK)
==============================================================================
SELECT messages.id, messages.chat_id, messages.sender_id, messages.text, messages.created_at 
FROM messages 
WHERE messages.chat_id = $1::UUID AND (messages.created_at, messages.id) > ($2::TIMESTAMP WITH TIME ZONE, $3) ORDER BY messages.created_at, messages.id 
 LIMIT $4::INTEGER
-- параметры: b21f9b12-3f7c-5896-bc0d-5c48f78f3576, 2026-09-23 10:26:18.547526+00:00, c108c4dd-61dd-4321-8b6c-70b26623adf7, 51
Limit  (cost=2064.63..2064.76 rows=51 width=80) (actual time=5.644..5.649 rows=51 loops=1)
  Buffers: shared hit=848
  ->  Sort  (cost=2064.63..2077.11 rows=4992 width=80) (actual time=5.643..5.645 rows=51 loops=1)
        Sort Key: created_at, id
        Sort Method: top-N heapsort  Memory: 31kB
        Buffers: shared hit=848
        ->  Seq Scan on messages  (cost=0.00..1898.09 rows=4992 width=80) (actual time=3.769..5.197 rows=5000 loops=1)
              Filter: ((chat_id = 'b21f9b12-3f7c-5896-bc0d-5c48f78f3576'::uuid) AND (ROW(created_at, id) > ROW('2026-09-23 10:26:18.547526+00'::timestamp with time zone, 'c108c4dd-61dd-4321-8b6c-70b26623adf7'::uuid)))
              Rows Removed by Filter: 55005
              Buffers: shared hit=848
Planning:
  Buffers: shared hit=4
Planning Time: 0.067 ms
Execution Time: 5.661 ms

Индекс messages_chat_created_idx на месте: True
# ---------------------------------------------------------------------------------------
# Код возврата: 0
# Время выполнения: 2.44 с
