explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xRyv

Settings
# exclusive inclusive rows x rows loops node
1. 145.547 1,040.966 ↓ 43.8 908,673 1

Gather (cost=1,967.18..73,310.39 rows=20,767 width=106) (actual time=8.865..1,040.966 rows=908,673 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 51.828 895.419 ↓ 33.9 227,168 4

Hash Join (cost=967.18..70,233.69 rows=6,699 width=106) (actual time=8.326..895.419 rows=227,168 loops=4)

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

Hash Join (cost=955.62..70,130.02 rows=6,699 width=46) (actual time=8.154..843.478 rows=227,168 loops=4)

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

Hash Join (cost=496.30..69,578.59 rows=6,699 width=25) (actual time=3.995..785.149 rows=227,168 loops=4)

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

Nested Loop (cost=1.54..68,991.72 rows=6,699 width=25) (actual time=0.043..730.905 rows=227,168 loops=4)

6. 79.511 106.157 ↓ 2.4 227,171 4

Hash Join (cost=1.11..23,997.51 rows=95,766 width=17) (actual time=0.032..106.157 rows=227,171 loops=4)

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

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

8. 0.003 0.014 ↑ 1.0 2 4

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

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

Seq Scan on sga_situacion_aspirante sa (cost=0.00..1.09 rows=2 width=4) (actual time=0.009..0.011 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. 2.030 3.861 ↑ 1.0 14,646 4

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

  • Buckets: 16384 Batches: 1 Memory Usage: 701kB
12. 1.831 1.831 ↑ 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.005..1.831 rows=14,646 loops=4)

13. 2.321 4.066 ↑ 1.0 14,616 4

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

  • Buckets: 16384 Batches: 1 Memory Usage: 958kB
14. 1.745 1.745 ↑ 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.006..1.745 rows=14,616 loops=4)

15. 0.053 0.113 ↓ 1.0 336 4

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

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
16. 0.060 0.060 ↓ 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.013..0.060 rows=336 loops=4)

  • Heap Fetches: 147
Planning time : 2.730 ms
Execution time : 1,069.887 ms