explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 41z

Settings
# exclusive inclusive rows x rows loops node
1. 0.120 649.014 ↓ 13.0 26 1

GroupAggregate (cost=11,943.67..11,943.71 rows=2 width=13) (actual time=648.954..649.014 rows=26 loops=1)

  • Group Key: ca.prcs_id
2. 0.368 648.894 ↓ 280.0 560 1

Sort (cost=11,943.67..11,943.68 rows=2 width=5) (actual time=648.862..648.894 rows=560 loops=1)

  • Sort Key: ca.prcs_id
  • Sort Method: quicksort Memory: 51kB
3. 2.954 648.526 ↓ 280.0 560 1

Nested Loop (cost=0.85..11,943.66 rows=2 width=5) (actual time=0.381..648.526 rows=560 loops=1)

4. 223.108 223.108 ↓ 206.7 30,176 1

Index Scan using wfa_caso_ind_3 on casos ca (cost=0.42..10,208.49 rows=146 width=11) (actual time=0.215..223.108 rows=30,176 loops=1)

  • Index Cond: (caso_fecha_termino IS NULL)
  • Filter: (prcs_id = (nvl(NULL::character varying, prcs_id))::numeric)
  • Rows Removed by Filter: 2
5. 210.864 422.464 ↓ 0.0 0 30,176

Index Scan using wfa_notificacion_n3 on cwfa_notificacion ntf (cost=0.43..11.87 rows=1 width=6) (actual time=0.014..0.014 rows=0 loops=30,176)

  • Index Cond: (((not_estado)::text = 'OPEN'::text) AND (caso_id = ca.caso_id))
  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 1
6.          

SubPlan (forIndex Scan)

7. 26.450 211.600 ↓ 0.0 0 26,450

Append (cost=0.42..8.47 rows=2 width=4) (actual time=0.008..0.008 rows=0 loops=26,450)

8. 185.150 185.150 ↓ 0.0 0 26,450

Index Only Scan using wfa_roles_usuarios_pk on cwfa_roles_usuario wur (cost=0.42..7.44 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=26,450)

  • Index Cond: ((usr_codigo = 'ARKADIOS'::text) AND (rol_nombre = (ntf.not_rol_receptor)::text))
  • Heap Fetches: 13
9. 0.000 0.000 ↓ 0.0 0 26,437

Result (cost=0.00..1.01 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=26,437)

  • One-Time Filter: ('ARKADIOS'::text = (ntf.not_rol_receptor)::text)
10. 0.000 0.000 ↑ 1.0 1 547

Seq Scan on dual (cost=0.00..1.01 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=547)