explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Xuj : Optimization for: Optimization for: Optimization for: Optimization for: plan #yk8j; plan #OFg9; plan #qxjL; plan #nQpu

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.208 35.495 ↓ 74.0 74 1

Group (cost=40.03..40.13 rows=1 width=1,142) (actual time=35.244..35.495 rows=74 loops=1)

  • exe.figrupoid, (btrim((exe.fcempleadoid)::text)), exe.fiestatusid, (CASE WHEN (exe.ficalificacion IS NULL) THEN '0'::text ELSE btrim((''::text || (exe.ficalificacion)::text)) END), evl.fiduracion, (to_char(exe.fdinicio, 'DD-MM-YYYY hh24:mi:ss'::text)), (to_char(gru.fdfin, 'DD-MM-YYYY hh24:mi:ss'::text)), evl.fitotalpreguntas, exe.ficonsecutivo, exe.firesetautomatico, exe.ficandado
2. 1.757 35.287 ↓ 110.0 110 1

Sort (cost=40.03..40.03 rows=1 width=1,142) (actual time=35.239..35.287 rows=110 loops=1)

  • Sort Key: exe.ficursoid, exe.fiintento, exe.fitipoevaluacion, exe.fievaluacionid, (btrim((evl.fcnombre)::text)), (btrim((evl.fcdescripcion)::text)), (btrim((gru.fcdescripcion)::text)), (((to_char(exe.fdinicio, 'dd/mm/yyyy'::text) || ' - '::text) || to_char(exe.fdfin, 'dd/mm/yyyy'::text))), exe.ficertificacionid, exe.ficlienteid, exe.fiformatoid,
  • Sort Method: quicksort Memory: 246kB
3. 7.448 33.530 ↓ 110.0 110 1

Nested Loop (cost=0.00..40.02 rows=1 width=1,142) (actual time=0.477..33.530 rows=110 loops=1)

  • Join Filter: (CASE WHEN (exe.fitipoevaluacion = 2) THEN gru.ficursoid ELSE exe.ficursoid END = gru.ficursoid)
4. 2.325 13.202 ↓ 1,840.0 1,840 1

Nested Loop (cost=0.00..28.34 rows=1 width=484) (actual time=0.311..13.202 rows=1,840 loops=1)

5. 0.125 0.125 ↓ 32.0 32 1

Seq Scan on evaluacion evl (cost=0.00..19.75 rows=1 width=381) (actual time=0.016..0.125 rows=32 loops=1)

  • Filter: ((ficursoid = fitipoevaluacion) AND (fiestatusid = 1))
6. 10.752 10.752 ↓ 58.0 58 32

Index Scan using pk_evaluacionempleado on evaluacionempleado exe (cost=0.00..8.57 rows=1 width=115) (actual time=0.071..0.336 rows=58 loops=32)

  • Index Cond: ((exe.ficertificacionid = evl.ficertificacionid) AND (exe.ficursoid = evl.ficursoid) AND (exe.fitipoevaluacion = evl.ficursoid) AND (exe.fievaluacionid = evl.fievaluacionid) AND (exe.ficlienteid = 5) AND (exe.fiformatoid = 16) AND (exe.ficonsecutivo = 0))
  • Filter: ((exe.ficertificacionid = exe.ficertificacionid) AND (exe.figrupoid = exe.figrupoid) AND (exe.ficursoid = exe.fitipoevaluacion) AND (btrim((exe.fcempleadoid)::text) = '5-EC004'::text))
7. 12.880 12.880 ↓ 0.0 0 1,840

Index Scan using pk_grupo on grupo gru (cost=0.00..11.62 rows=1 width=674) (actual time=0.007..0.007 rows=0 loops=1,840)

  • Index Cond: ((gru.ficertificacionid = exe.ficertificacionid) AND (gru.figrupoid = exe.figrupoid))
  • Filter: ((gru.fdinicio <= now()) AND (gru.fdfin >= now()))
Total runtime : 35.689 ms