# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 60.307 | 495.670 | ↓ 0.0 | 0 | 1 |
→
Hash Join (cost=64,844.05..68,795.81 rows=8,211 width=8) (actual time=495.670..495.670 rows=0 loops=1)
|
2. | 12.147 | 12.147 | ↓ 1.1 | 32,841 | 1 |
→
Index Scan using cal_event_i04 on cal_event_t ce (cost=0.00..1,703.27 rows=31,138 width=16) (actual time=0.013..12.147 rows=32,841 loops=1)
|
3. | 75.772 | 423.216 | ↓ 1.5 | 587,230 | 1 |
→
Hash (cost=58,338.96..58,338.96 rows=396,487 width=4) (actual time=423.216..423.216 rows=587,230 loops=1)
|
4. | 187.262 | 347.444 | ↓ 1.5 | 587,230 | 1 |
→
Hash Join (cost=1.17..58,338.96 rows=396,487 width=4) (actual time=0.036..347.444 rows=587,230 loops=1)
|
5. | 160.176 | 160.176 | ↑ 1.0 | 1,387,705 | 1 |
→
Seq Scan on om_task_t tt (cost=0.00..50,821.05 rows=1,387,705 width=8) (actual time=0.024..160.176 rows=1,387,705 loops=1) |
6. | 0.001 | 0.006 | ↑ 1.0 | 2 | 1 |
→
Hash (cost=1.15..1.15 rows=2 width=8) (actual time=0.006..0.006 rows=2 loops=1)
|
7. | 0.005 | 0.005 | ↑ 1.0 | 2 | 1 |
→
Seq Scan on fm_status_t st (cost=0.00..1.15 rows=2 width=8) (actual time=0.004..0.005 rows=2 loops=1)
|