explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OJzF

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 231.266 2,379.311 ↓ 1.0 126,396 1

Hash Left Join (cost=19,454.50..32,162.95 rows=126,262 width=163) (actual time=1,261.325..2,379.311 rows=126,396 loops=1)

  • Hash Cond: (inscripcion_alumno.estado_inscripcion = estado_inscripcion.id)
2. 245.204 2,148.031 ↓ 1.0 126,396 1

Hash Left Join (cost=19,453.41..30,110.10 rows=126,262 width=152) (actual time=1,261.288..2,148.031 rows=126,396 loops=1)

  • Hash Cond: (inscripcion_alumno.id_planificacion = planificacion.id_planificacion)
3. 265.647 1,861.566 ↓ 1.0 126,396 1

Hash Join (cost=18,876.47..26,376.61 rows=126,262 width=109) (actual time=1,220.002..1,861.566 rows=126,396 loops=1)

  • Hash Cond: (alumno.id_usuario = usuario.id)
4. 268.104 557.099 ↓ 1.0 126,396 1

Hash Join (cost=3,399.81..8,374.70 rows=126,263 width=40) (actual time=181.084..557.099 rows=126,396 loops=1)

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

Seq Scan on inscripcion_alumno (cost=0.00..2,449.63 rows=126,263 width=36) (actual time=0.004..108.045 rows=126,396 loops=1)

6. 91.448 180.950 ↑ 1.0 96,917 1

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

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

Seq Scan on alumno (cost=0.00..2,188.25 rows=96,925 width=12) (actual time=0.005..89.502 rows=96,917 loops=1)

8. 111.240 1,038.820 ↓ 1.0 96,918 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 10201kB
9. 216.440 927.580 ↓ 1.0 96,918 1

Hash Join (cost=7,180.82..14,265.30 rows=96,909 width=77) (actual time=402.094..927.580 rows=96,918 loops=1)

  • Hash Cond: (usuario.id_person = persons.id)
10. 210.146 499.396 ↓ 1.0 96,918 1

Hash Join (cost=3,317.76..8,464.05 rows=96,909 width=48) (actual time=190.259..499.396 rows=96,918 loops=1)

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

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

12. 93.738 190.144 ↓ 1.0 99,344 1

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

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

Seq Scan on persons_docs (cost=0.00..2,077.39 rows=99,230 width=15) (actual time=0.018..96.406 rows=99,344 loops=1)

  • Filter: ((valor)::text <> ''::text)
14. 103.628 211.744 ↑ 1.0 99,344 1

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

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

Seq Scan on persons (cost=0.00..2,620.25 rows=99,425 width=45) (actual time=0.040..108.116 rows=99,344 loops=1)

16. 10.063 41.261 ↓ 1.0 9,955 1

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

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

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

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

  • Heap Fetches: 7984
19. 0.884 1.743 ↓ 1.0 910 1

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

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

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

21. 0.006 0.014 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=15) (actual time=0.014..0.014 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.003..0.008 rows=4 loops=1)