# | 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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|