explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wo71

Settings
# exclusive inclusive rows x rows loops node
1. 127.756 16,645.660 ↓ 1.0 2,570 1

Bitmap Heap Scan on planificacion (cost=101.63..3,567,450.70 rows=2,544 width=4) (actual time=4.012..16,645.660 rows=2,570 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.514 0.514 ↑ 1.0 2,799 1

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

  • Index Cond: (id_subestado = 2)
3.          

SubPlan (forBitmap Heap Scan)

4. 115.650 16,517.390 ↑ 1.0 1 2,570

Aggregate (cost=1,402.12..1,402.13 rows=1 width=8) (actual time=6.426..6.427 rows=1 loops=2,570)

5. 16,401.740 16,401.740 ↑ 1.6 16 2,570

Index Scan using inscripcion_alumno_id_alumno_id_planificacion_idx on inscripcion_alumno insxx (cost=0.42..1,402.05 rows=25 width=8) (actual time=2.609..6.382 rows=16 loops=2,570)

  • Index Cond: (id_planificacion = planificacion.id_planificacion)
  • Filter: (estado_inscripcion = 1)
  • Rows Removed by Filter: 8