explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EfWZ : Optimization for: plan #H4w4

Settings

Optimization path:

# 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)

  • Hash Cond: (potensi_sdm.id_jumlah_sdm = jumlah_sdm_desa.id_jumlah_sdm)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
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)

  • Hash Cond: (jumlah_sdm_desa.id_sdm_desa = sdm_desa.id_sdm_desa)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
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)

  • Filter: (sdm_id_sdm_desa = 32)
  • Rows Removed by Filter: 48
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)

  • Index Cond: (id_desa = potensi_sdm.id_desa)
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)

  • Index Cond: (id_wilayah = profil_desa.id_wilayah)