ROBOT TRADER

Sort (cost=8.73..8.73 rows=1 width=723) Sort Key: m.created_lt -> Nested Loop (cost=2.00..8.72 rows=1 width=723) -> Nested Loop (cost=1.30..5.76 rows=1 width=693) -> Index Scan using messages_created_at on messages m (cost=0.59..2.83 rows=1 width=668) Index Cond: ((created_at > (EXTRACT(epoch FROM to_timestamp('2025-11-29 00:00:00'::text, 'YYYY-MM-DD HH24:MI:SS'::text)))::bigint) AND (created_at < (EXTRACT(epoch FROM to_timestamp('2025-12-29 04:52:18'::text, 'YYYY-MM-DD HH24:MI:SS'::text)))::bigint)) Filter: ((value > 10000000) AND (value < 1000000000) AND (msg_type = 'IntMsg'::message_type) AND (((source)::text = '0:1a590d217201b5ea549265df5faf6def2f2fe1cf53befa78f14efdc073753e7f'::text) OR ((destination)::text = '0:1a590d217201b5ea549265df5faf6def2f2fe1cf53befa78f14efdc073753e7f'::text))) -> Index Scan using transactions_in_msg_index on transactions tx (cost=0.70..2.92 rows=1 width=57) Index Cond: (in_msg = m.id) -> Index Scan using transactions_pk on transactions tx_src (cost=0.70..2.92 rows=1 width=41) Index Cond: ((id)::bytea = (m.parent_tx_id)::bytea)