explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6lSF

Settings
# exclusive inclusive rows x rows loops node
1. 18.246 121.841 ↑ 1.0 2,520 1

Hash Left Join (cost=911.13..1,314.79 rows=2,523 width=377) (actual time=68.032..121.841 rows=2,520 loops=1)

  • Hash Cond: (barrio.cod_city = city.id)
2. 5.592 102.380 ↑ 1.0 2,520 1

Hash Left Join (cost=895.52..1,227.52 rows=2,523 width=334) (actual time=66.752..102.380 rows=2,520 loops=1)

  • Hash Cond: (ubicacion.id_barrio = barrio.id_barrio)
3. 6.208 92.393 ↑ 1.0 2,520 1

Hash Left Join (cost=831.48..1,125.63 rows=2,523 width=320) (actual time=62.315..92.393 rows=2,520 loops=1)

  • Hash Cond: (planificacion.id_ubicacion = ubicacion.id_ubicacion)
4. 15.158 78.687 ↑ 1.0 2,520 1

Hash Join (cost=705.11..975.02 rows=2,523 width=233) (actual time=54.782..78.687 rows=2,520 loops=1)

  • Hash Cond: (periodo.id_planificacion = planificacion.id_planificacion)
5. 8.862 8.862 ↓ 1.0 9,913 1

Seq Scan on periodo (cost=0.00..195.12 rows=9,912 width=36) (actual time=0.010..8.862 rows=9,913 loops=1)

6. 5.704 54.667 ↑ 1.0 2,520 1

Hash (cost=673.57..673.57 rows=2,523 width=201) (actual time=54.667..54.667 rows=2,520 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 440kB
7. 6.562 48.963 ↑ 1.0 2,520 1

Hash Join (cost=170.50..673.57 rows=2,523 width=201) (actual time=5.849..48.963 rows=2,520 loops=1)

  • Hash Cond: (planificacion.id_unidad_operativa = unidad_operativa.id_unidad_operativa)
8. 6.470 42.185 ↑ 1.0 2,520 1

Nested Loop (cost=166.36..634.74 rows=2,523 width=185) (actual time=5.606..42.185 rows=2,520 loops=1)

9. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on sub_estado (cost=0.00..1.04 rows=1 width=4) (actual time=0.008..0.011 rows=1 loops=1)

  • Filter: (id_subestado = 2)
  • Rows Removed by Filter: 2
10. 6.320 35.704 ↑ 1.0 2,520 1

Hash Join (cost=166.36..608.48 rows=2,523 width=189) (actual time=5.585..35.704 rows=2,520 loops=1)

  • Hash Cond: (planificacion.id_estado = estado_planificacion.id_estado)
11. 6.498 29.367 ↑ 1.0 2,520 1

Hash Join (cost=165.27..572.70 rows=2,523 width=193) (actual time=5.542..29.367 rows=2,520 loops=1)

  • Hash Cond: (planificacion.id_especialiadad = especialidades.id_especialidades)
12. 10.523 18.047 ↑ 1.0 2,523 1

Hash Join (cost=102.66..475.38 rows=2,526 width=51) (actual time=0.684..18.047 rows=2,523 loops=1)

  • Hash Cond: (planificacion.id_modalidad = modalidad.id_modalidad)
13. 6.945 7.512 ↑ 1.0 2,533 1

Bitmap Heap Scan on planificacion (cost=101.61..439.55 rows=2,539 width=44) (actual time=0.637..7.512 rows=2,533 loops=1)

  • Recheck Cond: (id_subestado = 2)
  • Filter: ((id_tipo_insc = 1) AND ((id_estado = 2) OR (id_estado = 3)))
  • Rows Removed by Filter: 264
14. 0.567 0.567 ↓ 1.0 2,798 1

Bitmap Index Scan on planificacion_id_subestado_idx (cost=0.00..100.98 rows=2,797 width=0) (actual time=0.567..0.567 rows=2,798 loops=1)

  • Index Cond: (id_subestado = 2)
15. 0.003 0.012 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=15) (actual time=0.012..0.012 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
16. 0.009 0.009 ↑ 1.0 2 1

Seq Scan on modalidad (cost=0.00..1.02 rows=2 width=15) (actual time=0.006..0.009 rows=2 loops=1)

17. 1.312 4.822 ↓ 1.0 885 1

Hash (cost=51.58..51.58 rows=883 width=150) (actual time=4.822..4.822 rows=885 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 112kB
18. 2.053 3.510 ↓ 1.0 885 1

Hash Join (cost=4.61..51.58 rows=883 width=150) (actual time=0.393..3.510 rows=885 loops=1)

  • Hash Cond: (especialidades.id_area = areas.id_areas)
19. 1.103 1.103 ↓ 1.0 885 1

Seq Scan on especialidades (cost=0.00..34.83 rows=883 width=116) (actual time=0.010..1.103 rows=885 loops=1)

20. 0.085 0.354 ↑ 1.0 57 1

Hash (cost=3.89..3.89 rows=57 width=42) (actual time=0.354..0.354 rows=57 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
21. 0.148 0.269 ↑ 1.0 57 1

Hash Join (cost=1.54..3.89 rows=57 width=42) (actual time=0.095..0.269 rows=57 loops=1)

  • Hash Cond: (areas.id_familia_profesional = programas_formacion_familias.id_prog_formacion)
22. 0.057 0.057 ↑ 1.0 57 1

Seq Scan on areas (cost=0.00..1.57 rows=57 width=25) (actual time=0.005..0.057 rows=57 loops=1)

23. 0.034 0.064 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=29) (actual time=0.064..0.064 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
24. 0.030 0.030 ↑ 1.0 24 1

Seq Scan on programas_formacion_familias (cost=0.00..1.24 rows=24 width=29) (actual time=0.006..0.030 rows=24 loops=1)

25. 0.007 0.017 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=4) (actual time=0.017..0.017 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
26. 0.010 0.010 ↑ 1.0 4 1

Seq Scan on estado_planificacion (cost=0.00..1.04 rows=4 width=4) (actual time=0.006..0.010 rows=4 loops=1)

27. 0.113 0.216 ↑ 1.0 95 1

Hash (cost=2.95..2.95 rows=95 width=22) (actual time=0.216..0.216 rows=95 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
28. 0.103 0.103 ↑ 1.0 95 1

Seq Scan on unidad_operativa (cost=0.00..2.95 rows=95 width=22) (actual time=0.007..0.103 rows=95 loops=1)

29. 4.187 7.498 ↓ 1.0 3,019 1

Hash (cost=88.94..88.94 rows=2,994 width=95) (actual time=7.498..7.498 rows=3,019 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 382kB
30. 3.311 3.311 ↓ 1.0 3,019 1

Seq Scan on ubicacion (cost=0.00..88.94 rows=2,994 width=95) (actual time=0.006..3.311 rows=3,019 loops=1)

31. 2.314 4.395 ↑ 1.1 2,074 1

Hash (cost=36.24..36.24 rows=2,224 width=20) (actual time=4.395..4.395 rows=2,074 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 109kB
32. 2.081 2.081 ↑ 1.1 2,074 1

Seq Scan on barrio (cost=0.00..36.24 rows=2,224 width=20) (actual time=0.008..2.081 rows=2,074 loops=1)

33. 0.362 1.215 ↑ 1.0 254 1

Hash (cost=12.44..12.44 rows=254 width=51) (actual time=1.215..1.215 rows=254 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
34. 0.561 0.853 ↑ 1.0 254 1

Hash Left Join (cost=1.41..12.44 rows=254 width=51) (actual time=0.073..0.853 rows=254 loops=1)

  • Hash Cond: (city.distrito_id = distritos.id)
35. 0.247 0.247 ↑ 1.0 254 1

Seq Scan on city (cost=0.00..7.54 rows=254 width=48) (actual time=0.006..0.247 rows=254 loops=1)

36. 0.025 0.045 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=19) (actual time=0.045..0.045 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
37. 0.020 0.020 ↑ 1.0 18 1

Seq Scan on distritos (cost=0.00..1.18 rows=18 width=19) (actual time=0.005..0.020 rows=18 loops=1)