# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.019 | 0.238 | ↑ 1.2 | 23 | 1 |
→
Nested Loop (cost=6.03..28.60 rows=27 width=158) (actual time=0.123..0.238 rows=23 loops=1) |
2. | 0.023 | 0.196 | ↑ 1.2 | 23 | 1 |
→
Nested Loop (cost=5.88..22.95 rows=27 width=36) (actual time=0.119..0.196 rows=23 loops=1) |
3. | 0.052 | 0.150 | ↑ 1.2 | 23 | 1 |
→
Hash Join (cost=5.73..10.31 rows=27 width=24) (actual time=0.111..0.150 rows=23 loops=1)
|
4. | 0.019 | 0.019 | ↑ 1.0 | 168 | 1 |
→
Seq Scan on potensi_sdm (cost=0.00..3.68 rows=168 width=8) (actual time=0.006..0.019 rows=168 loops=1) |
5. | 0.007 | 0.079 | ↑ 1.2 | 23 | 1 |
→
Hash (cost=5.39..5.39 rows=27 width=24) (actual time=0.079..0.079 rows=23 loops=1)
|
6. | 0.040 | 0.072 | ↑ 1.2 | 23 | 1 |
→
Hash Join (cost=1.81..5.39 rows=27 width=24) (actual time=0.040..0.072 rows=23 loops=1)
|
7. | 0.017 | 0.017 | ↑ 1.0 | 168 | 1 |
→
Seq Scan on jumlah_sdm_desa (cost=0.00..2.68 rows=168 width=14) (actual time=0.005..0.017 rows=168 loops=1) |
8. | 0.003 | 0.015 | ↑ 1.1 | 8 | 1 |
→
Hash (cost=1.70..1.70 rows=9 width=18) (actual time=0.015..0.015 rows=8 loops=1)
|
9. | 0.012 | 0.012 | ↑ 1.1 | 8 | 1 |
→
Seq Scan on sdm_desa (cost=0.00..1.70 rows=9 width=18) (actual time=0.008..0.012 rows=8 loops=1)
|
10. | 0.023 | 0.023 | ↑ 1.0 | 1 | 23 |
→
Index Scan using profil_desa_pk on profil_desa (cost=0.15..0.46 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=23)
|
11. | 0.023 | 0.023 | ↑ 1.0 | 1 | 23 |
→
Index Scan using wilayah_pk on wilayah (cost=0.15..0.20 rows=1 width=130) (actual time=0.001..0.001 rows=1 loops=23)
|
Total runtime | : | 0.327 ms |
---|