指定
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)
反馈
1
等级
项目
316
29%
仲裁
34
26%
/
65%
逾期
10
3%
空闲
2
等级
项目
317
24%
仲裁
23
35%
/
13%
逾期
23
7%
空闲
发布者: 3 代码
3
等级
项目
39
23%
仲裁
14
0%
/
93%
逾期
4
10%
空闲
4
等级
项目
476
40%
仲裁
105
40%
/
24%
逾期
81
17%
繁忙
发布者: 2 代码
相似订单
ROBOT TRADER
50+ USD
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
项目信息
预算
1000+ USD
客户
所下订单2
仲裁计数0