explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c2lY

Settings
# exclusive inclusive rows x rows loops node
1. 227.482 2,404.186 ↓ 1.0 126,385 1

Hash Left Join (cost=19,454.50..32,162.95 rows=126,262 width=163) (actual time=1,290.024..2,404.186 rows=126,385 loops=1)

  • Hash Cond: (inscripcion_alumno.estado_inscripcion = estado_inscripcion.id)
2. 245.985 2,176.684 ↓ 1.0 126,385 1

Hash Left Join (cost=19,453.41..30,110.10 rows=126,262 width=152) (actual time=1,289.979..2,176.684 rows=126,385 loops=1)

  • Hash Cond: (inscripcion_alumno.id_planificacion = planificacion.id_planificacion)
3. 265.762 1,884.391 ↓ 1.0 126,385 1

Hash Join (cost=18,876.47..26,376.61 rows=126,262 width=109) (actual time=1,243.646..1,884.391 rows=126,385 loops=1)

  • Hash Cond: (alumno.id_usuario = usuario.id)
4. 270.174 556.745 ↓ 1.0 126,385 1

Hash Join (cost=3,399.81..8,374.70 rows=126,263 width=40) (actual time=181.661..556.745 rows=126,385 loops=1)

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

Seq Scan on inscripcion_alumno (cost=0.00..2,449.63 rows=126,263 width=36) (actual time=0.005..105.036 rows=126,385 loops=1)

6. 92.216 181.535 ↑ 1.0 96,912 1

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

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

Seq Scan on alumno (cost=0.00..2,188.25 rows=96,925 width=12) (actual time=0.006..89.319 rows=96,912 loops=1)

8. 120.215 1,061.884 ↓ 1.0 96,913 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 10200kB
9. 227.272 941.669 ↓ 1.0 96,913 1

Hash Join (cost=7,180.82..14,265.30 rows=96,909 width=77) (actual time=391.812..941.669 rows=96,913 loops=1)

  • Hash Cond: (usuario.id_person = persons.id)
10. 221.946 516.818 ↓ 1.0 96,913 1

Hash Join (cost=3,317.76..8,464.05 rows=96,909 width=48) (actual time=194.139..516.818 rows=96,913 loops=1)

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

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

12. 97.542 194.033 ↓ 1.0 99,339 1

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

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

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

  • Filter: ((valor)::text <> ''::text)
14. 100.737 197.579 ↑ 1.0 99,339 1

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

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

Seq Scan on persons (cost=0.00..2,620.25 rows=99,425 width=45) (actual time=0.004..96.842 rows=99,339 loops=1)

16. 11.151 46.308 ↓ 1.0 9,955 1

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

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

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

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

  • Heap Fetches: 7984
19. 0.900 1.773 ↓ 1.0 909 1

Hash (cost=53.00..53.00 rows=900 width=43) (actual time=1.773..1.773 rows=909 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 71kB
20. 0.873 0.873 ↓ 1.0 909 1

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

21. 0.010 0.020 ↑ 1.0 4 1

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

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

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