explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HDcD

Settings
# exclusive inclusive rows x rows loops node
1. 14.434 392.572 ↓ 1.0 2,569 1

Bitmap Heap Scan on planificacion (cost=101.61..171,259.27 rows=2,542 width=4) (actual time=0.611..392.572 rows=2,569 loops=1)

  • Recheck Cond: (id_subestado = 2)
  • Filter: (((id_tipo_insc = 1) AND (id_estado = 2)) OR (id_estado = 3))
  • Rows Removed by Filter: 229
2. 0.495 0.495 ↓ 1.0 2,799 1

Bitmap Index Scan on planificacion_id_subestado_idx (cost=0.00..100.98 rows=2,797 width=0) (actual time=0.495..0.495 rows=2,799 loops=1)

  • Index Cond: (id_subestado = 2)
3.          

SubPlan (forBitmap Heap Scan)

4. 56.518 377.643 ↑ 1.0 1 2,569

Aggregate (cost=67.19..67.20 rows=1 width=8) (actual time=0.146..0.147 rows=1 loops=2,569)

5. 254.331 321.125 ↑ 1.6 16 2,569

Bitmap Heap Scan on inscripcion_alumno insxx (cost=2.28..67.13 rows=25 width=8) (actual time=0.045..0.125 rows=16 loops=2,569)

  • Recheck Cond: (id_planificacion = planificacion.id_planificacion)
  • Filter: (estado_inscripcion = 1)
  • Rows Removed by Filter: 8
6. 66.794 66.794 ↑ 1.5 24 2,569

Bitmap Index Scan on inscripcion_alumno_id_planificacion_idx (cost=0.00..2.27 rows=36 width=0) (actual time=0.026..0.026 rows=24 loops=2,569)

  • Index Cond: (id_planificacion = planificacion.id_planificacion)