explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bUggl

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 17.667 101.630 ↑ 1.1 9,352 1

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

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

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

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

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

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

  • Heap Fetches: 441
5. 0.958 1.835 ↓ 1.0 885 1

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

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

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

7. 11.205 21.732 ↑ 1.0 9,913 1

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

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

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

9. 0.118 0.256 ↑ 1.0 95 1

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

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

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