explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QJQd

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Group (cost=3,116.52..3,116.53 rows=2 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=3,116.52..3,116.52 rows=2 width=8) (actual rows= loops=)

  • Sort Key: instructor_asignado.id_instructor, planificacion.id_planificacion
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..3,116.51 rows=2 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..3,053.43 rows=2 width=12) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..2,904.25 rows=2 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on agenda_uno (cost=0.00..2,895.62 rows=2 width=4) (actual rows= loops=)

  • Filter: ((date_part('month'::text, (fecha)::timestamp without time zone) = 5::double precision) AND (date_part('year'::text, (fecha)::timestamp without time zone) = 2019::double precision))
7. 0.000 0.000 ↓ 0.0

Index Only Scan using planificacion_id_planificacion_id_ubicacion_id_especialiada_idx on planificacion (cost=0.29..4.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id_planificacion = agenda_uno.id_planificacion)
8. 0.000 0.000 ↓ 0.0

Index Only Scan using periodo_id_periodo_id_planificacion_idx on periodo (cost=0.29..74.58 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id_planificacion = planificacion.id_planificacion)
9. 0.000 0.000 ↓ 0.0

Index Only Scan using instructor_asignado_id_instructor_id_planificacion_idx on instructor_asignado (cost=0.28..31.53 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id_planificacion = planificacion.id_planificacion)