explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uMD6

Settings
# exclusive inclusive rows x rows loops node
1. 128.928 545.819 ↑ 2.0 1 1

Result (cost=1.41..49,920.51 rows=2 width=1,240) (actual time=129.076..545.819 rows=1 loops=1)

2. 0.002 416.891 ↑ 2.0 1 1

Append (cost=1.41..49,919.45 rows=2 width=1,196) (actual time=0.149..416.891 rows=1 loops=1)

3. 0.010 0.153 ↑ 1.0 1 1

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

4. 0.004 0.134 ↑ 1.0 1 1

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

5. 0.008 0.097 ↑ 1.0 1 1

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

6. 0.046 0.046 ↑ 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.045..0.046 rows=1 loops=1)

  • Index Cond: (not_id = '5001526'::numeric)
  • Filter: ((not_estado)::text = 'OPEN'::text)
7. 0.043 0.043 ↑ 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.043..0.043 rows=1 loops=1)

  • Index Cond: (actividad_id = ntf.actividad_id)
8. 0.033 0.033 ↑ 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.032..0.033 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.009 0.009 ↑ 1.0 1 1

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

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

Nested Loop (cost=0.43..49,896.81 rows=1 width=1,196) (actual time=416.736..416.736 rows=0 loops=1)

11. 0.052 0.655 ↑ 1.0 1 1

Nested Loop (cost=0.43..92.67 rows=1 width=105) (actual time=0.479..0.655 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.127 0.235 ↑ 1.0 1 1

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

  • Join Filter: (ntf_1.actividad_id = pac_1.actividad_id)
  • Rows Removed by Join Filter: 635
13. 0.015 0.015 ↑ 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.015 rows=1 loops=1)

  • Index Cond: (not_id = '5001526'::numeric)
14. 0.093 0.093 ↑ 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.011..0.093 rows=636 loops=1)

15. 0.368 0.368 ↓ 73.6 515 1

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

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

Seq Scan on casos ca_1 (cost=0.00..49,804.12 rows=1 width=994) (actual time=416.080..416.080 rows=0 loops=1)

  • Filter: ((caso_fecha_termino IS NOT NULL) AND (caso_last_nid = '5001526'::numeric))
  • Rows Removed by Filter: 871917