# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.078 | 3.139 | ↓ 21.0 | 21 | 1 |
→
Hash Join (cost=5.49..30.25 rows=1 width=245) (actual time=2.945..3.139 rows=21 loops=1)
|
2. | 0.143 | 0.143 | ↑ 1.0 | 587 | 1 |
→
Seq Scan on dim_assessmentform frm (cost=0.00..20.34 rows=587 width=16) (actual time=0.009..0.143 rows=587 loops=1)
|
3. | 1.141 | 2.918 | ↓ 21.0 | 3,192 | 1 |
→
Hash (cost=3.21..3.21 rows=152 width=241) (actual time=2.918..2.918 rows=3,192 loops=1)
|
4. | 0.589 | 1.777 | ↓ 21.0 | 3,192 | 1 |
→
Merge Join (cost=2.57..3.21 rows=152 width=241) (actual time=0.085..1.777 rows=3,192 loops=1)
|
5. | 0.813 | 1.166 | ↓ 21.0 | 3,192 | 1 |
→
Nested Loop (cost=1.55..97.61 rows=152 width=249) (actual time=0.061..1.166 rows=3,192 loops=1) |
6. | 0.049 | 0.049 | ↑ 1.0 | 152 | 1 |
→
Index Scan using udx_dim_assessmentlevel on dim_assessmentlevel lvl (cost=0.14..29.12 rows=152 width=20) (actual time=0.012..0.049 rows=152 loops=1)
|
7. | 0.159 | 0.304 | ↓ 21.0 | 21 | 152 |
→
Materialize (cost=1.41..66.60 rows=1 width=233) (actual time=0.000..0.002 rows=21 loops=152) |
8. | 0.017 | 0.145 | ↓ 21.0 | 21 | 1 |
→
Nested Loop (cost=1.41..66.59 rows=1 width=233) (actual time=0.044..0.145 rows=21 loops=1) |
9. | 0.021 | 0.107 | ↓ 21.0 | 21 | 1 |
→
Nested Loop (cost=1.12..66.10 rows=1 width=233) (actual time=0.037..0.107 rows=21 loops=1) |
10. | 0.011 | 0.065 | ↓ 21.0 | 21 | 1 |
→
Nested Loop (cost=0.84..57.79 rows=1 width=233) (actual time=0.029..0.065 rows=21 loops=1) |
11. | 0.019 | 0.019 | ↑ 1.0 | 5 | 1 |
→
Index Scan using idx_dim_assessmentparticipant_2 on dim_assessmentparticipant asmt (cost=0.42..15.52 rows=5 width=48) (actual time=0.013..0.019 rows=5 loops=1)
|
12. | 0.035 | 0.035 | ↓ 4.0 | 4 | 5 |
→
Index Scan using idx_stg_subtestobjective_score_1 on stg_subtestobjective_score x (cost=0.42..8.44 rows=1 width=217) (actual time=0.005..0.007 rows=4 loops=5)
|
13. | 0.021 | 0.021 | ↑ 1.0 | 1 | 21 |
→
Index Scan using pk_dim_assessmentsession on dim_assessmentsession ses (cost=0.28..8.30 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=21)
|
14. | 0.021 | 0.021 | ↑ 1.0 | 1 | 21 |
→
Index Scan using pk_dim_organizations on dim_organizations org (cost=0.29..0.50 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=21)
|
15. | 0.013 | 0.022 | ↓ 17.0 | 17 | 1 |
→
Sort (cost=1.01..1.01 rows=1 width=12) (actual time=0.021..0.022 rows=17 loops=1)
|
16. | 0.009 | 0.009 | ↓ 17.0 | 17 | 1 |
→
Seq Scan on dim_subtest tst (cost=0.00..1.00 rows=1 width=12) (actual time=0.005..0.009 rows=17 loops=1)
|