explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xTu

Settings
# exclusive inclusive rows x rows loops node
1. 103.248 344.239 ↑ 2.0 1 1

Result (cost=1.41..19,828.48 rows=2 width=1,240) (actual time=103.313..344.239 rows=1 loops=1)

2. 0.002 240.991 ↑ 2.0 1 1

Append (cost=1.41..19,827.42 rows=2 width=1,196) (actual time=0.065..240.991 rows=1 loops=1)

3. 0.004 0.069 ↑ 1.0 1 1

Nested Loop (cost=1.41..22.62 rows=1 width=1,196) (actual time=0.065..0.069 rows=1 loops=1)

4. 0.002 0.057 ↑ 1.0 1 1

Nested Loop (cost=0.99..15.16 rows=1 width=111) (actual time=0.053..0.057 rows=1 loops=1)

5. 0.003 0.040 ↑ 1.0 1 1

Nested Loop (cost=0.71..14.76 rows=1 width=82) (actual time=0.039..0.040 rows=1 loops=1)

6. 0.022 0.022 ↑ 1.0 1 1

Index Scan using wfa_notificaciones_pk on cwfa_notificacion ntf (cost=0.43..7.45 rows=1 width=55) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: (not_id = '5001526'::numeric)
  • Filter: ((not_estado)::text = 'OPEN'::text)
7. 0.015 0.015 ↑ 1.0 1 1

Index Scan using wfa_actividades_wf_pk on cwfa_actividades_proceso pac (cost=0.28..7.29 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (actividad_id = ntf.actividad_id)
8. 0.015 0.015 ↑ 1.0 1 1

Index Scan using wfa_actividades_v2_pk on cwfa_actividad act (cost=0.28..0.40 rows=1 width=58) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: (((act_nombre)::text = (pac.act_nombre)::text) AND ((item_type)::text = (pac.item_type)::text))
  • Filter: (act_version = act_ult_version)
  • Rows Removed by Filter: 1
9. 0.008 0.008 ↑ 1.0 1 1

Index Scan using caso_pk on casos ca (cost=0.42..7.44 rows=1 width=988) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (caso_id = ntf.caso_id)
  • Filter: (caso_fecha_termino IS NULL)
10. 0.001 240.920 ↓ 0.0 0 1

Nested Loop (cost=0.85..19,804.78 rows=1 width=1,196) (actual time=240.920..240.920 rows=0 loops=1)

11. 0.050 0.576 ↑ 1.0 1 1

Nested Loop (cost=0.43..92.67 rows=1 width=105) (actual time=0.420..0.576 rows=1 loops=1)

  • Join Filter: (((pac_1.item_type)::text = (act_1.item_type)::text) AND ((pac_1.act_nombre)::text = (act_1.act_nombre)::text))
  • Rows Removed by Join Filter: 514
12. 0.124 0.207 ↑ 1.0 1 1

Nested Loop (cost=0.43..53.11 rows=1 width=76) (actual time=0.205..0.207 rows=1 loops=1)

  • Join Filter: (ntf_1.actividad_id = pac_1.actividad_id)
  • Rows Removed by Join Filter: 635
13. 0.013 0.013 ↑ 1.0 1 1

Index Scan using wfa_notificaciones_pk on cwfa_notificacion ntf_1 (cost=0.43..7.45 rows=1 width=49) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (not_id = '5001526'::numeric)
14. 0.070 0.070 ↑ 2.0 636 1

Seq Scan on cwfa_actividades_proceso pac_1 (cost=0.00..29.74 rows=1,274 width=32) (actual time=0.007..0.070 rows=636 loops=1)

15. 0.319 0.319 ↓ 73.6 515 1

Seq Scan on cwfa_actividad act_1 (cost=0.00..39.45 rows=7 width=58) (actual time=0.005..0.319 rows=515 loops=1)

  • Filter: (act_version = act_ult_version)
  • Rows Removed by Filter: 744
16. 240.343 240.343 ↓ 0.0 0 1

Index Scan using wfa_caso_ind_4 on casos ca_1 (cost=0.42..19,712.09 rows=1 width=994) (actual time=240.343..240.343 rows=0 loops=1)

  • Index Cond: ((caso_fecha_termino IS NOT NULL) AND (caso_last_nid = '5001526'::numeric))