explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OFg9 : Optimization for: plan #yk8j

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.028 ↓ 0.0 0 1

Group (cost=22.50..22.61 rows=1 width=1,140) (actual time=0.028..0.028 rows=0 loops=1)

  • Group 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, 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. 0.019 0.027 ↓ 0.0 0 1

Sort (cost=22.50..22.51 rows=1 width=1,140) (actual time=0.027..0.027 rows=0 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, 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
  • Sort Method: quicksort Memory: 17kB
3. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=4.95..22.49 rows=1 width=1,140) (actual time=0.008..0.008 rows=0 loops=1)

  • Join Filter: ((exe.ficursoid = evl.ficursoid) AND (exe.fievaluacionid = evl.fievaluacionid))
4. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=4.80..21.88 rows=1 width=779) (actual time=0.008..0.008 rows=0 loops=1)

5. 0.007 0.007 ↓ 0.0 0 1

Index Scan using evaluacioempleado_idx02 on evaluacionempleado exe (cost=0.41..6.20 rows=1 width=113) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((ficlienteid = 7) AND (fiformatoid = 11))
  • Filter: ((ficertificacionid = ficertificacionid) AND (figrupoid = figrupoid) AND (ficursoid = fitipoevaluacion) AND (ficonsecutivo = 0) AND (btrim((fcempleadoid)::text) = '7-P1010023815'::text))
6. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on grupo gru (cost=4.39..15.67 rows=1 width=674) (never executed)

  • Recheck Cond: ((ficertificacionid = exe.ficertificacionid) AND (figrupoid = exe.figrupoid))
  • Filter: (CASE WHEN (exe.fitipoevaluacion = 2) THEN ficursoid ELSE exe.ficursoid END = ficursoid)
7. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on pk_grupo (cost=0.00..4.39 rows=4 width=0) (never executed)

  • Index Cond: ((ficertificacionid = exe.ficertificacionid) AND (figrupoid = exe.figrupoid))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using evaluacion_idx01 on evaluacion evl (cost=0.14..0.55 rows=1 width=381) (never executed)

  • Index Cond: (ficertificacionid = gru.ficertificacionid)
  • Filter: ((ficursoid = fitipoevaluacion) AND (fiestatusid = 1))
Planning time : 1.353 ms
Execution time : 0.190 ms