explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kZYF

Settings
# exclusive inclusive rows x rows loops node
1. 48.373 11,166.778 ↓ 1.0 2,570 1

Bitmap Heap Scan on planificacion (cost=101.63..3,567,450.70 rows=2,544 width=4) (actual time=3.963..11,166.778 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.585 0.585 ↑ 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.585..0.585 rows=2,799 loops=1)

  • Index Cond: (id_subestado = 2)
3.          

SubPlan (forBitmap Heap Scan)

4. 66.820 11,117.820 ↑ 1.0 1 2,570

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

5. 11,051.000 11,051.000 ↑ 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.806..4.300 rows=16 loops=2,570)

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