# explain: EXPLAIN of the history page (full plans: explain-history.txt)
# date: 2026-11-07 19:44:13, commit: 20afc2c + uncommitted changes
# command: python.exe student-tests/explain.py
# exit code: 0, 0.8 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.015 rows=51 loops=1)
         Buffers: shared hit=54
   Buffers: shared hit=7
 Execution Time: 0.026 ms
=== 2. Page after the 10000th message by keyset cursor (this is what the app does)
   Buffers: shared hit=4
   ->  Index Scan using messages_history on messages (actual time=0.026..0.036 rows=51 loops=1)
         Buffers: shared hit=4
 Execution Time: 0.098 ms
=== 2b. The same page exactly as the app sends it since lab4: with attachment_ids of every message
   Buffers: shared hit=58
   ->  Index Scan using messages_history on messages m (actual time=0.021..0.174 rows=51 loops=1)
         Buffers: shared hit=58
                 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.219 ms
=== 3. The same page with OFFSET 10000 (the app does NOT do this)
   Buffers: shared hit=2553
         Buffers: shared hit=2553
         ->  Bitmap Heap Scan on messages (actual time=0.608..1.680 rows=15000 loops=1)
               Buffers: shared hit=2553
               ->  Bitmap Index Scan on messages_history (actual time=0.458..0.458 rows=15000 loops=1)
                     Buffers: shared hit=194
 Execution Time: 3.484 ms
=== 4. Query 2 without the index (index is dropped only inside this transaction)
   Buffers: shared hit=2375
         Buffers: shared hit=2375
         ->  Bitmap Heap Scan on messages (actual time=1.034..1.289 rows=5000 loops=1)
               Buffers: shared hit=2375
               ->  Bitmap Index Scan on messages_idempotency_key (actual time=0.303..0.303 rows=15000 loops=1)
                     Buffers: shared hit=16
   Buffers: shared hit=4
 Execution Time: 1.665 ms
=== ROLLBACK: test data removed, index is back
PASS: full plans saved to evidence\explain-history.txt
