# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 0.000 | ↓ 0.0 |
→
Limit (cost=63,063.11..63,063.11 rows=1 width=140) (actual rows= loops=) |
||
2. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop (cost=3,208.15..63,063.11 rows=1 width=140) (actual rows= loops=) |
||
3. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Semi Join (cost=3,208.15..63,054.60 rows=1 width=66) (actual rows= loops=)
|
||
4. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Semi Join (cost=162.03..53,079.36 rows=14 width=58) (actual rows= loops=)
|
||
5. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using sas_wf_process_workflow_object_id_key on sas_wf_process rp (cost=0.00..21,839.53 rows=118,886 width=50) (actual rows= loops=) |
||
6. | 0.000 | 0.000 | ↓ 0.0 |
→
Materialize (cost=162.03..6,273.81 rows=14 width=8) (actual rows= loops=) |
||
7. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on sas_wf_operand o (cost=162.03..6,273.74 rows=14 width=8) (actual rows= loops=)
|
||
8. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on operand_label_ix (cost=0.00..162.03 rows=2,878 width=0) (actual rows= loops=)
|
||
9. | 0.000 | 0.000 | ↓ 0.0 |
→
Materialize (cost=3,046.12..9,963.27 rows=57 width=8) (actual rows= loops=) |
||
10. | 0.000 | 0.000 | ↓ 0.0 |
→
Nested Loop Anti Join (cost=3,046.12..9,962.98 rows=57 width=8) (actual rows= loops=) |
||
11. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash Join (cost=3,046.12..9,913.18 rows=70 width=16) (actual rows= loops=)
|
||
12. | 0.000 | 0.000 | ↓ 0.0 |
→
Seq Scan on sas_wf_process_ace a (cost=0.00..5,170.83 rows=117,687 width=35) (actual rows= loops=)
|
||
13. | 0.000 | 0.000 | ↓ 0.0 |
→
Hash (cost=2,972.22..2,972.22 rows=5,912 width=20) (actual rows= loops=)
|
||
14. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Heap Scan on sas_wf_process p (cost=262.92..2,972.22 rows=5,912 width=20) (actual rows= loops=)
|
||
15. | 0.000 | 0.000 | ↓ 0.0 |
→
Bitmap Index Scan on process_state_ix (cost=0.00..261.44 rows=6,020 width=0) (actual rows= loops=)
|
||
16. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using process_parent_ix on sas_wf_process sp (cost=0.00..3.07 rows=5 width=8) (actual rows= loops=)
|
||
17. | 0.000 | 0.000 | ↓ 0.0 |
→
Index Scan using operand_pid_ln_ix on sas_wf_operand rop (cost=0.00..8.50 rows=1 width=106) (actual rows= loops=)
|