explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4PFK

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

Append (cost=293,506.05..587,151.43 rows=43 width=10) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=293,506.05..293,573.65 rows=16 width=10) (actual rows= loops=)

  • Hash Cond: ((doc.wfa_subtipo)::text = (niv.wfa_subtipo)::text)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=293,504.87..293,572.41 rows=16 width=20) (actual rows= loops=)

  • Hash Cond: ((doc.wfa_sistema)::text = (sis.wfa_sistema)::text)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=293,503.75..293,571.22 rows=16 width=33) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=293,503.33..293,554.31 rows=34 width=6) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=293,502.90..293,544.38 rows=17 width=6) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Unique (cost=293,502.47..293,502.48 rows=2 width=6) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Sort (cost=293,502.47..293,502.48 rows=2 width=6) (actual rows= loops=)

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

Append (cost=81.51..293,502.46 rows=2 width=6) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=81.51..146,750.84 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=81.08..142,739.27 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=80.65..120.57 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=80.38..116.80 rows=9 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=74.03..74.03 rows=423 width=54) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Subquery Scan on z (cost=65.57..74.03 rows=423 width=54) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

HashAggregate (cost=65.57..69.80 rows=423 width=54) (actual rows= loops=)

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

Hash Join (cost=1.81..56.20 rows=1,250 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..35.59 rows=1,259 width=27) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash (cost=1.36..1.36 rows=36 width=7) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on wf_item_types b (cost=0.00..1.36 rows=36 width=7) (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..142,133.53 rows=13,862 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..9.47 rows=2 width=4) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_roles_usuarios_pk on cwfa_roles_usuario wur (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((usr_codigo = 'ACIERO'::text) AND (rol_nombre = (ntf.not_rol_receptor)::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,968.53 rows=29,801 width=12) (actual rows= loops=)

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

Nested Loop (cost=146,751.26..146,751.60 rows=1 width=6) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

HashAggregate (cost=146,750.84..146,750.85 rows=1 width=6) (actual rows= loops=)

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

Nested Loop (cost=81.51..146,750.84 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=81.08..142,739.27 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=80.65..120.57 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=80.38..116.80 rows=9 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=74.03..74.03 rows=423 width=54) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Subquery Scan on z_1 (cost=65.57..74.03 rows=423 width=54) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

HashAggregate (cost=65.57..69.80 rows=423 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=1.81..56.20 rows=1,250 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..35.59 rows=1,259 width=27) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Hash (cost=1.36..1.36 rows=36 width=7) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on wf_item_types b_1 (cost=0.00..1.36 rows=36 width=7) (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..142,133.53 rows=13,862 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..9.47 rows=2 width=4) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_roles_usuarios_pk on cwfa_roles_usuario wur_1 (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((usr_codigo = 'ACIERO'::text) AND (rol_nombre = (ntf_1.not_rol_receptor)::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,968.53 rows=29,801 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.74 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..20.87 rows=8 width=12) (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.50 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

Hash (cost=1.05..1.05 rows=5 width=8) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Seq Scan on wfa_sistema_funcion sis (cost=0.00..1.05 rows=5 width=8) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Hash (cost=1.08..1.08 rows=8 width=12) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Seq Scan on wfa_documento_nivel niv (cost=0.00..1.08 rows=8 width=12) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Hash Join (cost=293,506.47..293,577.34 rows=27 width=10) (actual rows= loops=)

  • Hash Cond: ((doc_1.wfa_subtipo)::text = (niv_1.wfa_subtipo)::text)
61. 0.000 0.000 ↓ 0.0

Hash Join (cost=293,505.29..293,576.06 rows=27 width=20) (actual rows= loops=)

  • Hash Cond: ((doc_1.wfa_sistema)::text = (sis_1.wfa_sistema)::text)
62. 0.000 0.000 ↓ 0.0

Nested Loop (cost=293,504.17..293,574.82 rows=27 width=33) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Nested Loop (cost=293,503.75..293,547.47 rows=55 width=6) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Nested Loop (cost=293,503.32..293,531.11 rows=28 width=6) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Nested Loop (cost=293,502.89..293,526.71 rows=5 width=6) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Unique (cost=293,502.47..293,502.48 rows=2 width=6) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Sort (cost=293,502.47..293,502.48 rows=2 width=6) (actual rows= loops=)

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

Append (cost=81.51..293,502.46 rows=2 width=6) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Nested Loop (cost=81.51..146,750.84 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 (...)
70. 0.000 0.000 ↓ 0.0

Nested Loop (cost=81.08..142,739.27 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. (...)
71. 0.000 0.000 ↓ 0.0

Nested Loop (cost=80.65..120.57 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))
72. 0.000 0.000 ↓ 0.0

Hash Join (cost=80.38..116.80 rows=9 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))
73. 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=)

74. 0.000 0.000 ↓ 0.0

Hash (cost=74.03..74.03 rows=423 width=54) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Subquery Scan on z_2 (cost=65.57..74.03 rows=423 width=54) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

HashAggregate (cost=65.57..69.80 rows=423 width=54) (actual rows= loops=)

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

Hash Join (cost=1.81..56.20 rows=1,250 width=27) (actual rows= loops=)

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

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

79. 0.000 0.000 ↓ 0.0

Hash (cost=1.36..1.36 rows=36 width=7) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Seq Scan on wf_item_types b_2 (cost=0.00..1.36 rows=36 width=7) (actual rows= loops=)

81. 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))
82. 0.000 0.000 ↓ 0.0

Index Scan using wfa_notificacion_n1 on cwfa_notificacion ntf_2 (cost=0.43..142,133.53 rows=13,862 width=19) (actual rows= loops=)

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

SubPlan (forIndex Scan)

84. 0.000 0.000 ↓ 0.0

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

85. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_roles_usuarios_pk on cwfa_roles_usuario wur_2 (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((usr_codigo = 'ACIERO'::text) AND (rol_nombre = (ntf_2.not_rol_receptor)::text))
86. 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)
87. 0.000 0.000 ↓ 0.0

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

88. 0.000 0.000 ↓ 0.0

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

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

Nested Loop (cost=146,751.26..146,751.60 rows=1 width=6) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

HashAggregate (cost=146,750.84..146,750.85 rows=1 width=6) (actual rows= loops=)

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

Nested Loop (cost=81.51..146,750.84 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 (...)
92. 0.000 0.000 ↓ 0.0

Nested Loop (cost=81.08..142,739.27 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, (( (...)
93. 0.000 0.000 ↓ 0.0

Nested Loop (cost=80.65..120.57 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))
94. 0.000 0.000 ↓ 0.0

Hash Join (cost=80.38..116.80 rows=9 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))
95. 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=)

96. 0.000 0.000 ↓ 0.0

Hash (cost=74.03..74.03 rows=423 width=54) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Subquery Scan on z_3 (cost=65.57..74.03 rows=423 width=54) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

HashAggregate (cost=65.57..69.80 rows=423 width=54) (actual rows= loops=)

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

Hash Join (cost=1.81..56.20 rows=1,250 width=27) (actual rows= loops=)

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

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

101. 0.000 0.000 ↓ 0.0

Hash (cost=1.36..1.36 rows=36 width=7) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Seq Scan on wf_item_types b_3 (cost=0.00..1.36 rows=36 width=7) (actual rows= loops=)

103. 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))
104. 0.000 0.000 ↓ 0.0

Index Scan using wfa_notificacion_n1 on cwfa_notificacion ntf_3 (cost=0.43..142,133.53 rows=13,862 width=19) (actual rows= loops=)

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

SubPlan (forIndex Scan)

106. 0.000 0.000 ↓ 0.0

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

107. 0.000 0.000 ↓ 0.0

Index Only Scan using wfa_roles_usuarios_pk on cwfa_roles_usuario wur_3 (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((usr_codigo = 'ACIERO'::text) AND (rol_nombre = (ntf_3.not_rol_receptor)::text))
108. 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)
109. 0.000 0.000 ↓ 0.0

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

110. 0.000 0.000 ↓ 0.0

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

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

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

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

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

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

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

  • Index Cond: (wfa_caso_id = pad.wfa_hijo)
114. 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)
115. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=1.05..1.05 rows=5 width=8) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Seq Scan on wfa_sistema_funcion sis_1 (cost=0.00..1.05 rows=5 width=8) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Hash (cost=1.08..1.08 rows=8 width=12) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Seq Scan on wfa_documento_nivel niv_1 (cost=0.00..1.08 rows=8 width=12) (actual rows= loops=)