explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5v2A

Settings
# exclusive inclusive rows x rows loops node
1. 6.152 3,193.326 ↑ 1.6 762 1

Sort (cost=414,155.51..414,158.57 rows=1,225 width=801) (actual time=3,193.287..3,193.326 rows=762 loops=1)

  • Sort Key: rd.dt_inicio_terminal
  • Sort Method: quicksort Memory: 403kB
2. 2,664.649 3,187.174 ↑ 1.6 762 1

GroupAggregate (cost=10,311.70..414,092.68 rows=1,225 width=801) (actual time=84.919..3,187.174 rows=762 loops=1)

  • Group Key: mc.nm_modelo, ve.cd_identificador, rd.id_rd, tb_sos.qtd_sos, tb_sos.tempo_total_sos, tb_refeicao.qtd_refeicao, tb_refeicao.tempo_total_refeicao
3. 15.676 84.741 ↓ 5.1 6,299 1

Sort (cost=10,311.70..10,314.77 rows=1,225 width=5,269) (actual time=82.965..84.741 rows=6,299 loops=1)

  • Sort Key: mc.nm_modelo, ve.cd_identificador, rd.id_rd, tb_sos.qtd_sos, tb_sos.tempo_total_sos, tb_refeicao.qtd_refeicao, tb_refeicao.tempo_total_refeicao
  • Sort Method: quicksort Memory: 3440kB
4. 1.451 69.065 ↓ 5.1 6,299 1

Nested Loop (cost=6,954.66..10,248.87 rows=1,225 width=5,269) (actual time=52.660..69.065 rows=6,299 loops=1)

5. 0.749 59.078 ↓ 3.6 2,134 1

Nested Loop (cost=6,954.22..9,756.83 rows=592 width=582) (actual time=52.644..59.078 rows=2,134 loops=1)

6. 0.286 56.043 ↓ 1.7 762 1

Hash Left Join (cost=6,953.79..8,445.97 rows=457 width=576) (actual time=52.633..56.043 rows=762 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_refeicao.id_rd)::integer)
7. 0.712 32.096 ↓ 1.7 762 1

Nested Loop (cost=3,477.42..4,963.83 rows=457 width=552) (actual time=28.960..32.096 rows=762 loops=1)

8. 0.211 30.622 ↓ 1.7 762 1

Hash Left Join (cost=3,477.14..4,598.73 rows=457 width=545) (actual time=28.951..30.622 rows=762 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_sos.id_rd)::integer)
9. 0.128 1.505 ↓ 1.7 762 1

Nested Loop (cost=0.43..1,116.25 rows=457 width=505) (actual time=0.035..1.505 rows=762 loops=1)

10. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on tb_modelo_coleta mc (cost=0.00..1.29 rows=1 width=23) (actual time=0.006..0.010 rows=1 loops=1)

  • Filter: ((id_modelo_coleta)::integer = 1)
  • Rows Removed by Filter: 22
11. 1.367 1.367 ↓ 1.7 762 1

Index Scan using ind_tb_rd_idfilial_dtini_idveiculo_idrd on tb_rd rd (cost=0.43..1,110.40 rows=457 width=490) (actual time=0.028..1.367 rows=762 loops=1)

  • Index Cond: (((id_filial)::integer = 47) AND (dt_inicio_terminal >= '2018-12-01 00:00:00-02'::timestamp with time zone) AND (dt_inicio_terminal <= '2018-12-31 23:59:59-02'::timestamp with time zone))
  • Filter: ((id_modelo_coleta)::integer = 1)
  • Rows Removed by Filter: 806
12. 0.016 28.906 ↓ 44.0 44 1

Hash (cost=3,476.69..3,476.69 rows=1 width=44) (actual time=28.906..28.906 rows=44 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
13. 0.007 28.890 ↓ 44.0 44 1

Subquery Scan on tb_sos (cost=3,476.66..3,476.69 rows=1 width=44) (actual time=28.808..28.890 rows=44 loops=1)

14. 0.094 28.883 ↓ 44.0 44 1

GroupAggregate (cost=3,476.66..3,476.68 rows=1 width=44) (actual time=28.807..28.883 rows=44 loops=1)

  • Group Key: rd_1.id_rd
15. 0.040 28.789 ↓ 49.0 49 1

Sort (cost=3,476.66..3,476.66 rows=1 width=20) (actual time=28.785..28.789 rows=49 loops=1)

  • Sort Key: rd_1.id_rd
  • Sort Method: quicksort Memory: 28kB
16. 0.064 28.749 ↓ 49.0 49 1

Nested Loop (cost=2.00..3,476.65 rows=1 width=20) (actual time=1.664..28.749 rows=49 loops=1)

17. 0.361 28.587 ↓ 49.0 49 1

Nested Loop (cost=1.72..3,476.26 rows=1 width=24) (actual time=1.655..28.587 rows=49 loops=1)

  • Join Filter: ((o.id_modelo_ocorrencia)::integer = (mo.id_modelo_ocorrencia)::integer)
  • Rows Removed by Join Filter: 2959
18. 0.010 0.010 ↑ 1.0 8 1

Seq Scan on tb_modelo_ocorrencia mo (cost=0.00..1.25 rows=8 width=4) (actual time=0.004..0.010 rows=8 loops=1)

  • Filter: ((tp_ocorrencia)::smallint = 0)
  • Rows Removed by Filter: 12
19. 0.324 28.216 ↓ 125.3 376 8

Materialize (cost=1.72..3,474.66 rows=3 width=28) (actual time=0.019..3.527 rows=376 loops=8)

20. 0.000 27.892 ↓ 125.3 376 1

Nested Loop (cost=1.72..3,474.64 rows=3 width=28) (actual time=0.148..27.892 rows=376 loops=1)

21. 2.261 16.327 ↓ 5.1 6,299 1

Nested Loop (cost=1.30..2,913.29 rows=1,224 width=12) (actual time=0.029..16.327 rows=6,299 loops=1)

22. 0.248 5.530 ↓ 3.6 2,134 1

Nested Loop (cost=0.86..2,421.25 rows=592 width=12) (actual time=0.019..5.530 rows=2,134 loops=1)

23. 1.472 1.472 ↓ 1.7 762 1

Index Scan using ind_tb_rd_idfilial_dtini_idveiculo_idrd on tb_rd rd_1 (cost=0.43..1,110.40 rows=457 width=8) (actual time=0.010..1.472 rows=762 loops=1)

  • Index Cond: (((id_filial)::integer = 47) AND (dt_inicio_terminal >= '2018-12-01 00:00:00-02'::timestamp with time zone) AND (dt_inicio_terminal <= '2018-12-31 23:59:59-02'::timestamp with time zone))
  • Filter: ((id_modelo_coleta)::integer = 1)
  • Rows Removed by Filter: 806
24. 3.810 3.810 ↓ 1.5 3 762

Index Scan using ix01f_tb_viagem on tb_viagem v1 (cost=0.43..2.85 rows=2 width=8) (actual time=0.003..0.005 rows=3 loops=762)

  • Index Cond: ((id_rd)::integer = (rd_1.id_rd)::integer)
25. 8.536 8.536 ↑ 4.3 3 2,134

Index Scan using ix01f_tb_trecho_viagem on tb_trecho_viagem tv1 (cost=0.43..0.70 rows=13 width=8) (actual time=0.003..0.004 rows=3 loops=2,134)

  • Index Cond: ((id_viagem)::integer = (v1.id_viagem)::integer)
26. 12.598 12.598 ↓ 0.0 0 6,299

Index Scan using ix02f_tb_ocorrencia on tb_ocorrencia o (cost=0.42..0.45 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=6,299)

  • Index Cond: ((id_trecho_viagem)::integer = (tv1.id_trecho_viagem)::integer)
  • Filter: ((dt_inicio >= '2018-12-01 00:00:00-02'::timestamp with time zone) AND (dt_inicio <= '2018-12-31 23:59:59-02'::timestamp with time zone))
27. 0.098 0.098 ↑ 1.0 1 49

Index Only Scan using pk00_tb_veiculo on tb_veiculo ve_1 (cost=0.28..0.39 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=49)

  • Index Cond: (id_veiculo = (rd_1.id_veiculo)::integer)
  • Heap Fetches: 27
28. 0.762 0.762 ↑ 1.0 1 762

Index Scan using pk00_tb_veiculo on tb_veiculo ve (cost=0.28..0.80 rows=1 width=15) (actual time=0.001..0.001 rows=1 loops=762)

  • Index Cond: ((id_veiculo)::integer = (rd.id_veiculo)::integer)
29. 0.053 23.661 ↓ 316.0 316 1

Hash (cost=3,476.36..3,476.36 rows=1 width=28) (actual time=23.661..23.661 rows=316 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
30. 0.028 23.608 ↓ 316.0 316 1

Subquery Scan on tb_refeicao (cost=3,476.33..3,476.36 rows=1 width=28) (actual time=23.443..23.608 rows=316 loops=1)

31. 0.136 23.580 ↓ 316.0 316 1

GroupAggregate (cost=3,476.33..3,476.35 rows=1 width=28) (actual time=23.442..23.580 rows=316 loops=1)

  • Group Key: rd_2.id_rd
32. 0.131 23.444 ↓ 320.0 320 1

Sort (cost=3,476.33..3,476.33 rows=1 width=20) (actual time=23.430..23.444 rows=320 loops=1)

  • Sort Key: rd_2.id_rd
  • Sort Method: quicksort Memory: 50kB
33. 0.306 23.313 ↓ 320.0 320 1

Nested Loop (cost=2.00..3,476.32 rows=1 width=20) (actual time=0.143..23.313 rows=320 loops=1)

34. 0.080 22.687 ↓ 320.0 320 1

Nested Loop (cost=1.72..3,475.93 rows=1 width=24) (actual time=0.130..22.687 rows=320 loops=1)

  • Join Filter: ((o_1.id_modelo_ocorrencia)::integer = (mo_1.id_modelo_ocorrencia)::integer)
  • Rows Removed by Join Filter: 56
35. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on tb_modelo_ocorrencia mo_1 (cost=0.00..1.25 rows=1 width=4) (actual time=0.004..0.006 rows=1 loops=1)

  • Filter: ((tp_ocorrencia)::smallint = 2)
  • Rows Removed by Filter: 19
36. 3.872 22.601 ↓ 125.3 376 1

Nested Loop (cost=1.72..3,474.64 rows=3 width=28) (actual time=0.125..22.601 rows=376 loops=1)

37. 1.896 12.430 ↓ 5.1 6,299 1

Nested Loop (cost=1.30..2,913.29 rows=1,224 width=12) (actual time=0.031..12.430 rows=6,299 loops=1)

38. 0.800 4.132 ↓ 3.6 2,134 1

Nested Loop (cost=0.86..2,421.25 rows=592 width=12) (actual time=0.024..4.132 rows=2,134 loops=1)

39. 1.046 1.046 ↓ 1.7 762 1

Index Scan using ind_tb_rd_idfilial_dtini_idveiculo_idrd on tb_rd rd_2 (cost=0.43..1,110.40 rows=457 width=8) (actual time=0.014..1.046 rows=762 loops=1)

  • Index Cond: (((id_filial)::integer = 47) AND (dt_inicio_terminal >= '2018-12-01 00:00:00-02'::timestamp with time zone) AND (dt_inicio_terminal <= '2018-12-31 23:59:59-02'::timestamp with time zone))
  • Filter: ((id_modelo_coleta)::integer = 1)
  • Rows Removed by Filter: 806
40. 2.286 2.286 ↓ 1.5 3 762

Index Scan using ix01f_tb_viagem on tb_viagem v1_1 (cost=0.43..2.85 rows=2 width=8) (actual time=0.002..0.003 rows=3 loops=762)

  • Index Cond: ((id_rd)::integer = (rd_2.id_rd)::integer)
41. 6.402 6.402 ↑ 4.3 3 2,134

Index Scan using ix01f_tb_trecho_viagem on tb_trecho_viagem tv1_1 (cost=0.43..0.70 rows=13 width=8) (actual time=0.002..0.003 rows=3 loops=2,134)

  • Index Cond: ((id_viagem)::integer = (v1_1.id_viagem)::integer)
42. 6.299 6.299 ↓ 0.0 0 6,299

Index Scan using ix02f_tb_ocorrencia on tb_ocorrencia o_1 (cost=0.42..0.45 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=6,299)

  • Index Cond: ((id_trecho_viagem)::integer = (tv1_1.id_trecho_viagem)::integer)
  • Filter: ((dt_inicio >= '2018-12-01 00:00:00-02'::timestamp with time zone) AND (dt_inicio <= '2018-12-31 23:59:59-02'::timestamp with time zone))
43. 0.320 0.320 ↑ 1.0 1 320

Index Only Scan using pk00_tb_veiculo on tb_veiculo ve_2 (cost=0.28..0.39 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=320)

  • Index Cond: (id_veiculo = (rd_2.id_veiculo)::integer)
  • Heap Fetches: 244
44. 2.286 2.286 ↓ 1.5 3 762

Index Scan using ix01f_tb_viagem on tb_viagem v (cost=0.43..2.85 rows=2 width=10) (actual time=0.002..0.003 rows=3 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
45. 8.536 8.536 ↑ 4.3 3 2,134

Index Scan using ix01f_tb_trecho_viagem on tb_trecho_viagem tv (cost=0.43..0.70 rows=13 width=4,695) (actual time=0.002..0.004 rows=3 loops=2,134)

  • Index Cond: ((id_viagem)::integer = (v.id_viagem)::integer)
46.          

SubPlan (forGroupAggregate)

47. 13.716 370.332 ↑ 1.0 1 762

Aggregate (cost=242.66..242.67 rows=1 width=16) (actual time=0.486..0.486 rows=1 loops=762)

48. 6.096 356.616 ↑ 2.2 79 762

Append (cost=22.08..241.79 rows=174 width=16) (actual time=0.364..0.468 rows=79 loops=762)

49. 77.724 345.948 ↓ 1.3 79 762

Bitmap Heap Scan on tb_parada pa (cost=22.08..96.93 rows=62 width=16) (actual time=0.362..0.454 rows=79 loops=762)

  • Recheck Cond: ((id_rd)::integer = (rd.id_rd)::integer)
  • Heap Blocks: exact=53663
50. 268.224 268.224 ↓ 1.3 79 762

Bitmap Index Scan on ind_tb_parada_idrd_gin (cost=0.00..22.06 rows=62 width=0) (actual time=0.352..0.352 rows=79 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
51. 0.762 4.572 ↓ 0.0 0 762

Bitmap Heap Scan on tb_parada_until_201810 pa_1 (cost=9.27..144.86 rows=112 width=16) (actual time=0.006..0.006 rows=0 loops=762)

  • Recheck Cond: ((id_rd)::integer = (rd.id_rd)::integer)
52. 3.810 3.810 ↓ 0.0 0 762

Bitmap Index Scan on ind_tb_tbparadau201810_idrd (cost=0.00..9.24 rows=112 width=0) (actual time=0.005..0.005 rows=0 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
53. 3.810 20.574 ↑ 1.0 1 762

Limit (cost=12.47..12.48 rows=1 width=40) (actual time=0.027..0.027 rows=1 loops=762)

54. 3.048 16.764 ↑ 2.0 1 762

Sort (cost=12.47..12.48 rows=2 width=40) (actual time=0.022..0.022 rows=1 loops=762)

  • Sort Key: eq.dt_inicio
  • Sort Method: quicksort Memory: 25kB
55. 0.826 13.716 ↑ 2.0 1 762

Nested Loop Left Join (cost=1.15..12.46 rows=2 width=40) (actual time=0.016..0.018 rows=1 loops=762)

56. 1.748 11.430 ↑ 2.0 1 762

Nested Loop Left Join (cost=0.86..11.85 rows=2 width=12) (actual time=0.013..0.015 rows=1 loops=762)

57. 4.572 4.572 ↑ 2.0 1 762

Index Scan using ix03f_tb_equipe on tb_equipe eq (cost=0.43..2.86 rows=2 width=12) (actual time=0.006..0.006 rows=1 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
58. 5.110 5.110 ↑ 1.0 1 730

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1 (cost=0.43..4.49 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=730)

  • Index Cond: ((eq.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 1)
  • Rows Removed by Filter: 3
59. 1.460 1.460 ↑ 1.0 1 730

Index Scan using pk00_tb_coletor on tb_coletor c1 (cost=0.29..0.31 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=730)

  • Index Cond: ((ec1.id_coletor)::integer = (id_coletor)::integer)
60. 0.762 11.430 ↑ 1.0 1 762

Limit (cost=12.47..12.48 rows=1 width=40) (actual time=0.015..0.015 rows=1 loops=762)

61. 3.048 10.668 ↑ 2.0 1 762

Sort (cost=12.47..12.48 rows=2 width=40) (actual time=0.014..0.014 rows=1 loops=762)

  • Sort Key: eq_1.dt_inicio
  • Sort Method: quicksort Memory: 25kB
62. 0.826 7.620 ↑ 2.0 1 762

Nested Loop Left Join (cost=1.15..12.46 rows=2 width=40) (actual time=0.009..0.010 rows=1 loops=762)

63. 0.890 5.334 ↑ 2.0 1 762

Nested Loop Left Join (cost=0.86..11.85 rows=2 width=12) (actual time=0.006..0.007 rows=1 loops=762)

64. 1.524 1.524 ↑ 2.0 1 762

Index Scan using ix03f_tb_equipe on tb_equipe eq_1 (cost=0.43..2.86 rows=2 width=12) (actual time=0.002..0.002 rows=1 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
65. 2.920 2.920 ↑ 1.0 1 730

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_1 (cost=0.43..4.49 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=730)

  • Index Cond: ((eq_1.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 2)
  • Rows Removed by Filter: 3
66. 1.460 1.460 ↑ 1.0 1 730

Index Scan using pk00_tb_coletor on tb_coletor c1_1 (cost=0.29..0.31 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=730)

  • Index Cond: ((ec1_1.id_coletor)::integer = (id_coletor)::integer)
67. 0.000 8.382 ↑ 1.0 1 762

Limit (cost=12.47..12.48 rows=1 width=40) (actual time=0.011..0.011 rows=1 loops=762)

68. 1.524 8.382 ↑ 2.0 1 762

Sort (cost=12.47..12.48 rows=2 width=40) (actual time=0.011..0.011 rows=1 loops=762)

  • Sort Key: eq_2.dt_inicio
  • Sort Method: quicksort Memory: 25kB
69. 0.826 6.858 ↑ 2.0 1 762

Nested Loop Left Join (cost=1.15..12.46 rows=2 width=40) (actual time=0.008..0.009 rows=1 loops=762)

70. 0.858 4.572 ↑ 2.0 1 762

Nested Loop Left Join (cost=0.86..11.85 rows=2 width=12) (actual time=0.005..0.006 rows=1 loops=762)

71. 1.524 1.524 ↑ 2.0 1 762

Index Scan using ix03f_tb_equipe on tb_equipe eq_2 (cost=0.43..2.86 rows=2 width=12) (actual time=0.002..0.002 rows=1 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
72. 2.190 2.190 ↑ 1.0 1 730

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_2 (cost=0.43..4.49 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=730)

  • Index Cond: ((eq_2.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 3)
  • Rows Removed by Filter: 3
73. 1.460 1.460 ↑ 1.0 1 730

Index Scan using pk00_tb_coletor on tb_coletor c1_2 (cost=0.29..0.31 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=730)

  • Index Cond: ((ec1_2.id_coletor)::integer = (id_coletor)::integer)
74. 0.762 8.382 ↑ 1.0 1 762

Limit (cost=12.47..12.48 rows=1 width=40) (actual time=0.011..0.011 rows=1 loops=762)

75. 0.762 7.620 ↑ 2.0 1 762

Sort (cost=12.47..12.48 rows=2 width=40) (actual time=0.010..0.010 rows=1 loops=762)

  • Sort Key: eq_3.dt_inicio
  • Sort Method: quicksort Memory: 25kB
76. 0.826 6.858 ↑ 2.0 1 762

Nested Loop Left Join (cost=1.15..12.46 rows=2 width=40) (actual time=0.008..0.009 rows=1 loops=762)

77. 0.858 4.572 ↑ 2.0 1 762

Nested Loop Left Join (cost=0.86..11.85 rows=2 width=12) (actual time=0.005..0.006 rows=1 loops=762)

78. 1.524 1.524 ↑ 2.0 1 762

Index Scan using ix03f_tb_equipe on tb_equipe eq_3 (cost=0.43..2.86 rows=2 width=12) (actual time=0.002..0.002 rows=1 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
79. 2.190 2.190 ↑ 1.0 1 730

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_3 (cost=0.43..4.49 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=730)

  • Index Cond: ((eq_3.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 4)
  • Rows Removed by Filter: 3
80. 1.460 1.460 ↑ 1.0 1 730

Index Scan using pk00_tb_coletor on tb_coletor c1_3 (cost=0.29..0.31 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=730)

  • Index Cond: ((ec1_3.id_coletor)::integer = (id_coletor)::integer)
81. 0.000 6.858 ↑ 1.0 1 762

Limit (cost=12.48..12.48 rows=1 width=40) (actual time=0.009..0.009 rows=1 loops=762)

82. 1.524 6.858 ↑ 2.0 1 762

Sort (cost=12.48..12.48 rows=2 width=40) (actual time=0.009..0.009 rows=1 loops=762)

  • Sort Key: eq_4.dt_inicio
  • Sort Method: quicksort Memory: 25kB
83. 0.762 5.334 ↑ 2.0 1 762

Nested Loop Left Join (cost=1.15..12.47 rows=2 width=40) (actual time=0.007..0.007 rows=1 loops=762)

84. 0.858 4.572 ↑ 2.0 1 762

Nested Loop Left Join (cost=0.86..11.85 rows=2 width=12) (actual time=0.006..0.006 rows=1 loops=762)

85. 1.524 1.524 ↑ 2.0 1 762

Index Scan using ix03f_tb_equipe on tb_equipe eq_4 (cost=0.43..2.86 rows=2 width=12) (actual time=0.002..0.002 rows=1 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
86. 2.190 2.190 ↓ 0.0 0 730

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_4 (cost=0.43..4.49 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=730)

  • Index Cond: ((eq_4.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 5)
  • Rows Removed by Filter: 4
87. 0.000 0.000 ↓ 0.0 0 730

Index Scan using pk00_tb_coletor on tb_coletor c1_4 (cost=0.29..0.31 rows=1 width=28) (actual time=0.000..0.000 rows=0 loops=730)

  • Index Cond: ((ec1_4.id_coletor)::integer = (id_coletor)::integer)
88. 0.762 2.286 ↓ 0.0 0 762

Limit (cost=0.43..2.86 rows=1 width=1) (actual time=0.003..0.003 rows=0 loops=762)

89. 1.524 1.524 ↓ 0.0 0 762

Index Scan using ix03f_tb_equipe on tb_equipe eq_5 (cost=0.43..2.86 rows=1 width=1) (actual time=0.002..0.002 rows=0 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
  • Filter: (NOT vf_inicial)
  • Rows Removed by Filter: 1
90. 0.000 2.286 ↓ 0.0 0 762

Limit (cost=0.42..2.84 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=762)

91. 2.286 2.286 ↓ 0.0 0 762

Index Scan using ix00f_tb_abastecimento on tb_abastecimento (cost=0.42..2.84 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
92. 0.762 1.524 ↓ 0.0 0 762

Limit (cost=0.42..2.84 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=762)

93. 0.762 0.762 ↓ 0.0 0 762

Index Scan using ix00f_tb_abastecimento on tb_abastecimento tb_abastecimento_1 (cost=0.42..2.84 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=762)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
94. 0.008 0.008 ↑ 1.0 1 1

Index Scan using pk00_tb_geometria on tb_geometria g_4 (cost=0.43..2.85 rows=1 width=44) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
95. 0.006 0.006 ↑ 1.0 1 1

Index Scan using pk00_tb_geometria on tb_geometria g_3 (cost=0.43..2.85 rows=1 width=44) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
96. 0.316 0.316 ↑ 1.0 1 79

Index Scan using pk00_tb_geometria on tb_geometria g_2 (cost=0.43..2.85 rows=1 width=44) (actual time=0.004..0.004 rows=1 loops=79)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
97. 2.572 2.572 ↑ 1.0 1 643

Index Scan using pk00_tb_geometria on tb_geometria g_1 (cost=0.43..2.85 rows=1 width=44) (actual time=0.004..0.004 rows=1 loops=643)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
98. 2.828 2.828 ↑ 1.0 1 707

Index Scan using pk00_tb_geometria on tb_geometria g (cost=0.43..2.85 rows=1 width=44) (actual time=0.004..0.004 rows=1 loops=707)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)