explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kQIy

Settings
# exclusive inclusive rows x rows loops node
1. 247.530 2,590.971 ↓ 1.0 126,393 1

Hash Left Join (cost=19,454.50..32,162.95 rows=126,262 width=163) (actual time=1,351.508..2,590.971 rows=126,393 loops=1)

  • Hash Cond: (inscripcion_alumno.estado_inscripcion = estado_inscripcion.id)
2. 274.937 2,343.429 ↓ 1.0 126,393 1

Hash Left Join (cost=19,453.41..30,110.10 rows=126,262 width=152) (actual time=1,351.473..2,343.429 rows=126,393 loops=1)

  • Hash Cond: (inscripcion_alumno.id_planificacion = planificacion.id_planificacion)
3. 301.741 2,021.998 ↓ 1.0 126,393 1

Hash Join (cost=18,876.47..26,376.61 rows=126,262 width=109) (actual time=1,304.946..2,021.998 rows=126,393 loops=1)

  • Hash Cond: (alumno.id_usuario = usuario.id)
4. 301.176 643.055 ↓ 1.0 126,393 1

Hash Join (cost=3,399.81..8,374.70 rows=126,263 width=40) (actual time=227.645..643.055 rows=126,393 loops=1)

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

Seq Scan on inscripcion_alumno (cost=0.00..2,449.63 rows=126,263 width=36) (actual time=0.027..114.576 rows=126,393 loops=1)

6. 118.698 227.303 ↑ 1.0 96,916 1

Hash (cost=2,188.25..2,188.25 rows=96,925 width=12) (actual time=227.303..227.303 rows=96,916 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 4165kB
7. 108.605 108.605 ↑ 1.0 96,916 1

Seq Scan on alumno (cost=0.00..2,188.25 rows=96,925 width=12) (actual time=0.012..108.605 rows=96,916 loops=1)

8. 115.442 1,077.202 ↓ 1.0 96,917 1

Hash (cost=14,265.30..14,265.30 rows=96,909 width=77) (actual time=1,077.202..1,077.202 rows=96,917 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 10201kB
9. 221.194 961.760 ↓ 1.0 96,917 1

Hash Join (cost=7,180.82..14,265.30 rows=96,909 width=77) (actual time=426.246..961.760 rows=96,917 loops=1)

  • Hash Cond: (usuario.id_person = persons.id)
10. 215.296 517.399 ↓ 1.0 96,917 1

Hash Join (cost=3,317.76..8,464.05 rows=96,909 width=48) (actual time=202.988..517.399 rows=96,917 loops=1)

  • Hash Cond: (usuario.id_person = persons_docs.person_id)
11. 99.216 99.216 ↓ 1.0 96,917 1

Seq Scan on usuario (cost=0.00..3,208.10 rows=96,910 width=33) (actual time=0.004..99.216 rows=96,917 loops=1)

12. 98.485 202.887 ↓ 1.0 99,343 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 4664kB
13. 104.402 104.402 ↓ 1.0 99,343 1

Seq Scan on persons_docs (cost=0.00..2,077.39 rows=99,230 width=15) (actual time=0.020..104.402 rows=99,343 loops=1)

  • Filter: ((valor)::text <> ''::text)
14. 106.594 223.167 ↑ 1.0 99,343 1

Hash (cost=2,620.25..2,620.25 rows=99,425 width=45) (actual time=223.167..223.167 rows=99,343 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 7429kB
15. 116.573 116.573 ↑ 1.0 99,343 1

Seq Scan on persons (cost=0.00..2,620.25 rows=99,425 width=45) (actual time=0.023..116.573 rows=99,343 loops=1)

16. 11.019 46.494 ↓ 1.0 9,955 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 716kB
17. 18.687 35.475 ↓ 1.0 9,955 1

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

  • Hash Cond: (planificacion.id_especialiadad = especialidades.id_especialidades)
18. 14.653 14.653 ↓ 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.036..14.653 rows=9,955 loops=1)

  • Heap Fetches: 7984
19. 1.080 2.135 ↓ 1.0 910 1

Hash (cost=53.00..53.00 rows=900 width=43) (actual time=2.135..2.135 rows=910 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 71kB
20. 1.055 1.055 ↓ 1.0 910 1

Seq Scan on especialidades (cost=0.00..53.00 rows=900 width=43) (actual time=0.008..1.055 rows=910 loops=1)

21. 0.006 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.006 0.006 ↑ 1.0 4 1

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