explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SP1U

Settings
# exclusive inclusive rows x rows loops node
1. 54.148 10,657.937 ↓ 1.0 2,568 1

Bitmap Heap Scan on planificacion (cost=101.61..3,564,646.39 rows=2,542 width=4) (actual time=3.907..10,657.937 rows=2,568 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.517 0.517 ↑ 1.0 2,797 1

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

  • Index Cond: (id_subestado = 2)
3.          

SubPlan (forBitmap Heap Scan)

4. 87.312 10,603.272 ↑ 1.0 1 2,568

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

5. 10,515.960 10,515.960 ↑ 1.6 16 2,568

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.689..4.095 rows=16 loops=2,568)

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