PASS: migrations applied twice
PASS: rollback removes partial chat
EXPLAIN: 12000 messages; cursor after row 9001; page 51
Limit  (cost=0.29..13.92 rows=51 width=69) (actual time=0.010..0.021 rows=51 loops=1)
  Buffers: shared hit=4
  ->  Index Scan using messages_history on messages  (cost=0.29..805.74 rows=3012 width=69) (actual time=0.010..0.017 rows=51 loops=1)
        Index Cond: ((chat_id = '72bcdf0e-3925-4d4d-b65f-d1b13c025935'::uuid) AND (ROW(created_at, id) > ROW('2026-01-01 00:00:00.009001+00'::timestamp with time zone, '843e3f43-24f4-4509-9082-6abb79d91871'::uuid)))
        Buffers: shared hit=4
Planning:
  Buffers: shared hit=6
Planning Time: 0.209 ms
Execution Time: 0.046 ms
PASS: history uses messages_history index
