explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7RpR

Settings
# exclusive inclusive rows x rows loops node
1. 42.165 567.495 ↑ 1.0 2,521 1

Hash Left Join (cost=911.23..170,925.12 rows=2,524 width=377) (actual time=99.590..567.495 rows=2,521 loops=1)

  • Hash Cond: (barrio.cod_city = city.id)
2. 6.765 168.778 ↑ 1.0 2,521 1

Hash Left Join (cost=895.62..1,227.68 rows=2,524 width=334) (actual time=98.262..168.778 rows=2,521 loops=1)

  • Hash Cond: (ubicacion.id_barrio = barrio.id_barrio)
3. 21.292 157.935 ↑ 1.0 2,521 1

Hash Left Join (cost=831.58..1,125.78 rows=2,524 width=320) (actual time=94.149..157.935 rows=2,521 loops=1)

  • Hash Cond: (planificacion.id_ubicacion = ubicacion.id_ubicacion)
4. 29.600 129.059 ↑ 1.0 2,521 1

Hash Join (cost=705.22..975.15 rows=2,524 width=233) (actual time=86.530..129.059 rows=2,521 loops=1)

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

Seq Scan on periodo (cost=0.00..195.13 rows=9,913 width=36) (actual time=0.006..13.027 rows=9,913 loops=1)

6. 9.074 86.432 ↑ 1.0 2,521 1

Hash (cost=673.67..673.67 rows=2,524 width=201) (actual time=86.432..86.432 rows=2,521 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 440kB
7. 14.480 77.358 ↑ 1.0 2,521 1

Hash Join (cost=170.51..673.67 rows=2,524 width=201) (actual time=9.151..77.358 rows=2,521 loops=1)

  • Hash Cond: (planificacion.id_unidad_operativa = unidad_operativa.id_unidad_operativa)
8. 8.237 62.687 ↑ 1.0 2,521 1

Nested Loop (cost=166.37..634.82 rows=2,524 width=185) (actual time=8.942..62.687 rows=2,521 loops=1)

9. 0.008 0.008 ↑ 1.0 1 1

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

  • Filter: (id_subestado = 2)
  • Rows Removed by Filter: 2
10. 11.748 54.442 ↑ 1.0 2,521 1

Hash Join (cost=166.37..608.55 rows=2,524 width=189) (actual time=8.928..54.442 rows=2,521 loops=1)

  • Hash Cond: (planificacion.id_estado = estado_planificacion.id_estado)
11. 11.156 42.681 ↑ 1.0 2,521 1

Hash Join (cost=165.28..572.75 rows=2,524 width=193) (actual time=8.901..42.681 rows=2,521 loops=1)

  • Hash Cond: (planificacion.id_especialiadad = especialidades.id_especialidades)
12. 12.036 24.252 ↑ 1.0 2,524 1

Hash Join (cost=102.67..475.42 rows=2,527 width=51) (actual time=1.611..24.252 rows=2,524 loops=1)

  • Hash Cond: (planificacion.id_modalidad = modalidad.id_modalidad)
13. 10.703 12.204 ↑ 1.0 2,534 1

Bitmap Heap Scan on planificacion (cost=101.62..439.58 rows=2,540 width=44) (actual time=1.569..12.204 rows=2,534 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. 1.501 1.501 ↑ 1.0 2,798 1

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

  • Index Cond: (id_subestado = 2)
15. 0.005 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.007 0.007 ↑ 1.0 2 1

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

17. 1.625 7.273 ↓ 1.0 885 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 112kB
18. 2.543 5.648 ↓ 1.0 885 1

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

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

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

20. 0.065 0.271 ↑ 1.0 57 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
21. 0.116 0.206 ↑ 1.0 57 1

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

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

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

23. 0.025 0.047 ↑ 1.0 24 1

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

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

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

25. 0.007 0.013 ↑ 1.0 4 1

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

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

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

27. 0.098 0.191 ↑ 1.0 95 1

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

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

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

29. 4.339 7.584 ↓ 1.0 3,026 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 383kB
30. 3.245 3.245 ↓ 1.0 3,026 1

Seq Scan on ubicacion (cost=0.00..88.94 rows=2,994 width=95) (actual time=0.007..3.245 rows=3,026 loops=1)

31. 2.191 4.078 ↑ 1.1 2,080 1

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

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

Seq Scan on barrio (cost=0.00..36.24 rows=2,224 width=20) (actual time=0.009..1.887 rows=2,080 loops=1)

33. 0.312 1.091 ↑ 1.0 254 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
34. 0.514 0.779 ↑ 1.0 254 1

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

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

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

36. 0.023 0.044 ↑ 1.0 18 1

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

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

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

38.          

SubPlan (forHash Left Join)

39. 68.067 355.461 ↑ 1.0 1 2,521

Aggregate (cost=67.19..67.20 rows=1 width=8) (actual time=0.140..0.141 rows=1 loops=2,521)

40. 226.890 287.394 ↑ 1.6 16 2,521

Bitmap Heap Scan on inscripcion_alumno insxx (cost=2.28..67.13 rows=25 width=8) (actual time=0.044..0.114 rows=16 loops=2,521)

  • Recheck Cond: (id_planificacion = planificacion.id_planificacion)
  • Filter: (estado_inscripcion = 1)
  • Rows Removed by Filter: 8
41. 60.504 60.504 ↑ 1.5 24 2,521

Bitmap Index Scan on inscripcion_alumno_id_planificacion_idx (cost=0.00..2.27 rows=36 width=0) (actual time=0.024..0.024 rows=24 loops=2,521)

  • Index Cond: (id_planificacion = planificacion.id_planificacion)