explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ewV6

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.056 ↑ 1.0 1 1

Nested Loop (cost=2.11..7.81 rows=1 width=33) (actual time=0.054..0.056 rows=1 loops=1)

2. 0.000 0.047 ↑ 1.0 1 1

Nested Loop (cost=1.82..7.49 rows=1 width=33) (actual time=0.045..0.047 rows=1 loops=1)

3. 0.000 0.042 ↑ 1.0 1 1

Nested Loop (cost=1.54..7.18 rows=1 width=33) (actual time=0.041..0.042 rows=1 loops=1)

4. 0.004 0.039 ↑ 1.0 1 1

Nested Loop (cost=1.41..7.02 rows=1 width=37) (actual time=0.038..0.039 rows=1 loops=1)

5. 0.001 0.034 ↑ 1.0 1 1

Nested Loop (cost=1.13..6.71 rows=1 width=33) (actual time=0.033..0.034 rows=1 loops=1)

6. 0.004 0.023 ↑ 1.0 1 1

Nested Loop (cost=0.70..4.05 rows=1 width=16) (actual time=0.023..0.023 rows=1 loops=1)

7. 0.007 0.007 ↑ 1.0 1 1

Index Scan using iu_unc_x_sga_alumnos_alumno_legajo on sga_alumnos a (cost=0.42..2.64 rows=1 width=12) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (alumno = 586297)
8. 0.012 0.012 ↑ 1.0 1 1

Index Only Scan using iu_sga_planes_versiones_plan_version_plan on sga_planes_versiones plan_actual (cost=0.28..1.40 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (plan_version = a.plan_version)
  • Heap Fetches: 1
9. 0.010 0.010 ↑ 1.0 1 1

Index Scan using iu_propuesta_aspira_persona_perinsc_prop on sga_propuestas_aspira pa (cost=0.42..2.65 rows=1 width=25) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: ((persona = a.persona) AND (propuesta = a.propuesta))
10. 0.001 0.001 ↑ 1.0 1 1

Index Only Scan using iu_sga_planes_versiones_plan_version_plan on sga_planes_versiones plan_insc (cost=0.28..0.30 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (plan_version = pa.plan_version)
  • Heap Fetches: 1
11. 0.003 0.003 ↑ 1.0 1 1

Index Scan using pk_sga_situacion_aspirante on sga_situacion_aspirante sa (cost=0.13..0.15 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (situacion_asp = pa.situacion_asp)
  • Filter: (resultado_asp = ANY ('{P,A}'::bpchar[]))
12. 0.005 0.005 ↑ 1.0 1 1

Index Scan using pk_sga_periodos_inscripcion_fechas on sga_periodos_inscripcion_fechas pif (cost=0.29..0.30 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (periodo_insc = pa.periodo_insc)
13. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using pk_sga_periodos_inscripcion on sga_periodos_inscripcion pi (cost=0.29..0.31 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (periodo_inscripcion = pif.periodo_inscripcion)
  • Heap Fetches: 0
Planning time : 2.692 ms
Execution time : 0.200 ms