explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UcIU

Settings
# exclusive inclusive rows x rows loops node
1. 250.178 2,728.527 ↓ 1.0 126,364 1

Hash Left Join (cost=19,424.58..32,094.26 rows=125,762 width=163) (actual time=1,507.615..2,728.527 rows=126,364 loops=1)

  • Hash Cond: (inscripcion_alumno.estado_inscripcion = estado_inscripcion.id)
2. 287.540 2,478.337 ↓ 1.0 126,364 1

Hash Join (cost=19,423.49..30,049.54 rows=125,762 width=152) (actual time=1,507.581..2,478.337 rows=126,364 loops=1)

  • Hash Cond: (usuario.id_person = persons.id)
3. 268.589 1,928.516 ↓ 1.0 126,364 1

Hash Left Join (cost=15,562.80..23,673.60 rows=125,762 width=123) (actual time=1,245.274..1,928.516 rows=126,364 loops=1)

  • Hash Cond: (inscripcion_alumno.id_planificacion = planificacion.id_planificacion)
4. 295.309 1,614.911 ↓ 1.0 126,364 1

Hash Join (cost=14,985.85..19,952.61 rows=125,762 width=80) (actual time=1,200.234..1,614.911 rows=126,364 loops=1)

  • Hash Cond: (inscripcion_alumno.id_alumno = alumno.id_alumno)
5. 119.479 119.479 ↓ 1.0 126,364 1

Seq Scan on inscripcion_alumno (cost=0.00..2,447.57 rows=126,157 width=36) (actual time=0.003..119.479 rows=126,364 loops=1)

6. 132.252 1,200.123 ↓ 1.0 96,898 1

Hash (cost=13,779.06..13,779.06 rows=96,543 width=52) (actual time=1,200.123..1,200.123 rows=96,898 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 8390kB
7. 257.910 1,067.871 ↓ 1.0 96,898 1

Hash Join (cost=7,727.83..13,779.06 rows=96,543 width=52) (actual time=443.463..1,067.871 rows=96,898 loops=1)

  • Hash Cond: (usuario.id_person = persons_docs.person_id)
8. 266.423 598.880 ↓ 1.0 96,898 1

Hash Join (cost=4,410.07..8,530.43 rows=96,544 width=37) (actual time=232.297..598.880 rows=96,898 loops=1)

  • Hash Cond: (alumno.id_usuario = usuario.id)
9. 100.302 100.302 ↓ 1.0 96,898 1

Seq Scan on alumno (cost=0.00..2,186.46 rows=96,846 width=12) (actual time=0.007..100.302 rows=96,898 loops=1)

10. 118.226 232.155 ↓ 1.0 96,899 1

Hash (cost=3,203.92..3,203.92 rows=96,492 width=33) (actual time=232.155..232.155 rows=96,899 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 6314kB
11. 113.929 113.929 ↓ 1.0 96,899 1

Seq Scan on usuario (cost=0.00..3,203.92 rows=96,492 width=33) (actual time=0.010..113.929 rows=96,899 loops=1)

12. 105.935 211.081 ↓ 1.0 99,325 1

Hash (cost=2,077.39..2,077.39 rows=99,230 width=15) (actual time=211.081..211.081 rows=99,325 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 4663kB
13. 105.146 105.146 ↓ 1.0 99,325 1

Seq Scan on persons_docs (cost=0.00..2,077.39 rows=99,230 width=15) (actual time=0.009..105.146 rows=99,325 loops=1)

  • Filter: ((valor)::text <> ''::text)
14. 10.942 45.016 ↓ 1.0 9,955 1

Hash (cost=452.54..452.54 rows=9,952 width=47) (actual time=45.016..45.016 rows=9,955 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 716kB
15. 19.298 34.074 ↓ 1.0 9,955 1

Hash Left Join (cost=64.53..452.54 rows=9,952 width=47) (actual time=1.983..34.074 rows=9,955 loops=1)

  • Hash Cond: (planificacion.id_especialiadad = especialidades.id_especialidades)
16. 12.826 12.826 ↓ 1.0 9,955 1

Index Only Scan using planificacion_id_planificacion_id_estado_id_especialiadad_i_idx on planificacion (cost=0.29..251.56 rows=9,952 width=12) (actual time=0.017..12.826 rows=9,955 loops=1)

  • Heap Fetches: 7883
17. 0.972 1.950 ↓ 1.0 908 1

Hash (cost=53.00..53.00 rows=900 width=43) (actual time=1.950..1.950 rows=908 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 70kB
18. 0.978 0.978 ↓ 1.0 908 1

Seq Scan on especialidades (cost=0.00..53.00 rows=900 width=43) (actual time=0.004..0.978 rows=908 loops=1)

19. 132.316 262.281 ↑ 1.0 99,325 1

Hash (cost=2,618.64..2,618.64 rows=99,364 width=45) (actual time=262.281..262.281 rows=99,325 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 7428kB
20. 129.965 129.965 ↑ 1.0 99,325 1

Seq Scan on persons (cost=0.00..2,618.64 rows=99,364 width=45) (actual time=0.004..129.965 rows=99,325 loops=1)

21. 0.004 0.012 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
22. 0.008 0.008 ↑ 1.0 4 1

Seq Scan on estado_inscripcion (cost=0.00..1.04 rows=4 width=15) (actual time=0.004..0.008 rows=4 loops=1)

Total runtime : 2,841.576 ms