explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QwbO

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 247.235 ↑ 41.0 1 1

Limit (cost=43.77..25,312.96 rows=41 width=8) (actual time=243.048..247.235 rows=1 loops=1)

2. 0.007 247.234 ↑ 144.0 1 1

Merge Semi Join (cost=43.77..88,794.09 rows=144 width=8) (actual time=243.047..247.234 rows=1 loops=1)

  • Merge Cond: (ag_nodo5__.id_nodo = ag_nodo5__competencia_ficha_modificacion.id_nodo)
3. 0.041 247.193 ↑ 144.0 1 1

Merge Append (cost=43.48..88,208.12 rows=144 width=8) (actual time=243.008..247.193 rows=1 loops=1)

  • Sort Key: ag_nodo5__.id_nodo DESC
4. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5___pkey on ag_nodo5__ (cost=0.12..8.15 rows=1 width=8) (actual time=0.003..0.004 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
5. 0.007 0.012 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: gd__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
6. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on gd__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
7. 0.007 0.009 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.008..0.009 rows=0 loops=1)

  • Sort Key: gdclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
8. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gdclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
9. 0.006 0.008 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: gsu__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
10. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gsu__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
11. 6.035 6.035 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__competencia_pkey on ag_nodo5__competencia (cost=0.29..1,579.11 rows=1 width=8) (actual time=6.035..6.035 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 18,500
12. 13.396 13.396 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__competencia_clon_modificacion_pkey on ag_nodo5__competencia_clon_modificacion (cost=0.29..3,219.08 rows=1 width=8) (actual time=13.396..13.396 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 48,629
13. 1.266 1.266 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__competencia_ficha_gc_pkey on ag_nodo5__competencia_ficha_gc (cost=0.28..229.94 rows=1 width=8) (actual time=1.266..1.266 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 3,329
14. 4.223 4.223 ↑ 2.0 1 1

Index Scan Backward using ag_nodo5__competencia_ficha_modificacion_pkey on ag_nodo5__competencia_ficha_modificacion ag_nodo5__competencia_ficha_modificacion_1 (cost=0.29..616.58 rows=2 width=8) (actual time=0.038..4.223 rows=1 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 8,554
15. 0.008 0.008 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__competencia_proceso_gestion_pkey on ag_nodo5__competencia_proceso_gestion (cost=0.13..12.25 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 5
16. 36.955 36.955 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__conducta_pkey on ag_nodo5__conducta (cost=0.29..15,156.41 rows=1 width=8) (actual time=36.955..36.955 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 75,734
17. 87.408 87.408 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__conducta_clon_modificacion_pkey on ag_nodo5__conducta_clon_modificacion (cost=0.42..24,428.07 rows=1 width=8) (actual time=87.408..87.408 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 188,646
18. 0.624 0.624 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__encuesta_pkey on ag_nodo5__encuesta (cost=0.28..164.03 rows=1 width=8) (actual time=0.624..0.624 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 2,145
19. 0.014 0.014 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__encuesta_encuesta_pkey on ag_nodo5__encuesta_encuesta (cost=0.13..12.17 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 2
20. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__encuesta_test_pkey on ag_nodo5__encuesta_test (cost=0.13..12.17 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 2
21. 0.224 0.224 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__ind_meta_pkey on ag_nodo5__ind_meta (cost=0.15..118.64 rows=1 width=8) (actual time=0.224..0.224 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 326
22. 0.452 0.452 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__ind_meta_clon_modificacion_pkey on ag_nodo5__ind_meta_clon_modificacion (cost=0.28..178.10 rows=1 width=8) (actual time=0.452..0.452 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 906
23. 2.602 2.602 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__ind_tarea_pkey on ag_nodo5__ind_tarea (cost=0.28..1,523.26 rows=1 width=8) (actual time=2.602..2.602 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 4,330
24. 6.732 6.732 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__ind_tarea_clon_modificacion_pkey on ag_nodo5__ind_tarea_clon_modificacion (cost=0.29..2,195.99 rows=1 width=8) (actual time=6.731..6.732 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 12,579
25. 1.780 1.780 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__indicador_pkey on ag_nodo5__indicador (cost=0.28..1,075.75 rows=1 width=8) (actual time=1.780..1.780 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 3,044
26. 4.908 4.908 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__indicador_clon_modificacion_pkey on ag_nodo5__indicador_clon_modificacion (cost=0.29..1,608.52 rows=1 width=8) (actual time=4.908..4.908 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 8,867
27. 0.114 0.114 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__meta_pkey on ag_nodo5__meta (cost=0.14..61.32 rows=1 width=8) (actual time=0.114..0.114 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 250
28. 0.245 0.245 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__meta_clon_modificacion_pkey on ag_nodo5__meta_clon_modificacion (cost=0.28..99.15 rows=1 width=8) (actual time=0.245..0.245 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 689
29. 0.489 0.489 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__meta_ficha_gc_pkey on ag_nodo5__meta_ficha_gc (cost=0.28..127.73 rows=1 width=8) (actual time=0.489..0.489 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 1,275
30. 1.647 1.647 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__meta_ficha_modificacion_pkey on ag_nodo5__meta_ficha_modificacion (cost=0.28..260.51 rows=1 width=8) (actual time=1.647..1.647 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 3,588
31. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__meta_proceso_gestion_pkey on ag_nodo5__meta_proceso_gestion (cost=0.13..12.17 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 2
32. 1.078 1.078 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__objetivo_pkey on ag_nodo5__objetivo (cost=0.28..457.74 rows=1 width=8) (actual time=1.078..1.078 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 2,318
33. 2.729 2.729 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__objetivo_clon_modificacion_pkey on ag_nodo5__objetivo_clon_modificacion (cost=0.28..725.15 rows=1 width=8) (actual time=2.729..2.729 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 6,754
34. 0.529 0.529 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__objetivo_ficha_gc_pkey on ag_nodo5__objetivo_ficha_gc (cost=0.28..128.17 rows=1 width=8) (actual time=0.529..0.529 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 1,275
35. 1.746 1.746 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__objetivo_ficha_modificacion_pkey on ag_nodo5__objetivo_ficha_modificacion (cost=0.28..273.19 rows=1 width=8) (actual time=1.746..1.746 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 3,588
36. 0.019 0.019 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__objetivo_proceso_gestion_pkey on ag_nodo5__objetivo_proceso_gestion (cost=0.13..12.17 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 2
37. 1.329 1.329 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__tarea_pkey on ag_nodo5__tarea (cost=0.28..656.03 rows=1 width=8) (actual time=1.329..1.329 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 3,297
38. 3.850 3.850 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__tarea_clon_modificacion_pkey on ag_nodo5__tarea_clon_modificacion (cost=0.29..990.89 rows=1 width=8) (actual time=3.850..3.850 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 9,549
39. 0.549 0.549 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__tarea_ficha_gc_pkey on ag_nodo5__tarea_ficha_gc (cost=0.28..128.18 rows=1 width=8) (actual time=0.549..0.549 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 1,275
40. 1.807 1.807 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__tarea_ficha_modificacion_pkey on ag_nodo5__tarea_ficha_modificacion (cost=0.28..271.85rows=1 width=8) (cost=0..0 rows=0 width=0) (actual time=1.807..1.807 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 3,588
41. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__tarea_proceso_gestion_pkey on ag_nodo5__tarea_proceso_gestion (cost=0.13..12.17 rows=1width=8) (cost=0..0 rows=0 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 2
42. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__bitacora_pkey on ag_nodo5__bitacora (cost=0.14..46.39 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
43. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__bitacora_proceso_gestion_pkey on ag_nodo5__bitacora_proceso_gestion (cost=0.14..47.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
44. 0.018 0.025 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.025..0.025 rows=0 loops=1)

  • Sort Key: gd_calibracion__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
45. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on gd_calibracion__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
46. 0.008 0.009 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: gd_comentario__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
47. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on gd_comentario__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
48. 0.010 0.012 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: gd_compromiso__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
49. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromiso__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
50. 0.007 0.011 ↓ 0.0 0 1

Sort (cost=12.63..12.64 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: gd_evaluation_pg__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
51. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gd_evaluation_pg__ (cost=0.00..12.62 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
52. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using gd_fichapivote___id_nodo_key on gd_fichapivote__ (cost=0.12..8.15 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
53. 0.008 0.010 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: gd_fichgc__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
54. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_fichgc__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
55. 0.009 0.011 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: gd_objind__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
56. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_objind__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
57. 0.006 0.007 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: gd_procesogestion__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
58. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on gd_procesogestion__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
59. 0.016 0.021 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.021..0.021 rows=0 loops=1)

  • Sort Key: gd_oportunidad__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
60. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on gd_oportunidad__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
61. 0.005 0.007 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: gd_detecnecesidad__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
62. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_detecnecesidad__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
63. 0.005 0.007 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: gd_fortaleza__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
64. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_fortaleza__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
65. 0.010 0.012 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: gd_comentarioclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
66. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_comentarioclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
67. 0.009 0.012 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Sort Key: gd_compromiso_accionclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
68. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on gd_compromiso_accionclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
69. 0.005 0.007 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: gd_compromisoclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
70. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromisoclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
71. 0.007 0.008 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: gd_compromisodesclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
72. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on gd_compromisodesclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
73. 0.005 0.006 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: gd_compromisomejoraclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
74. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on gd_compromisomejoraclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
75. 0.006 0.010 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: gd_indicadorclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
76. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gd_indicadorclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
77. 0.004 0.007 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: gd_objetivoclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
78. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on gd_objetivoclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
79. 0.005 0.019 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.019..0.019 rows=0 loops=1)

  • Sort Key: gd_fortalezaclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
80. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on gd_fortalezaclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
81. 0.005 0.007 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: gd_oportunidadclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
82. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_oportunidadclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
83. 0.008 0.011 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: gd_detecnecesidadclon__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
84. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on gd_detecnecesidadclon__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
85. 0.007 0.008 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.007..0.008 rows=0 loops=1)

  • Sort Key: gsu_diccionarioactividad__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
86. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on gsu_diccionarioactividad__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
87. 0.005 0.007 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.006..0.007 rows=0 loops=1)

  • Sort Key: gsu_familiaposicion__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
88. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gsu_familiaposicion__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
89. 0.008 0.011 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: gsu_plan__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
90. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on gsu_plan__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
91. 0.005 0.009 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: gsu_planactividad__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
92. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gsu_planactividad__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
93. 0.006 0.008 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: gsu_planactividadaccion__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
94. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gsu_planactividadaccion__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
95. 0.006 0.007 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: gsu_sucesionusuario__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
96. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on gsu_sucesionusuario__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
97. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_calibracion_pkey on ag_nodo5__gd_calibracion (cost=0.14..45.27 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
98. 0.196 0.196 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_comentario_pkey on ag_nodo5__gd_comentario (cost=0.15..46.91 rows=1 width=8) (actual time=0.196..0.196 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 368
99. 0.006 0.008 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: gd_compromiso_accion__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
100. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on gd_compromiso_accion__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
101. 0.004 0.008 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: gd_compromisodes__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
102. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gd_compromisodes__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
103. 0.007 0.008 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Sort Key: gd_compromisomejora__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
104. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on gd_compromisomejora__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
105. 0.964 0.964 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromiso_pkey on ag_nodo5__gd_compromiso (cost=0.28..593.81 rows=1 width=8) (actual time=0.963..0.964 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 1,504
106. 0.363 0.363 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromiso_ficham_pkey on ag_nodo5__gd_compromiso_ficham (cost=0.28..201.62 rows=1 width=8) (actual time=0.363..0.363 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 635
107. 2.853 2.853 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_objetivo_ficham_pkey on ag_nodo5__gd_objetivo_ficham (cost=0.28..628.44 rows=1 width=8) (actual time=2.853..2.853 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 5,269
108. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisomejora_ficham_pkey on ag_nodo5__gd_compromisomejora_ficham (cost=0.14..47.52 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
109. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisodes_ficham_pkey on ag_nodo5__gd_compromisodes_ficham (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
110. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_objetivo_fichaef_pkey on ag_nodo5__gd_objetivo_fichaef (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
111. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromiso_fichaef_pkey on ag_nodo5__gd_compromiso_fichaef (cost=0.14..47.52 rows=1width=8) (cost=0..0 rows=0 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
112. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisomejora_fichaef_pkey on ag_nodo5__gd_compromisomejora_fichaef (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
113. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisodes_fichaef_pkey on ag_nodo5__gd_compromisodes_fichaef (cost=0.14..47.52 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
114. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_fortaleza_ficham_pkey on ag_nodo5__gd_fortaleza_ficham (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
115. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_oportunidad_ficham_pkey on ag_nodo5__gd_oportunidad_ficham (cost=0.14..47.52 rows=1width=8) (cost=0..0 rows=0 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
116. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_detecnecesidad_ficham_pkey on ag_nodo5__gd_detecnecesidad_ficham (cost=0.14..47.52 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
117. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_fortaleza_fichaef_pkey on ag_nodo5__gd_fortaleza_fichaef (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
118. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_oportunidad_fichaef_pkey on ag_nodo5__gd_oportunidad_fichaef (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
119. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_detecnecesidad_fichaef_pkey on ag_nodo5__gd_detecnecesidad_fichaef (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
120. 0.354 0.354 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromiso_fichagc_pkey on ag_nodo5__gd_compromiso_fichagc (cost=0.28..270.99 rows=1 width=8) (actual time=0.353..0.354 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 1,131
121. 0.765 0.765 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_objetivo_fichagc_pkey on ag_nodo5__gd_objetivo_fichagc (cost=0.28..272.19 rows=1 width=8) (actual time=0.765..0.765 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 2,040
122. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisomejora_fichagc_pkey on ag_nodo5__gd_compromisomejora_fichagc (cost=0.14..47.74 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
123. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisodes_fichagc_pkey on ag_nodo5__gd_compromisodes_fichagc (cost=0.14..47.74 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
124. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_fortaleza_fichagc_pkey on ag_nodo5__gd_fortaleza_fichagc (cost=0.14..47.74 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
125. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_oportunidad_fichagc_pkey on ag_nodo5__gd_oportunidad_fichagc (cost=0.14..47.74 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
126. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_detecnecesidad_fichagc_pkey on ag_nodo5__gd_detecnecesidad_fichagc (cost=0.14..47.74 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
127. 0.009 0.013 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Sort Key: gd_indicador__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
128. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on gd_indicador__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
129. 0.005 0.006 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: gd_objetivo__.id_nodo DESC
  • Sort Method: quicksort Memory: 25kB
130. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on gd_objetivo__ (cost=0.00..0.00 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
131. 0.009 0.009 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromiso_pg_pkey on ag_nodo5__gd_compromiso_pg (cost=0.12..8.15 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 1
132. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_objetivo_pg_pkey on ag_nodo5__gd_objetivo_pg (cost=0.13..12.20 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 3
133. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisomejora_pg_pkey on ag_nodo5__gd_compromisomejora_pg (cost=0.14..47.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
134. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisodes_pg_pkey on ag_nodo5__gd_compromisodes_pg (cost=0.14..47.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
135. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_fortaleza_pg_pkey on ag_nodo5__gd_fortaleza_pg (cost=0.14..47.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
136. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_oportunidad_pg_pkey on ag_nodo5__gd_oportunidad_pg (cost=0.14..47.30 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
137. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_detecnecesidad_pg_pkey on ag_nodo5__gd_detecnecesidad_pg (cost=0.14..47.30 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
138. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_oportunidad_pkey on ag_nodo5__gd_oportunidad (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
139. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_detecnecesidad_pkey on ag_nodo5__gd_detecnecesidad (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
140. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_fortaleza_pkey on ag_nodo5__gd_fortaleza (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
141. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_comentarioclon_ef_pkey on ag_nodo5__gd_comentarioclon_ef (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
142. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_comentarioclon_m_pkey on ag_nodo5__gd_comentarioclon_m (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
143. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromiso_accionclon_m_pkey on ag_nodo5__gd_compromiso_accionclon_m (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
144. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromiso_accionclon_ef_pkey on ag_nodo5__gd_compromiso_accionclon_ef (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
145. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisodes_accionclon_m_pkey on ag_nodo5__gd_compromisodes_accionclon_m (cost=0.14..45.27 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
146. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisodes_accionclon_ef_pkey on ag_nodo5__gd_compromisodes_accionclon_ef (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
147. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisomejora_accionclon_m_pkey on ag_nodo5__gd_compromisomejora_accionclon_m (cost=0.14..45.27 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
148. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisomejora_accionclon_ef_pkey on ag_nodo5__gd_compromisomejora_accionclon_ef (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
149. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_objetivo_accionclon_m_pkey on ag_nodo5__gd_objetivo_accionclon_m (cost=0.14..45.27 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
150. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_objetivo_accionclon_ef_pkey on ag_nodo5__gd_objetivo_accionclon_ef (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
151. 0.208 0.208 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisoclon_m_pkey on ag_nodo5__gd_compromisoclon_m (cost=0.15..71.35 rows=1 width=8) (actual time=0.208..0.208 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 372
152. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisoclon_ef_pkey on ag_nodo5__gd_compromisoclon_ef (cost=0.14..45.27 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
153. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisodesclon_m_pkey on ag_nodo5__gd_compromisodesclon_m (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
154. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisodesclon_ef_pkey on ag_nodo5__gd_compromisodesclon_ef (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
155. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisomejoraclon_m_pkey on ag_nodo5__gd_compromisomejoraclon_m (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
156. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisomejoraclon_ef_pkey on ag_nodo5__gd_compromisomejoraclon_ef (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
157. 26.160 26.160 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_indicadorclon_m_pkey on ag_nodo5__gd_indicadorclon_m (cost=0.29..8,472.69 rows=1 width=8) (actual time=26.160..26.160 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 47,535
158. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_indicadorclon_ef_pkey on ag_nodo5__gd_indicadorclon_ef (cost=0.14..45.04 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
159. 15.719 15.719 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_objetivoclon_m_pkey on ag_nodo5__gd_objetivoclon_m (cost=0.29..3,705.84 rows=1 width=8) (actual time=15.719..15.719 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 33,290
160. 0.004 0.004 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_objetivoclon_ef_pkey on ag_nodo5__gd_objetivoclon_ef (cost=0.14..44.81 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
161. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_fortalezaclon_m_pkey on ag_nodo5__gd_fortalezaclon_m (cost=0.14..45.27 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
162. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_fortalezaclon_ef_pkey on ag_nodo5__gd_fortalezaclon_ef (cost=0.14..45.27 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
163. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_oportunidadclon_m_pkey on ag_nodo5__gd_oportunidadclon_m (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
164. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_oportunidadclon_ef_pkey on ag_nodo5__gd_oportunidadclon_ef (cost=0.14..45.27 rows=1width=8) (cost=0..0 rows=0 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
165. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_detecnecesidadclon_m_pkey on ag_nodo5__gd_detecnecesidadclon_m (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
166. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_detecnecesidadclon_ef_pkey on ag_nodo5__gd_detecnecesidadclon_ef (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
167. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gsu_d_actividad_pkey on ag_nodo5__gsu_d_actividad (cost=0.14..46.84 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
168. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gsu_fp_familiaposicion_pkey on ag_nodo5__gsu_fp_familiaposicion (cost=0.14..46.39 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
169. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gsu_p_plan_pkey on ag_nodo5__gsu_p_plan (cost=0.14..47.74 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
170. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gsu_p_actividad_pkey on ag_nodo5__gsu_p_actividad (cost=0.14..46.84 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
171. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gsu_p_accion_pkey on ag_nodo5__gsu_p_accion (cost=0.14..46.84 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
172. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gsu_s_sucesion_usuario_pkey on ag_nodo5__gsu_s_sucesion_usuario (cost=0.14..47.52 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
173. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_accion_compromiso_pkey on ag_nodo5__gd_accion_compromiso (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
174. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_accion_compromisodes_pkey on ag_nodo5__gd_accion_compromisodes (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
175. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_accion_compromisomejora_pkey on ag_nodo5__gd_accion_compromisomejora (cost=0.14..45.27 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
176. 0.001 0.001 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_accion_objetivo_pkey on ag_nodo5__gd_accion_objetivo (cost=0.14..45.27 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
177. 0.002 0.002 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisodes_pkey on ag_nodo5__gd_compromisodes (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
178. 0.003 0.003 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_compromisomejora_pkey on ag_nodo5__gd_compromisomejora (cost=0.14..45.27 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
179. 10.154 10.154 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_indicador_pkey on ag_nodo5__gd_indicador (cost=0.29..10,325.64 rows=1 width=8) (actual time=10.154..10.154 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 18,927
180. 6.136 6.136 ↓ 0.0 0 1

Index Scan Backward using ag_nodo5__gd_objetivo_pkey on ag_nodo5__gd_objetivo (cost=0.29..4,281.87 rows=1 width=8) (actual time=6.136..6.136 rows=0 loops=1)

  • Filter: (((origen_valor2)::text = ANY ('{85034,85035}'::text[])) AND (tipo_nodo = 'competencia_ficha_modificacion'::bpchar) AND ((origen_entidad2)::text = 'evCard'::text))
  • Rows Removed by Filter: 13,933
181. 0.034 0.034 ↑ 234.7 19 1

Index Scan Backward using ag_nodo5__competencia_ficha_modificacion_pkey on ag_nodo5__competencia_ficha_modificacion (cost=0.29..573.71 rows=4,460 width=8) (actual time=0.021..0.034 rows=19 loops=1)

  • Filter: (indice_ficha = 1)
Planning time : 51.120 ms
Execution time : 249.347 ms