explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8c4u

Settings
# exclusive inclusive rows x rows loops node
1. 37.894 9,405.951 ↓ 1.0 2,570 1

Bitmap Heap Scan on planificacion (cost=39.91..3,567,388.99 rows=2,544 width=4) (actual time=4.508..9,405.951 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.407 0.407 ↑ 1.0 2,799 1

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

  • Index Cond: (id_subestado = 2)
3.          

SubPlan (forBitmap Heap Scan)

4. 61.680 9,367.650 ↑ 1.0 1 2,570

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

5. 9,305.970 9,305.970 ↑ 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=1.496..3.621 rows=16 loops=2,570)

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