explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sDo9

Settings
# exclusive inclusive rows x rows loops node
1. 102.175 155.198 ↑ 2.0 1 1

Result (cost=1.41..17,787.36 rows=2 width=1,240) (actual time=102.224..155.198 rows=1 loops=1)

2. 0.003 53.023 ↑ 2.0 1 1

Append (cost=1.41..17,786.30 rows=2 width=1,196) (actual time=0.049..53.023 rows=1 loops=1)

3. 0.007 0.053 ↑ 1.0 1 1

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

4. 0.002 0.041 ↑ 1.0 1 1

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

5. 0.003 0.026 ↑ 1.0 1 1

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

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

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

  • Index Cond: (actividad_id = ntf.actividad_id)
8. 0.013 0.013 ↑ 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.012..0.013 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.005 0.005 ↑ 1.0 1 1

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

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

Nested Loop (cost=0.85..17,763.66 rows=1 width=1,196) (actual time=52.967..52.967 rows=0 loops=1)

11. 0.051 0.589 ↑ 1.0 1 1

Nested Loop (cost=0.43..92.67 rows=1 width=105) (actual time=0.424..0.589 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.134 0.215 ↑ 1.0 1 1

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

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

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

15. 0.323 0.323 ↓ 73.6 515 1

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

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

Index Scan using wfa_caso_ind_1 on casos ca_1 (cost=0.42..17,670.98 rows=1 width=994) (actual time=52.377..52.377 rows=0 loops=1)

  • Index Cond: (caso_last_nid = '5001526'::numeric)