explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m0EB

Settings
# exclusive inclusive rows x rows loops node
1. 154.420 1,022.931 ↓ 43.7 908,673 1

Gather (cost=1,967.18..73,318.42 rows=20,770 width=106) (actual time=8.232..1,022.931 rows=908,673 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 50.060 868.511 ↓ 33.9 227,168 4

Hash Join (cost=967.18..70,241.42 rows=6,700 width=106) (actual time=7.293..868.511 rows=227,168 loops=4)

  • Hash Cond: (a.propuesta = p.propuesta)
3. 51.985 818.360 ↓ 33.9 227,168 4

Hash Join (cost=955.62..70,137.73 rows=6,700 width=46) (actual time=7.151..818.360 rows=227,168 loops=4)

  • Hash Cond: (pif.periodo_inscripcion = pi.periodo_inscripcion)
4. 49.308 762.756 ↓ 33.9 227,168 4

Hash Join (cost=496.30..69,586.28 rows=6,700 width=25) (actual time=3.456..762.756 rows=227,168 loops=4)

  • Hash Cond: (pa.periodo_insc = pif.periodo_insc)
5. 606.953 710.104 ↓ 33.9 227,168 4

Nested Loop (cost=1.54..68,999.40 rows=6,700 width=25) (actual time=0.038..710.104 rows=227,168 loops=4)

6. 77.179 103.149 ↓ 2.4 227,171 4

Hash Join (cost=1.11..23,998.36 rows=95,781 width=17) (actual time=0.028..103.149 rows=227,171 loops=4)

  • Hash Cond: (pa.situacion_asp = sa.situacion_asp)
7. 25.959 25.959 ↑ 1.3 259,805 4

Parallel Seq Scan on sga_propuestas_aspira pa (cost=0.00..21,782.32 rows=335,232 width=21) (actual time=0.004..25.959 rows=259,805 loops=4)

8. 0.002 0.011 ↑ 1.0 2 4

Hash (cost=1.09..1.09 rows=2 width=4) (actual time=0.011..0.011 rows=2 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.009 0.009 ↑ 1.0 2 4

Seq Scan on sga_situacion_aspirante sa (cost=0.00..1.09 rows=2 width=4) (actual time=0.008..0.009 rows=2 loops=4)

  • Filter: (resultado_asp = ANY ('{P,A}'::bpchar[]))
  • Rows Removed by Filter: 5
10. 0.002 0.002 ↑ 1.0 1 908,685

Index Scan using iu_sga_alumnos_persona_propuesta on sga_alumnos a (cost=0.42..0.46 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=908,685)

  • Index Cond: ((persona = pa.persona) AND (propuesta = pa.propuesta))
11. 1.754 3.344 ↑ 1.0 14,646 4

Hash (cost=311.56..311.56 rows=14,656 width=8) (actual time=3.344..3.344 rows=14,646 loops=4)

  • Buckets: 16384 Batches: 1 Memory Usage: 701kB
12. 1.590 1.590 ↑ 1.0 14,646 4

Seq Scan on sga_periodos_inscripcion_fechas pif (cost=0.00..311.56 rows=14,656 width=8) (actual time=0.004..1.590 rows=14,646 loops=4)

13. 2.083 3.619 ↑ 1.0 14,616 4

Hash (cost=274.70..274.70 rows=14,770 width=25) (actual time=3.619..3.619 rows=14,616 loops=4)

  • Buckets: 16384 Batches: 1 Memory Usage: 958kB
14. 1.536 1.536 ↑ 1.0 14,616 4

Seq Scan on sga_periodos_inscripcion pi (cost=0.00..274.70 rows=14,770 width=25) (actual time=0.004..1.536 rows=14,616 loops=4)

15. 0.040 0.091 ↓ 1.0 336 4

Hash (cost=7.37..7.37 rows=335 width=4) (actual time=0.091..0.091 rows=336 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
16. 0.051 0.051 ↓ 1.0 336 4

Index Only Scan using i_unc_sga_propuestas_propuesta on sga_propuestas p (cost=0.15..7.37 rows=335 width=4) (actual time=0.011..0.051 rows=336 loops=4)

  • Heap Fetches: 147
Planning time : 2.537 ms
Execution time : 1,051.068 ms