# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 4.605 | 431.338 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=182,193.31..182,193.32 rows=1 width=0) (actual time=431.338..431.338 rows=1 loops=1) |
2. | 11.633 | 426.733 | ↓ 2.4 | 24,785 | 1 |
→
Nested Loop (cost=1.12..182,167.46 rows=10,342 width=0) (actual time=0.196..426.733 rows=24,785 loops=1) |
3. | 291.175 | 291.175 | ↓ 1.8 | 24,785 | 1 |
→
Index Scan using index_trade_audit_brief_query on tb_trade_audit_brief (cost=0.56..47,747.16 rows=13,719 width=4) (actual time=0.174..291.175 rows=24,785 loops=1)
|
4. | 123.925 | 123.925 | ↑ 1.0 | 1 | 24,785 |
→
Index Scan using com_seq_id_index on tb_ws_punishdetail (cost=0.56..9.79 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=24,785)
|