explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wD2H

Settings
# exclusive inclusive rows x rows loops node
1. 16.466 114.699 ↑ 1.1 9,352 1

Hash Join (cost=369.33..1,139.92 rows=9,902 width=94) (actual time=41.835..114.699 rows=9,352 loops=1)

  • Hash Cond: (planificacion.id_unidad_operativa = unidad_operativa.id_unidad_operativa)
2. 26.121 98.032 ↑ 1.1 9,352 1

Hash Join (cost=365.19..999.63 rows=9,902 width=67) (actual time=41.620..98.032 rows=9,352 loops=1)

  • Hash Cond: (planificacion.id_planificacion = periodo.id_planificacion)
3. 20.566 32.237 ↑ 1.1 9,352 1

Hash Join (cost=46.15..433.04 rows=9,902 width=43) (actual time=1.908..32.237 rows=9,352 loops=1)

  • Hash Cond: (planificacion.id_especialiadad = especialidades.id_especialidades)
4. 9.860 9.860 ↑ 1.0 9,913 1

Index Only Scan using planificacion_id_planificacion_id_estado_id_especialiadad_i_idx on planificacion (cost=0.29..250.98 rows=9,913 width=12) (actual time=0.062..9.860 rows=9,913 loops=1)

  • Heap Fetches: 35
5. 0.938 1.811 ↓ 1.0 885 1

Hash (cost=34.83..34.83 rows=883 width=43) (actual time=1.811..1.811 rows=885 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 69kB
6. 0.873 0.873 ↓ 1.0 885 1

Seq Scan on especialidades (cost=0.00..34.83 rows=883 width=43) (actual time=0.009..0.873 rows=885 loops=1)

7. 30.012 39.674 ↑ 1.0 9,913 1

Hash (cost=195.13..195.13 rows=9,913 width=28) (actual time=39.674..39.674 rows=9,913 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 581kB
8. 9.662 9.662 ↑ 1.0 9,913 1

Seq Scan on periodo (cost=0.00..195.13 rows=9,913 width=28) (actual time=0.007..9.662 rows=9,913 loops=1)

9. 0.103 0.201 ↑ 1.0 95 1

Hash (cost=2.95..2.95 rows=95 width=29) (actual time=0.201..0.201 rows=95 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
10. 0.098 0.098 ↑ 1.0 95 1

Seq Scan on unidad_operativa (cost=0.00..2.95 rows=95 width=29) (actual time=0.006..0.098 rows=95 loops=1)