explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7L2hn

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

Group (cost=467,684.14..467,766.93 rows=487 width=393) (actual rows= loops=)

  • Group Key: v.vei_id, c.pes_id, s.sgr_id, f.frw_id, ftec.frw_rotulo, tec.per_modooperacao, f_1.frw_rotulo, ftec_1.frw_rotulo, fpea1.frw_rotulo, fpea2.frw_rotulo, fpea3.frw_rotulo, historicoatualizacao.his_datahora_inicio, slowfota.his_datahora_inicio, slo (...)
2. 0.000 0.000 ↓ 0.0

Sort (cost=467,684.14..467,685.36 rows=487 width=269) (actual rows= loops=)

  • Sort Key: v.vei_id, c.pes_id, s.sgr_id, f.frw_id, ftec.frw_rotulo, tec.per_modooperacao, f_1.frw_rotulo, ftec_1.frw_rotulo, fpea1.frw_rotulo, fpea2.frw_rotulo, fpea3.frw_rotulo, historicoatualizacao.his_datahora_inicio, slowfota.his_datahora_inicio (...)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=359,649.76..467,662.40 rows=487 width=269) (actual rows= loops=)

  • Hash Cond: (s.sgr_id = bloqsgr.sgr_id)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=359,625.45..467,636.82 rows=487 width=265) (actual rows= loops=)

  • Hash Cond: (s.sgr_id = aga.sgr_id)
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=309,981.23..417,991.32 rows=487 width=257) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=309,980.81..416,647.83 rows=487 width=253) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=309,980.38..407,072.02 rows=487 width=249) (actual rows= loops=)

  • Join Filter: (tec_1.per_datahora_poweron = finsaux.per_datahora_poweron)
8. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=309,979.81..406,716.38 rows=487 width=247) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=309,979.39..397,054.51 rows=492 width=247) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=309,979.10..396,836.14 rows=534 width=238) (actual rows= loops=)

  • Hash Cond: (v.sgr_id = finsaux.sgr_id)
11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=308,080.08..394,935.72 rows=534 width=234) (actual rows= loops=)

  • Join Filter: (tec.per_datahora_poweron = ftecaux.per_datahora_poweron)
12. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=308,079.51..394,547.12 rows=534 width=228) (actual rows= loops=)

  • Hash Cond: (v.sgr_id = ftecaux.sgr_id)
13. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=306,138.59..392,604.79 rows=534 width=220) (actual rows= loops=)

  • Join Filter: (per.per_datahora_poweron = fdceaux.per_datahora_poweron)
14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=306,138.02..392,243.85 rows=534 width=218) (actual rows= loops=)

  • Hash Cond: (v.sgr_id = fdceaux.sgr_id)
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=303,847.84..389,952.27 rows=534 width=210) (actual rows= loops=)

  • Hash Cond: (pea2.frw_id = fpea2.frw_id)
16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=303,823.32..389,926.35 rows=534 width=204) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=303,823.03..389,057.76 rows=534 width=225) (actual rows= loops=)

  • Hash Cond: (v.sgr_id = pea2aux.sgr_id)
18. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=301,540.05..386,564.98 rows=534 width=200) (actual rows= loops=)

  • Hash Cond: (pea1.frw_id = fpea1.frw_id)
19. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=301,515.54..386,539.06 rows=534 width=194) (actual rows= loops=)

  • Hash Cond: (v.sgr_id = periferico_1.sgr_id)
20. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=298,601.31..383,622.81 rows=534 width=184) (actual rows= loops=)

  • Hash Cond: ((max(h.his_id)) = ha.his_id)
21. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.43..68,555.38 rows=1,197,179 width=8) (actual rows= loops=)

  • Group Key: h.his_id
22. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_tbgwhistoricoatualizacao on historicoatualizacao h (cost=0.43..50,597.70 rows=1,197,179 width=4) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash (cost=298,594.20..298,594.20 rows=534 width=184) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=296,657.56..298,594.20 rows=534 width=184) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=296,657.13..296,765.08 rows=534 width=174) (actual rows= loops=)

  • Merge Cond: (s.sgr_id = hamax.sgr_id)
26. 0.000 0.000 ↓ 0.0

Sort (cost=266,913.83..266,915.16 rows=534 width=170) (actual rows= loops=)

  • Sort Key: s.sgr_id
27. 0.000 0.000 ↓ 0.0

Gather Merge (cost=265,046.04..266,889.64 rows=534 width=170) (actual rows= loops=)

  • Workers Planned: 1
28. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=264,046.03..265,829.55 rows=314 width=170) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=264,045.73..264,062.40 rows=314 width=191) (actual rows= loops=)

  • Merge Cond: (v.sgr_id = periferico.sgr_id)
30. 0.000 0.000 ↓ 0.0

Sort (cost=261,977.81..261,978.60 rows=314 width=166) (actual rows= loops=)

  • Sort Key: v.sgr_id
31. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=252,271.75..261,964.79 rows=314 width=166) (actual rows= loops=)

  • Hash Cond: (s.frw_id = f.frw_id)
32. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=252,247.24..261,939.45 rows=314 width=134) (actual rows= loops=)

  • Hash Cond: (c.pes_id = p.pes_id)
33. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=252,185.11..261,873.01 rows=314 width=114) (actual rows= loops=)

  • Merge Cond: (s.sgr_id = slowfota.sgr_id)
34. 0.000 0.000 ↓ 0.0

Sort (cost=8,725.58..8,726.37 rows=314 width=76) (actual rows= loops=)

  • Sort Key: s.sgr_id
35. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=11.04..8,712.56 rows=314 width=76) (actual rows= loops=)

  • Hash Cond: (v.pes_idcliente = c.pes_id)
36. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.72..8,699.93 rows=314 width=38) (actual rows= loops=)

  • -> Parallel Seq Scan on veiculo v (cost=0.00..3280.46 (...)
  • Filter: (((sta_nome)::text <> 'INATIVO'::text) AND (...)
  • -> Bitmap Heap Scan on sgr s (cost=2.72..10.52 rows=2 (...)
  • Recheck Cond: ((sgr_id = v.sgr_id) OR (sgr_id = v. (...)
37. 0.000 0.000 ↓ 0.0

BitmapOr (cost=2.72..2.72 rows=2 width=0) (actual rows= loops=)

  • -> Bitmap Index Scan on pk_sgr (cost=0.00. (...)
  • Index Cond: (sgr_id = v.sgr_id)
  • -> Bitmap Index Scan on pk_sgr (cost=0.00. (...)
  • Index Cond: (sgr_id = v.sgr_id2)
38. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=38) (actual rows= loops=)

  • -> Index Scan using pk_tbrhpessoa on pessoa c (cost=0. (...)
  • Index Cond: (pes_id = 1,031)
39. 0.000 0.000 ↓ 0.0

Materialize (cost=243,459.53..253,055.27 rows=35,701 width=38) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=243,459.53..252,966.02 rows=35,701 width=38) (actual rows= loops=)

  • Merge Cond: (slowfota.sgr_id = historicoatualizacao.sgr_id)
41. 0.000 0.000 ↓ 0.0

Unique (cost=75,384.29..77,990.83 rows=35,701 width=34) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Sort (cost=75,384.29..76,687.56 rows=521,307 width=34) (actual rows= loops=)

  • Sort Key: slowfota.sgr_id, slowfota.his_id DESC
  • -> Seq Scan on slowfota (cost=0.00..11626.07 row (...)
43. 0.000 0.000 ↓ 0.0

Unique (cost=168,075.24..174,061.13 rows=20,791 width=16) (actual rows= loops=)

  • -> Sort (cost=168,075.24..171068.19 rows=1,197,179 width= (...)
  • Sort Key: historicoatualizacao.sgr_id, historicoat (...)
  • -> Seq Scan on historicoatualizacao (cost=0.00.. (...)
44. 0.000 0.000 ↓ 0.0

Hash (cost=62.11..62.11 rows=1 width=24) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.57..62.11 rows=1 width=24) (actual rows= loops=)

  • Join Filter: ((g.gru_id = gc.gru_id) OR (g.gru_id = c_1.pes_id))
46. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.57..54.94 rows=1 width=12) (actual rows= loops=)

  • Join Filter: (c_1.pes_id = gc.pes_idcliente)
  • -> Seq Scan on grupocliente gc (cost=0.00..38.31 rows=1 widt (...)
47. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..16.61 rows=1 width=8) (actual rows= loops=)

  • -> Index Only Scan using pk_tbrhpessoa on pessoa p (co (...)
  • Index Cond: (pes_id = 1,031)
  • -> Index Only Scan using pk_tbrhcliente on cliente c_1 (...)
  • Index Cond: (pes_id = 1,031)
  • Filter: (pes_idcliente = 1,031)
48. 0.000 0.000 ↓ 0.0

Seq Scan on grupo g (cost=0.00..4.10 rows=205 width=24) (actual rows= loops=)

  • Filter: gru_isativo
49. 0.000 0.000 ↓ 0.0

Hash (cost=16.45..16.45 rows=645 width=36) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Seq Scan on firmware f (cost=0.00..16.45 rows=645 width=36) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Materialize (cost=2,067.92..2,082.07 rows=376 width=25) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2,067.92..2,077.37 rows=376 width=25) (actual rows= loops=)

  • Group Key: periferico.sgr_id, periferico.itm_grupo, periferico.itm_subgrupo, periferic (...)
53. 0.000 0.000 ↓ 0.0

Sort (cost=2,067.92..2,068.87 rows=379 width=25) (actual rows= loops=)

  • Sort Key: periferico.sgr_id, periferico.itm_subgrupo
54. 0.000 0.000 ↓ 0.0

Seq Scan on periferico (cost=0.00..2,051.69 rows=379 width=25) (actual rows= loops=)

  • Filter: ((itm_subgrupo = ANY ('{5401,5402}'::bpchar[])) AND (itm_grupo = ' (...)
55. 0.000 0.000 ↓ 0.0

Index Scan using periferico_sgr_id_idx on periferico pea1 (cost=0.29..5.62 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (sgr_id = periferico.sgr_id)
  • Filter: ((itm_grupo = periferico.itm_grupo) AND (itm_subgrupo = periferico.itm_subgrupo) AND (per_ (...)
56. 0.000 0.000 ↓ 0.0

Sort (cost=29,743.31..29,795.28 rows=20,791 width=8) (actual rows= loops=)

  • Sort Key: hamax.sgr_id
57. 0.000 0.000 ↓ 0.0

Subquery Scan on hamax (cost=27,836.39..28,252.21 rows=20,791 width=8) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Finalize HashAggregate (cost=27,836.39..28,044.30 rows=20,791 width=8) (actual rows= loops=)

  • Group Key: historicoatualizacao_1.sgr_id
59. 0.000 0.000 ↓ 0.0

Gather (cost=23,262.37..27,628.48 rows=41,582 width=8) (actual rows= loops=)

  • Workers Planned: 2
60. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=22,262.37..22,470.28 rows=20,791 width=8) (actual rows= loops=)

  • Group Key: historicoatualizacao_1.sgr_id
  • -> Parallel Seq Scan on historicoatualizacao historicoatualizacao_1 (cost=0.00..19768.25 r (...)
61. 0.000 0.000 ↓ 0.0

Index Scan using pk_tbgwhistoricoatualizacao on historicoatualizacao ha (cost=0.43..3.43 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (his_id = hamax.his_id)
62. 0.000 0.000 ↓ 0.0

Hash (cost=2,913.13..2,913.13 rows=88 width=14) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2,231.77..2,913.13 rows=88 width=14) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2,231.49..2,887.32 rows=88 width=8) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2,231.20..2,233.40 rows=88 width=25) (actual rows= loops=)

  • Group Key: periferico_1.sgr_id, periferico_1.itm_grupo, periferico_1.itm_subgrupo, periferico_1.per_sensor
66. 0.000 0.000 ↓ 0.0

Sort (cost=2,231.20..2,231.42 rows=88 width=25) (actual rows= loops=)

  • Sort Key: periferico_1.sgr_id, periferico_1.itm_subgrupo
67. 0.000 0.000 ↓ 0.0

Seq Scan on periferico periferico_1 (cost=0.00..2,228.36 rows=88 width=25) (actual rows= loops=)

  • Filter: ((itm_grupo = 'PER'::bpchar) AND (per_sensor = 3) AND (itm_subgrupo = ANY ('{5401,5402,5408,5422}'::bp (...)
68. 0.000 0.000 ↓ 0.0

Index Scan using periferico_sgr_id_idx on periferico pea3 (cost=0.29..7.41 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (sgr_id = periferico_1.sgr_id)
  • Filter: ((itm_grupo = periferico_1.itm_grupo) AND (itm_subgrupo = periferico_1.itm_subgrupo) AND (per_sensor = periferico_ (...)
69. 0.000 0.000 ↓ 0.0

Index Scan using pk_tbpdfirmware on firmware fpea3 (cost=0.28..0.29 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (pea3.frw_id = frw_id)
70. 0.000 0.000 ↓ 0.0

Hash (cost=16.45..16.45 rows=645 width=14) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Seq Scan on firmware fpea1 (cost=0.00..16.45 rows=645 width=14) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash (cost=2,243.99..2,243.99 rows=3,119 width=25) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Subquery Scan on pea2aux (cost=2,181.61..2,243.99 rows=3,119 width=25) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,181.61..2,212.80 rows=3,119 width=25) (actual rows= loops=)

  • Group Key: periferico_2.sgr_id, periferico_2.itm_grupo, periferico_2.itm_subgrupo, periferico_2.per_sensor
75. 0.000 0.000 ↓ 0.0

Seq Scan on periferico periferico_2 (cost=0.00..2,140.03 rows=3,327 width=25) (actual rows= loops=)

  • Filter: ((itm_grupo = 'PER'::bpchar) AND (per_sensor = 2) AND (itm_subgrupo = ANY ('{5401,5402,5423}'::bpchar[])))
76. 0.000 0.000 ↓ 0.0

Index Scan using periferico_sgr_id_idx on periferico pea2 (cost=0.29..1.62 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (sgr_id = pea2aux.sgr_id)
  • Filter: ((itm_grupo = pea2aux.itm_grupo) AND (itm_subgrupo = pea2aux.itm_subgrupo) AND (per_sensor = pea2aux.per_sensor) AND (per_datahora_poweron = pea2aux.p (...)
77. 0.000 0.000 ↓ 0.0

Hash (cost=16.45..16.45 rows=645 width=14) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on firmware fpea2 (cost=0.00..16.45 rows=645 width=14) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Hash (cost=2,199.22..2,199.22 rows=7,277 width=12) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Subquery Scan on fdceaux (cost=2,053.68..2,199.22 rows=7,277 width=12) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,053.68..2,126.45 rows=7,277 width=12) (actual rows= loops=)

  • Group Key: per_1.sgr_id
82. 0.000 0.000 ↓ 0.0

Hash Join (cost=24.51..2,010.62 rows=8,612 width=12) (actual rows= loops=)

  • Hash Cond: (per_1.frw_id = f_2.frw_id)
83. 0.000 0.000 ↓ 0.0

Seq Scan on periferico per_1 (cost=0.00..1,963.36 rows=8,612 width=16) (actual rows= loops=)

  • Filter: ((itm_grupo = 'PER'::bpchar) AND (itm_subgrupo = ANY ('{5424,5430,5431}'::bpchar[])))
84. 0.000 0.000 ↓ 0.0

Hash (cost=16.45..16.45 rows=645 width=4) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Seq Scan on firmware f_2 (cost=0.00..16.45 rows=645 width=4) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..0.66 rows=1 width=22) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Index Scan using periferico_sgr_id_idx on periferico per (cost=0.29..0.36 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (sgr_id = s.sgr_id)
  • Filter: ((itm_grupo = 'PER'::bpchar) AND (itm_subgrupo = ANY ('{5424,5430,5431}'::bpchar[])))
88. 0.000 0.000 ↓ 0.0

Index Scan using pk_tbpdfirmware on firmware f_1 (cost=0.28..0.30 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (frw_id = per.frw_id)
89. 0.000 0.000 ↓ 0.0

Hash (cost=1,928.92..1,928.92 rows=960 width=12) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Subquery Scan on ftecaux (cost=1,909.72..1,928.92 rows=960 width=12) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,909.72..1,919.32 rows=960 width=12) (actual rows= loops=)

  • Group Key: tec_2.sgr_id
92. 0.000 0.000 ↓ 0.0

Hash Join (cost=27.19..1,904.92 rows=960 width=12) (actual rows= loops=)

  • Hash Cond: (tec_2.frw_id = ftec_2.frw_id)
93. 0.000 0.000 ↓ 0.0

Seq Scan on periferico tec_2 (cost=0.00..1,875.02 rows=1,030 width=16) (actual rows= loops=)

  • Filter: ((itm_grupo = 'TCL'::bpchar) AND (itm_subgrupo = '2803'::bpchar))
94. 0.000 0.000 ↓ 0.0

Hash (cost=19.67..19.67 rows=601 width=4) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Seq Scan on firmware ftec_2 (cost=0.00..19.67 rows=601 width=4) (actual rows= loops=)

  • Filter: (((frw_rotulo)::text !~ 'MFH'::text) AND ((frw_rotulo)::text !~ 'TSR'::text))
96. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..0.72 rows=1 width=26) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Index Scan using periferico_sgr_id_idx on periferico tec (cost=0.29..0.36 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (sgr_id = s.sgr_id)
  • Filter: ((itm_grupo = 'TCL'::bpchar) AND (itm_subgrupo = '2803'::bpchar))
98. 0.000 0.000 ↓ 0.0

Index Scan using pk_tbpdfirmware on firmware ftec (cost=0.28..0.35 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (frw_id = tec.frw_id)
  • Filter: (((frw_rotulo)::text !~ 'MFH'::text) AND ((frw_rotulo)::text !~ 'TSR'::text))
99. 0.000 0.000 ↓ 0.0

Hash (cost=1,898.48..1,898.48 rows=43 width=12) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Subquery Scan on finsaux (cost=1,897.30..1,898.48 rows=43 width=12) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,897.30..1,898.05 rows=43 width=12) (actual rows= loops=)

  • Group Key: tec_3.sgr_id
102. 0.000 0.000 ↓ 0.0

Sort (cost=1,897.30..1,897.41 rows=43 width=12) (actual rows= loops=)

  • Sort Key: tec_3.sgr_id
103. 0.000 0.000 ↓ 0.0

Hash Join (cost=18.40..1,896.13 rows=43 width=12) (actual rows= loops=)

  • Hash Cond: (tec_3.frw_id = ftec_3.frw_id)
104. 0.000 0.000 ↓ 0.0

Seq Scan on periferico tec_3 (cost=0.00..1,875.02 rows=1,030 width=16) (actual rows= loops=)

  • Filter: ((itm_grupo = 'TCL'::bpchar) AND (itm_subgrupo = '2803'::bpchar))
105. 0.000 0.000 ↓ 0.0

Hash (cost=18.06..18.06 rows=27 width=4) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Seq Scan on firmware ftec_3 (cost=0.00..18.06 rows=27 width=4) (actual rows= loops=)

  • Filter: ((frw_rotulo)::text ~ 'MFH'::text)
107. 0.000 0.000 ↓ 0.0

Index Scan using bd_modulos_sgr_id_key on bd_modulos bm (cost=0.29..0.41 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sgr_id = s.sgr_id)
108. 0.000 0.000 ↓ 0.0

Index Scan using itemveiculo_vei_id_idx on itemveiculo ivpainel (cost=0.42..19.64 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (vei_id = v.vei_id)
  • Filter: ((itm_grupo = 'ATT'::bpchar) AND (itm_subgrupo = '5033'::bpchar))
109. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..0.72 rows=1 width=22) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Index Scan using periferico_sgr_id_idx on periferico tec_1 (cost=0.29..0.36 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (sgr_id = s.sgr_id)
  • Filter: ((itm_grupo = 'TCL'::bpchar) AND (itm_subgrupo = '2803'::bpchar))
111. 0.000 0.000 ↓ 0.0

Index Scan using pk_tbpdfirmware on firmware ftec_1 (cost=0.28..0.35 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (frw_id = tec_1.frw_id)
  • Filter: ((frw_rotulo)::text ~ 'MFH'::text)
112. 0.000 0.000 ↓ 0.0

Index Scan using itemveiculo_vei_id_idx on itemveiculo ivbloq (cost=0.42..19.65 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (vei_id = v.vei_id)
  • Filter: ((itm_grupo = 'ATT'::bpchar) AND (itm_subgrupo = ANY ('{5000,5075,5040}'::bpchar[])))
113. 0.000 0.000 ↓ 0.0

Index Scan using pk_tbgwsgragendamento on sgragendamento ag (cost=0.43..2.75 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (sgr_id = s.sgr_id)
  • Filter: (NOT age_iniciado)
114. 0.000 0.000 ↓ 0.0

Hash (cost=49,341.55..49,341.55 rows=24,213 width=12) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Subquery Scan on aga (cost=48,857.29..49,341.55 rows=24,213 width=12) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Finalize HashAggregate (cost=48,857.29..49,099.42 rows=24,213 width=12) (actual rows= loops=)

  • Group Key: s_1.sgr_id
117. 0.000 0.000 ↓ 0.0

Gather (cost=43,530.43..48,615.16 rows=48,426 width=12) (actual rows= loops=)

  • Workers Planned: 2
118. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=42,530.43..42,772.56 rows=24,213 width=12) (actual rows= loops=)

  • Group Key: s_1.sgr_id
119. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,546.34..38,355.38 rows=835,010 width=12) (actual rows= loops=)

  • Hash Cond: (s_1.age_id = a.age_id)
120. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on sgragendamento s_1 (cost=0.00..21,115.10 rows=835,010 width=8) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Hash (cost=4,065.93..4,065.93 rows=200,193 width=12) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Seq Scan on agendamentoatualizacao a (cost=0.00..4,065.93 rows=200,193 width=12) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Hash (cost=13.58..13.58 rows=858 width=4) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Seq Scan on bloqueioatualizacaomodulo bloqsgr (cost=0.00..13.58 rows=858 width=4) (actual rows= loops=)