explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2I0T : Optimization for: Optimization for: plan #bUggl; plan #HBJx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 18.299 129.226 ↑ 1.1 9,352 1

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

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

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

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

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

  • Hash Cond: (planificacion.id_especialiadad = especialidades.id_especialidades)
4. 10.510 10.510 ↑ 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.022..10.510 rows=9,913 loops=1)

  • Heap Fetches: 0
5. 3.003 3.886 ↓ 1.0 885 1

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

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

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

7. 19.088 37.918 ↑ 1.0 9,913 1

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

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

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

9. 0.100 0.202 ↑ 1.0 95 1

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

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

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