Files
mtusi2026lab6/evidence/explain.txt

47 lines
2.3 KiB
Plaintext

# explain: EXPLAIN of the history page (full plans: explain-history.txt)
# date: 2026-11-01 20:42:57, commit: 470d9d6 + uncommitted changes
# command: python.exe student-tests/explain.py
# exit code: 0, 1.2 s
=== Data volume
=== History index
=== 1. First page: limit=50, the app asks for 51 rows to know if there is a next page
Buffers: shared hit=54
-> Index Scan using messages_history on messages (actual time=0.007..0.016 rows=51 loops=1)
Buffers: shared hit=54
Buffers: shared hit=8
Execution Time: 0.026 ms
=== 2. Page after the 10000th message by keyset cursor (this is what the app does)
Buffers: shared hit=5
-> Index Scan using messages_history on messages (actual time=0.006..0.009 rows=51 loops=1)
Buffers: shared hit=5
Execution Time: 0.047 ms
=== 2b. The same page exactly as the app sends it since lab4: with attachment_ids of every message
Buffers: shared hit=59
-> Index Scan using messages_history on messages m (actual time=0.024..0.173 rows=51 loops=1)
Buffers: shared hit=59
Buffers: shared hit=54
-> Bitmap Heap Scan on message_attachments a (actual time=0.000..0.000 rows=0 loops=51)
Buffers: shared hit=51
-> Bitmap Index Scan on message_attachments_message_id_attachment_id_key (actual time=0.000..0.000 rows=0 loops=51)
Buffers: shared hit=51
Buffers: shared hit=63
Execution Time: 0.193 ms
=== 3. The same page with OFFSET 10000 (the app does NOT do this)
Buffers: shared hit=1255
Buffers: shared hit=1255
-> Seq Scan on messages (actual time=0.006..2.281 rows=15000 loops=1)
Buffers: shared hit=1255
Execution Time: 4.136 ms
=== 4. Query 2 without the index (index is dropped only inside this transaction)
Buffers: shared hit=1006
Buffers: shared hit=1006
-> Bitmap Heap Scan on messages (actual time=0.726..1.001 rows=5000 loops=1)
Buffers: shared hit=1006
-> Bitmap Index Scan on messages_idempotency_key (actual time=0.217..0.217 rows=15000 loops=1)
Buffers: shared hit=15
Buffers: shared hit=4
Execution Time: 1.395 ms
=== ROLLBACK: test data removed, index is back
PASS: full plans saved to evidence\explain-history.txt