explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AzI1

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

Result (cost=36.99..45.46 rows=1 width=4,884) (actual time=0.046..0.046 rows=0 loops=1)

2. 0.041 0.045 ↓ 0.0 0 1

Sort (cost=36.99..37.00 rows=1 width=4,820) (actual time=0.045..0.045 rows=0 loops=1)

  • Sort Key: ntf.not_fecha_inicio DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.70..36.98 rows=1 width=4,820) (actual time=0.004..0.004 rows=0 loops=1)

4. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.56..29.15 rows=1 width=3,178) (actual time=0.004..0.004 rows=0 loops=1)

  • Join Filter: (ntf.caso_id = (ca.item_key)::numeric)
5. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.42..21.72 rows=1 width=1,204) (actual time=0.004..0.004 rows=0 loops=1)

6. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.28..21.22 rows=1 width=734) (actual time=0.004..0.004 rows=0 loops=1)

7. 0.003 0.003 ↓ 0.0 0 1

Index Scan using wfa_notificaciones_n2 on cwfa_notificacion ntf (cost=0.14..13.95 rows=1 width=458) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((not_estado)::text = 'OPEN'::text)
  • Filter: (SubPlan 2)
8.          

SubPlan (forIndex Scan)

9. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..13.58 rows=2 width=4) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on cwfa_roles_usuario wur (cost=0.00..12.55 rows=1 width=4) (never executed)

  • Filter: (((usr_codigo)::text = 'ARKADIOS'::text) AND ((rol_nombre)::text = (ntf.not_rol_receptor)::text))
11. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..1.01 rows=1 width=4) (never executed)

  • One-Time Filter: ('ARKADIOS'::text = (ntf.not_rol_receptor)::text)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on dual (cost=0.00..1.01 rows=1 width=4) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using wfa_actividades_wf_pk on cwfa_actividades_proceso pac (cost=0.14..7.16 rows=1 width=294) (never executed)

  • Index Cond: (actividad_id = ntf.actividad_id)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using wfa_actividades_v2_pk on cwfa_actividad act (cost=0.14..0.48 rows=1 width=804) (never executed)

  • Index Cond: (((act_nombre)::text = (pac.act_nombre)::text) AND ((item_type)::text = (pac.item_type)::text))
  • Filter: (act_version = act_ult_version)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using wfa_caso_ind_3 on casos ca (cost=0.14..7.41 rows=1 width=1,974) (never executed)

  • Index Cond: (caso_fecha_termino IS NULL)
  • Filter: (prcs_id = (nvl(NULL::character varying, prcs_id))::numeric)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using prcs_pk on procesos pr (cost=0.14..7.16 rows=1 width=1,050) (never executed)

  • Index Cond: (prcs_id = ca.prcs_id)
17.          

SubPlan (forResult)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using fed_index_n1 on fel_documento (cost=0.14..7.17 rows=1 width=32) (never executed)

  • Index Cond: (doc_numero_caso = to_number((ca.item_key)::text))
  • Filter: ((doc_numero_oficio IS NOT NULL) AND (doc_version = doc_ultima_version))