Files
mtusi2026lab2/evidence/explain_composite.txt
2026-10-24 10:56:29 +03:00

14 lines
768 B
Plaintext

QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.42..5.54 rows=50 width=66) (actual time=0.103..0.111 rows=50 loops=1)
Buffers: shared hit=4
-> Index Scan using ix_messages_chat_created_id on messages (cost=0.42..8222.03 rows=80203 width=66) (actual time=0.102..0.107 rows=50 loops=1)
Index Cond: (chat_id = '66666666-6666-4666-8666-666666666666'::uuid)
Buffers: shared hit=4
Planning:
Buffers: shared hit=107
Planning Time: 0.865 ms
Execution Time: 0.168 ms
(9 rows)