explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0bcn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Append (cost=271,978.85..544,103.45 rows=45 width=10) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,978.85..272,045.84 rows=17 width=10) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,978.70..272,042.99 rows=17 width=20) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,978.55..272,040.23 rows=17 width=33) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,978.13..272,023.43 rows=34 width=6) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,977.70..272,014.12 rows=16 width=6) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Unique (cost=271,977.27..271,977.28 rows=2 width=6) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Sort (cost=271,977.27..271,977.28 rows=2 width=6) (actual rows= loops=)

  • Sort Key: ca.caso_id
9. 0.000 0.000 ↓ 0.0

Append (cost=91.85..271,977.26 rows=2 width=6) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.85..135,988.25 rows=1 width=6) (actual rows= loops=)

  • Join Filter: ((ca.item_key)::text = substr((ntf.not_contexto)::text, ((instr(ntf.not_contexto, ':'::character varying, '1'::numeric, '1'::numeric) + 1))::numeric, ((instr(ntf.not_contexto, ':'::charac (...)
11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.43..132,273.72 rows=1 width=19) (actual rows= loops=)

  • Join Filter: ((pac.actividad_id)::text = substr((ntf.not_contexto)::text, ((instr(ntf.not_contexto, ':'::character varying, '1'::numeric, '2'::numeric) + 1))::numeric, ((instr(ntf.not_contexto, (...)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.00..131.29 rows=1 width=5) (actual rows= loops=)

  • Join Filter: (((z.item_type)::text = (c.item_type)::text) AND (z.maximo = c.act_version) AND ((z.act_nombre)::text = (c.act_nombre)::text))
13. 0.000 0.000 ↓ 0.0

Hash Join (cost=90.72..127.15 rows=10 width=82) (actual rows= loops=)

  • Hash Cond: (((pac.item_type)::text = (z.item_type)::text) AND ((pac.act_nombre)::text = (z.act_nombre)::text))
14. 0.000 0.000 ↓ 0.0

Seq Scan on cwfa_actividades_proceso pac (cost=0.00..29.74 rows=1,274 width=28) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=84.09..84.09 rows=442 width=54) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Subquery Scan on z (cost=75.25..84.09 rows=442 width=54) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

HashAggregate (cost=75.25..79.67 rows=442 width=54) (actual rows= loops=)

  • Group Key: a.item_type, a.act_nombre
18. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.12..65.38 rows=1,316 width=27) (actual rows= loops=)

  • Hash Cond: ((a.item_type)::text = (b.wrfw_descripcion)::text)
19. 0.000 0.000 ↓ 0.0

Seq Scan on cwfa_actividad a (cost=0.00..36.16 rows=1,316 width=27) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash (cost=10.50..10.50 rows=50 width=516) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on wf_item_types b (cost=0.00..10.50 rows=50 width=516) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_actividades_v2_pk on cwfa_actividad c (cost=0.28..0.40 rows=1 width=27) (actual rows= loops=)

  • Index Cond: ((act_nombre = (pac.act_nombre)::text) AND (item_type = (pac.item_type)::text))
23. 0.000 0.000 ↓ 0.0

Index Scan using wfa_notificacion_n1 on cwfa_notificacion ntf (cost=0.43..131,643.12 rows=14,266 width=19) (actual rows= loops=)

  • Index Cond: ((not_estado)::text = 'OPEN'::text)
  • Filter: (SubPlan 1)
24.          

SubPlan (forIndex Scan)

25. 0.000 0.000 ↓ 0.0

Append (cost=0.42..8.48 rows=2 width=4) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Index Scan using rol_nombre_idx on cwfa_roles_usuario wur (cost=0.42..7.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((rol_nombre)::text = (ntf.not_rol_receptor)::text)
  • Filter: ((usr_codigo)::text = 'ACIERO'::text)
27. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

  • One-Time Filter: ('ACIERO'::text = (ntf.not_rol_receptor)::text)
28. 0.000 0.000 ↓ 0.0

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

29. 0.000 0.000 ↓ 0.0

Index Scan using wfa_caso_ind_3 on casos ca (cost=0.42..2,694.25 rows=29,151 width=12) (actual rows= loops=)

  • Index Cond: (caso_fecha_termino IS NULL)
30. 0.000 0.000 ↓ 0.0

Nested Loop (cost=135,988.68..135,988.99 rows=1 width=6) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

HashAggregate (cost=135,988.26..135,988.27 rows=1 width=6) (actual rows= loops=)

  • Group Key: ca_1.caso_id
32. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.85..135,988.25 rows=1 width=6) (actual rows= loops=)

  • Join Filter: ((ca_1.item_key)::text = substr((ntf_1.not_contexto)::text, ((instr(ntf_1.not_contexto, ':'::character varying, '1'::numeric, '1'::numeric) + 1))::numeric, ((instr(ntf_1.not_c (...)
33. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.43..132,273.72 rows=1 width=19) (actual rows= loops=)

  • Join Filter: ((pac_1.actividad_id)::text = substr((ntf_1.not_contexto)::text, ((instr(ntf_1.not_contexto, ':'::character varying, '1'::numeric, '2'::numeric) + 1))::numeric, ((instr( (...)
34. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.00..131.29 rows=1 width=5) (actual rows= loops=)

  • Join Filter: (((z_1.item_type)::text = (c_1.item_type)::text) AND (z_1.maximo = c_1.act_version) AND ((z_1.act_nombre)::text = (c_1.act_nombre)::text))
35. 0.000 0.000 ↓ 0.0

Hash Join (cost=90.72..127.15 rows=10 width=82) (actual rows= loops=)

  • Hash Cond: (((pac_1.item_type)::text = (z_1.item_type)::text) AND ((pac_1.act_nombre)::text = (z_1.act_nombre)::text))
36. 0.000 0.000 ↓ 0.0

Seq Scan on cwfa_actividades_proceso pac_1 (cost=0.00..29.74 rows=1,274 width=28) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash (cost=84.09..84.09 rows=442 width=54) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Subquery Scan on z_1 (cost=75.25..84.09 rows=442 width=54) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

HashAggregate (cost=75.25..79.67 rows=442 width=54) (actual rows= loops=)

  • Group Key: a_1.item_type, a_1.act_nombre
40. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.12..65.38 rows=1,316 width=27) (actual rows= loops=)

  • Hash Cond: ((a_1.item_type)::text = (b_1.wrfw_descripcion)::text)
41. 0.000 0.000 ↓ 0.0

Seq Scan on cwfa_actividad a_1 (cost=0.00..36.16 rows=1,316 width=27) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Hash (cost=10.50..10.50 rows=50 width=516) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on wf_item_types b_1 (cost=0.00..10.50 rows=50 width=516) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_actividades_v2_pk on cwfa_actividad c_1 (cost=0.28..0.40 rows=1 width=27) (actual rows= loops=)

  • Index Cond: ((act_nombre = (pac_1.act_nombre)::text) AND (item_type = (pac_1.item_type)::text))
45. 0.000 0.000 ↓ 0.0

Index Scan using wfa_notificacion_n1 on cwfa_notificacion ntf_1 (cost=0.43..131,643.12 rows=14,266 width=19) (actual rows= loops=)

  • Index Cond: ((not_estado)::text = 'OPEN'::text)
  • Filter: (SubPlan 2)
46.          

SubPlan (forIndex Scan)

47. 0.000 0.000 ↓ 0.0

Append (cost=0.42..8.48 rows=2 width=4) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Index Scan using rol_nombre_idx on cwfa_roles_usuario wur_1 (cost=0.42..7.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((rol_nombre)::text = (ntf_1.not_rol_receptor)::text)
  • Filter: ((usr_codigo)::text = 'ACIERO'::text)
49. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

  • One-Time Filter: ('ACIERO'::text = (ntf_1.not_rol_receptor)::text)
50. 0.000 0.000 ↓ 0.0

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

51. 0.000 0.000 ↓ 0.0

Index Scan using wfa_caso_ind_3 on casos ca_1 (cost=0.42..2,694.25 rows=29,151 width=12) (actual rows= loops=)

  • Index Cond: (caso_fecha_termino IS NULL)
52. 0.000 0.000 ↓ 0.0

Index Scan using wfa_padre_hijos_ifk on wfa_padre_hijos pp (cost=0.42..0.71 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (wfa_hijo = ca_1.caso_id)
53. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_casos_doc_pk on wfa_casos_documento cas (cost=0.43..18.34 rows=8 width=13) (actual rows= loops=)

  • Index Cond: (wfa_caso_id = ca.caso_id)
54. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_anexo_documento_pk on wfa_anexo_documento ane (cost=0.43..0.55 rows=3 width=12) (actual rows= loops=)

  • Index Cond: (wfa_id_documento = cas.wfa_id_documento)
55. 0.000 0.000 ↓ 0.0

Index Scan using wfa_documento_pk on wfa_documento doc (cost=0.43..0.49 rows=1 width=39) (actual rows= loops=)

  • Index Cond: (wfa_id_documento = ane.wfa_id_documento_anexo)
  • Filter: ((wfa_tipo)::text = 'sgd'::text)
56. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_sistema_funcion_pk on wfa_sistema_funcion sis (cost=0.14..0.16 rows=1 width=78) (actual rows= loops=)

  • Index Cond: (wfa_sistema = (doc.wfa_sistema)::text)
57. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_documento_nivel_pk on wfa_documento_nivel niv (cost=0.15..0.17 rows=1 width=78) (actual rows= loops=)

  • Index Cond: (wfa_subtipo = (doc.wfa_subtipo)::text)
58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,979.27..272,057.16 rows=28 width=10) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,979.12..272,052.47 rows=28 width=20) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,978.97..272,047.91 rows=28 width=33) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,978.55..272,019.25 rows=58 width=6) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,978.12..272,002.96 rows=28 width=6) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Nested Loop (cost=271,977.69..271,998.60 rows=5 width=6) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Unique (cost=271,977.27..271,977.28 rows=2 width=6) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Sort (cost=271,977.27..271,977.28 rows=2 width=6) (actual rows= loops=)

  • Sort Key: ca_2.caso_id
66. 0.000 0.000 ↓ 0.0

Append (cost=91.85..271,977.26 rows=2 width=6) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.85..135,988.25 rows=1 width=6) (actual rows= loops=)

  • Join Filter: ((ca_2.item_key)::text = substr((ntf_2.not_contexto)::text, ((instr(ntf_2.not_contexto, ':'::character varying, '1'::numeric, '1'::numeric) + 1))::numeric, ((instr(ntf_2.not_context (...)
68. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.43..132,273.72 rows=1 width=19) (actual rows= loops=)

  • Join Filter: ((pac_2.actividad_id)::text = substr((ntf_2.not_contexto)::text, ((instr(ntf_2.not_contexto, ':'::character varying, '1'::numeric, '2'::numeric) + 1))::numeric, ((instr(ntf_2. (...)
69. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.00..131.29 rows=1 width=5) (actual rows= loops=)

  • Join Filter: (((z_2.item_type)::text = (c_2.item_type)::text) AND (z_2.maximo = c_2.act_version) AND ((z_2.act_nombre)::text = (c_2.act_nombre)::text))
70. 0.000 0.000 ↓ 0.0

Hash Join (cost=90.72..127.15 rows=10 width=82) (actual rows= loops=)

  • Hash Cond: (((pac_2.item_type)::text = (z_2.item_type)::text) AND ((pac_2.act_nombre)::text = (z_2.act_nombre)::text))
71. 0.000 0.000 ↓ 0.0

Seq Scan on cwfa_actividades_proceso pac_2 (cost=0.00..29.74 rows=1,274 width=28) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash (cost=84.09..84.09 rows=442 width=54) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Subquery Scan on z_2 (cost=75.25..84.09 rows=442 width=54) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

HashAggregate (cost=75.25..79.67 rows=442 width=54) (actual rows= loops=)

  • Group Key: a_2.item_type, a_2.act_nombre
75. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.12..65.38 rows=1,316 width=27) (actual rows= loops=)

  • Hash Cond: ((a_2.item_type)::text = (b_2.wrfw_descripcion)::text)
76. 0.000 0.000 ↓ 0.0

Seq Scan on cwfa_actividad a_2 (cost=0.00..36.16 rows=1,316 width=27) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Hash (cost=10.50..10.50 rows=50 width=516) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on wf_item_types b_2 (cost=0.00..10.50 rows=50 width=516) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_actividades_v2_pk on cwfa_actividad c_2 (cost=0.28..0.40 rows=1 width=27) (actual rows= loops=)

  • Index Cond: ((act_nombre = (pac_2.act_nombre)::text) AND (item_type = (pac_2.item_type)::text))
80. 0.000 0.000 ↓ 0.0

Index Scan using wfa_notificacion_n1 on cwfa_notificacion ntf_2 (cost=0.43..131,643.12 rows=14,266 width=19) (actual rows= loops=)

  • Index Cond: ((not_estado)::text = 'OPEN'::text)
  • Filter: (SubPlan 3)
81.          

SubPlan (forIndex Scan)

82. 0.000 0.000 ↓ 0.0

Append (cost=0.42..8.48 rows=2 width=4) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Index Scan using rol_nombre_idx on cwfa_roles_usuario wur_2 (cost=0.42..7.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((rol_nombre)::text = (ntf_2.not_rol_receptor)::text)
  • Filter: ((usr_codigo)::text = 'ACIERO'::text)
84. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

  • One-Time Filter: ('ACIERO'::text = (ntf_2.not_rol_receptor)::text)
85. 0.000 0.000 ↓ 0.0

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

86. 0.000 0.000 ↓ 0.0

Index Scan using wfa_caso_ind_3 on casos ca_2 (cost=0.42..2,694.25 rows=29,151 width=12) (actual rows= loops=)

  • Index Cond: (caso_fecha_termino IS NULL)
87. 0.000 0.000 ↓ 0.0

Nested Loop (cost=135,988.68..135,988.99 rows=1 width=6) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

HashAggregate (cost=135,988.26..135,988.27 rows=1 width=6) (actual rows= loops=)

  • Group Key: ca_3.caso_id
89. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.85..135,988.25 rows=1 width=6) (actual rows= loops=)

  • Join Filter: ((ca_3.item_key)::text = substr((ntf_3.not_contexto)::text, ((instr(ntf_3.not_contexto, ':'::character varying, '1'::numeric, '1'::numeric) + 1))::numeric, ((instr(ntf_3 (...)
90. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.43..132,273.72 rows=1 width=19) (actual rows= loops=)

  • Join Filter: ((pac_3.actividad_id)::text = substr((ntf_3.not_contexto)::text, ((instr(ntf_3.not_contexto, ':'::character varying, '1'::numeric, '2'::numeric) + 1))::numeric, (( (...)
91. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91.00..131.29 rows=1 width=5) (actual rows= loops=)

  • Join Filter: (((z_3.item_type)::text = (c_3.item_type)::text) AND (z_3.maximo = c_3.act_version) AND ((z_3.act_nombre)::text = (c_3.act_nombre)::text))
92. 0.000 0.000 ↓ 0.0

Hash Join (cost=90.72..127.15 rows=10 width=82) (actual rows= loops=)

  • Hash Cond: (((pac_3.item_type)::text = (z_3.item_type)::text) AND ((pac_3.act_nombre)::text = (z_3.act_nombre)::text))
93. 0.000 0.000 ↓ 0.0

Seq Scan on cwfa_actividades_proceso pac_3 (cost=0.00..29.74 rows=1,274 width=28) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Hash (cost=84.09..84.09 rows=442 width=54) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Subquery Scan on z_3 (cost=75.25..84.09 rows=442 width=54) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

HashAggregate (cost=75.25..79.67 rows=442 width=54) (actual rows= loops=)

  • Group Key: a_3.item_type, a_3.act_nombre
97. 0.000 0.000 ↓ 0.0

Hash Join (cost=11.12..65.38 rows=1,316 width=27) (actual rows= loops=)

  • Hash Cond: ((a_3.item_type)::text = (b_3.wrfw_descripcion)::text)
98. 0.000 0.000 ↓ 0.0

Seq Scan on cwfa_actividad a_3 (cost=0.00..36.16 rows=1,316 width=27) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Hash (cost=10.50..10.50 rows=50 width=516) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Seq Scan on wf_item_types b_3 (cost=0.00..10.50 rows=50 width=516) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_actividades_v2_pk on cwfa_actividad c_3 (cost=0.28..0.40 rows=1 width=27) (actual rows= loops=)

  • Index Cond: ((act_nombre = (pac_3.act_nombre)::text) AND (item_type = (pac_3.item_type)::text))
102. 0.000 0.000 ↓ 0.0

Index Scan using wfa_notificacion_n1 on cwfa_notificacion ntf_3 (cost=0.43..131,643.12 rows=14,266 width=19) (actual rows= loops=)

  • Index Cond: ((not_estado)::text = 'OPEN'::text)
  • Filter: (SubPlan 4)
103.          

SubPlan (forIndex Scan)

104. 0.000 0.000 ↓ 0.0

Append (cost=0.42..8.48 rows=2 width=4) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Index Scan using rol_nombre_idx on cwfa_roles_usuario wur_3 (cost=0.42..7.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((rol_nombre)::text = (ntf_3.not_rol_receptor)::text)
  • Filter: ((usr_codigo)::text = 'ACIERO'::text)
106. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

  • One-Time Filter: ('ACIERO'::text = (ntf_3.not_rol_receptor)::text)
107. 0.000 0.000 ↓ 0.0

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

108. 0.000 0.000 ↓ 0.0

Index Scan using wfa_caso_ind_3 on casos ca_3 (cost=0.42..2,694.25 rows=29,151 width=12) (actual rows= loops=)

  • Index Cond: (caso_fecha_termino IS NULL)
109. 0.000 0.000 ↓ 0.0

Index Scan using wfa_padre_hijos_ifk on wfa_padre_hijos pp_1 (cost=0.42..0.71 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (wfa_hijo = ca_3.caso_id)
110. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_padre_hijos_pk on wfa_padre_hijos pad (cost=0.42..10.63 rows=3 width=12) (actual rows= loops=)

  • Index Cond: (wfa_padre = ca_2.caso_id)
111. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_casos_doc_pk on wfa_casos_documento cas_1 (cost=0.43..0.79 rows=8 width=13) (actual rows= loops=)

  • Index Cond: (wfa_caso_id = pad.wfa_hijo)
112. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_anexo_documento_pk on wfa_anexo_documento ane_1 (cost=0.43..0.55 rows=3 width=12) (actual rows= loops=)

  • Index Cond: (wfa_id_documento = cas_1.wfa_id_documento)
113. 0.000 0.000 ↓ 0.0

Index Scan using wfa_documento_pk on wfa_documento doc_1 (cost=0.43..0.49 rows=1 width=39) (actual rows= loops=)

  • Index Cond: (wfa_id_documento = ane_1.wfa_id_documento_anexo)
  • Filter: ((wfa_tipo)::text = 'sgd'::text)
114. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_sistema_funcion_pk on wfa_sistema_funcion sis_1 (cost=0.14..0.16 rows=1 width=78) (actual rows= loops=)

  • Index Cond: (wfa_sistema = (doc_1.wfa_sistema)::text)
115. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_documento_nivel_pk on wfa_documento_nivel niv_1 (cost=0.15..0.17 rows=1 width=78) (actual rows= loops=)

  • Index Cond: (wfa_subtipo = (doc_1.wfa_subtipo)::text)