forked from mtusi2026/mtusi2026lab2
14 lines
768 B
Plaintext
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)
|
|
|