forked from mtusi2026/mtusi2026lab2
38 lines
2.0 KiB
Plaintext
38 lines
2.0 KiB
Plaintext
INSERT 0 0
|
|
INSERT 0 0
|
|
INSERT 0 0
|
|
INSERT 0 10000
|
|
ANALYZE
|
|
=== message count ===
|
|
messages
|
|
----------
|
|
10000
|
|
(1 row)
|
|
|
|
=== EXPLAIN (ANALYZE, BUFFERS): keyset page in the middle of history ===
|
|
QUERY PLAN
|
|
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
Limit (cost=0.42..17.91 rows=50 width=70) (actual time=0.006..0.014 rows=50 loops=1)
|
|
Buffers: shared hit=5
|
|
-> Index Scan using messages_chat_created_id_idx on messages (cost=0.42..1719.51 rows=4913 width=70) (actual time=0.006..0.011 rows=50 loops=1)
|
|
Index Cond: ((chat_id = '00000000-0000-4000-8000-0000000000aa'::uuid) AND (ROW(created_at, id) > ROW((now() - '01:23:20'::interval), '00000000-0000-4000-8000-000000000000'::uuid)))
|
|
Buffers: shared hit=5
|
|
Planning:
|
|
Buffers: shared hit=20
|
|
Planning Time: 0.056 ms
|
|
Execution Time: 0.028 ms
|
|
(9 rows)
|
|
|
|
=== EXPLAIN (ANALYZE, BUFFERS): first page (no cursor) ===
|
|
QUERY PLAN
|
|
--------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
Limit (cost=0.41..11.29 rows=50 width=70) (actual time=21.930..21.937 rows=50 loops=1)
|
|
Buffers: shared hit=266 read=126 dirtied=126
|
|
-> Index Scan using messages_chat_created_id_idx on messages (cost=0.41..2176.76 rows=10000 width=70) (actual time=21.929..21.933 rows=50 loops=1)
|
|
Index Cond: (chat_id = '00000000-0000-4000-8000-0000000000aa'::uuid)
|
|
Buffers: shared hit=266 read=126 dirtied=126
|
|
Planning Time: 0.022 ms
|
|
Execution Time: 21.948 ms
|
|
(7 rows)
|
|
|