# EXPLAIN (ANALYZE, BUFFERS) для истории сообщений
# date: 2026-10-02T11:01:11Z
# chat_id: cf9e8ca9-d08c-41d1-b55f-18c9fba43aec

## Ключевой запрос пагинации
                                                                     QUERY PLAN                                                                      
-----------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.29..4.38 rows=50 width=73) (actual time=0.021..0.029 rows=50 loops=1)
   Buffers: shared hit=3
   ->  Index Scan using messages_chat_created_id_idx on messages  (cost=0.29..819.43 rows=10000 width=73) (actual time=0.020..0.025 rows=50 loops=1)
         Index Cond: (chat_id = 'cf9e8ca9-d08c-41d1-b55f-18c9fba43aec'::uuid)
         Buffers: shared hit=3
 Planning:
   Buffers: shared hit=111
 Planning Time: 0.694 ms
 Execution Time: 0.063 ms
(9 rows)


## Индексы таблицы messages
          indexname           |                                              indexdef                                              
------------------------------+----------------------------------------------------------------------------------------------------
 messages_pkey                | CREATE UNIQUE INDEX messages_pkey ON public.messages USING btree (id)
 messages_chat_created_id_idx | CREATE INDEX messages_chat_created_id_idx ON public.messages USING btree (chat_id, created_at, id)
(2 rows)


## Оценка размера и количества
 estimated_rows | total_size 
----------------+------------
          10222 | 2264 kB
(1 row)

