explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qsqz

Settings
# exclusive inclusive rows x rows loops node
1. 23.741 130.435 ↑ 1.1 9,352 1

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

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

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

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

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

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

  • Heap Fetches: 36
5. 1.037 1.913 ↓ 1.0 885 1

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

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

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

7. 20.882 38.257 ↑ 1.0 9,913 1

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

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

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

9. 0.099 0.203 ↑ 1.0 95 1

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

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

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