explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vtFk7

Settings
# exclusive inclusive rows x rows loops node
1. 25.449 192,160.850 ↑ 2.7 8,681 1

Sort (cost=11,648,933.20..11,648,991.60 rows=23,358 width=797) (actual time=192,159.787..192,160.850 rows=8,681 loops=1)

  • Sort Key: rd.dt_inicio_terminal
  • Sort Method: quicksort Memory: 3,519kB
2. 99,811.949 192,135.401 ↑ 2.7 8,681 1

GroupAggregate (cost=130,561.79..11,647,238.39 rows=23,358 width=797) (actual time=49,806.188..192,135.401 rows=8,681 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. 808.153 49,720.392 ↓ 1.7 39,341 1

Sort (cost=130,561.79..130,620.19 rows=23,358 width=623) (actual time=49,702.916..49,720.392 rows=39,341 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: 23,809kB
4. 67.476 48,912.239 ↓ 1.7 39,341 1

Nested Loop (cost=88,090.60..128,866.98 rows=23,358 width=623) (actual time=47,502.314..48,912.239 rows=39,341 loops=1)

5. 21.712 48,372.893 ↓ 1.4 15,729 1

Nested Loop (cost=88,090.17..116,158.37 rows=11,290 width=570) (actual time=47,502.275..48,372.893 rows=15,729 loops=1)

6. 29.337 48,186.242 ↓ 1.0 8,681 1

Hash Left Join (cost=88,089.74..94,353.83 rows=8,448 width=564) (actual time=47,502.250..48,186.242 rows=8,681 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_refeicao.id_rd)::integer)
7. 36.340 41,070.073 ↓ 1.0 8,681 1

Hash Left Join (cost=49,177.24..55,419.16 rows=8,448 width=540) (actual time=40,415.402..41,070.073 rows=8,681 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_sos.id_rd)::integer)
8. 4.556 667.370 ↓ 1.0 8,681 1

Hash Join (cost=423.16..6,642.90 rows=8,448 width=500) (actual time=49.018..667.370 rows=8,681 loops=1)

  • Hash Cond: ((rd.id_veiculo)::integer = (ve.id_veiculo)::integer)
9. 3.414 629.674 ↓ 1.0 8,681 1

Hash Join (cost=2.00..6,199.55 rows=8,448 width=494) (actual time=15.793..629.674 rows=8,681 loops=1)

  • Hash Cond: ((rd.id_modelo_coleta)::integer = (mc.id_modelo_coleta)::integer)
10. 626.239 626.239 ↓ 1.0 8,681 1

Index Scan using ind_tb_rd_idfilial_dtini_idveiculo_idrd on tb_rd rd (cost=0.43..6,172.05 rows=8,448 width=478) (actual time=15.746..626.239 rows=8,681 loops=1)

  • Index Cond: (((id_filial)::integer = 55) AND (dt_inicio_terminal >= '2020-01-20 00:00:00-03'::timestamp with time zone) AND (dt_inicio_terminal <= '2020-02-19 23:59:59-03'::timestamp with time zone))
11. 0.010 0.021 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=24) (actual time=0.021..0.021 rows=25 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
12. 0.011 0.011 ↑ 1.0 25 1

Seq Scan on tb_modelo_coleta mc (cost=0.00..1.25 rows=25 width=24) (actual time=0.007..0.011 rows=25 loops=1)

13. 29.164 33.140 ↑ 1.0 10,274 1

Hash (cost=292.74..292.74 rows=10,274 width=14) (actual time=33.140..33.140 rows=10,274 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 618kB
14. 3.976 3.976 ↑ 1.0 10,274 1

Seq Scan on tb_veiculo ve (cost=0.00..292.74 rows=10,274 width=14) (actual time=0.005..3.976 rows=10,274 loops=1)

15. 0.040 40,366.363 ↓ 2.6 123 1

Hash (cost=48,753.48..48,753.48 rows=48 width=44) (actual time=40,366.363..40,366.363 rows=123 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
16. 0.020 40,366.323 ↓ 2.6 123 1

Subquery Scan on tb_sos (cost=48,751.80..48,753.48 rows=48 width=44) (actual time=40,366.116..40,366.323 rows=123 loops=1)

17. 0.195 40,366.303 ↓ 2.6 123 1

GroupAggregate (cost=48,751.80..48,753.00 rows=48 width=44) (actual time=40,366.114..40,366.303 rows=123 loops=1)

  • Group Key: rd_1.id_rd
18. 0.313 40,366.108 ↓ 3.0 145 1

Sort (cost=48,751.80..48,751.92 rows=48 width=20) (actual time=40,366.094..40,366.108 rows=145 loops=1)

  • Sort Key: rd_1.id_rd
  • Sort Method: quicksort Memory: 36kB
19. 0.669 40,365.795 ↓ 3.0 145 1

Nested Loop (cost=2.00..48,750.46 rows=48 width=20) (actual time=1,323.344..40,365.795 rows=145 loops=1)

20. 92.274 40,364.256 ↓ 3.0 145 1

Nested Loop (cost=1.72..48,735.62 rows=48 width=24) (actual time=1,323.325..40,364.256 rows=145 loops=1)

  • Join Filter: ((o.id_modelo_ocorrencia)::integer = (mo.id_modelo_ocorrencia)::integer)
  • Rows Removed by Join Filter: 405,496
21. 47.866 40,221.189 ↓ 419.8 50,793 1

Nested Loop (cost=1.72..48,720.39 rows=121 width=28) (actual time=125.619..40,221.189 rows=50,793 loops=1)

22. 14.711 32,187.100 ↓ 1.7 39,341 1

Nested Loop (cost=1.29..34,761.31 rows=23,359 width=12) (actual time=21.540..32,187.100 rows=39,341 loops=1)

23. 19.840 10,953.968 ↓ 1.4 15,729 1

Nested Loop (cost=0.86..22,052.70 rows=11,290 width=12) (actual time=10.804..10,953.968 rows=15,729 loops=1)

24. 56.835 56.835 ↓ 1.0 8,681 1

Index Only Scan using ind_tb_rd_idfilial_dtini_idveiculo_idrd on tb_rd rd_1 (cost=0.43..248.16 rows=8,448 width=8) (actual time=0.041..56.835 rows=8,681 loops=1)

  • Index Cond: ((id_filial = 55) AND (dt_inicio_terminal >= '2020-01-20 00:00:00-03'::timestamp with time zone) AND (dt_inicio_terminal <= '2020-02-19 23:59:59-03'::timestamp with time zone))
  • Heap Fetches: 0
25. 10,877.293 10,877.293 ↑ 1.0 2 8,681

Index Scan using ix01f_tb_viagem on tb_viagem v1 (cost=0.43..2.56 rows=2 width=8) (actual time=0.633..1.253 rows=2 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd_1.id_rd)::integer)
26. 47.187 21,218.421 ↑ 2.3 3 15,729

Append (cost=0.43..1.06 rows=7 width=8) (actual time=1.291..1.349 rows=3 loops=15,729)

27. 21,124.047 21,124.047 ↑ 1.0 3 15,729

Index Scan using ix01f_tb_trecho_viagem on tb_trecho_viagem tv1 (cost=0.43..0.48 rows=3 width=8) (actual time=1.290..1.343 rows=3 loops=15,729)

  • Index Cond: ((id_viagem)::integer = (v1.id_viagem)::integer)
28. 47.187 47.187 ↓ 0.0 0 15,729

Index Scan using ix01f_tbtrechoviagemu20191111 on tb_trecho_viagem_clust_until_20191111 tv1_1 (cost=0.43..0.54 rows=4 width=8) (actual time=0.003..0.003 rows=0 loops=15,729)

  • Index Cond: ((id_viagem)::integer = (v1.id_viagem)::integer)
29. 7,986.223 7,986.223 ↑ 1.0 1 39,341

Index Scan using ix02f_tb_ocorrencia on tb_ocorrencia o (cost=0.43..0.59 rows=1 width=24) (actual time=0.104..0.203 rows=1 loops=39,341)

  • Index Cond: ((id_trecho_viagem)::integer = (tv1.id_trecho_viagem)::integer)
  • Filter: ((dt_inicio >= '2020-01-20 00:00:00-03'::timestamp with time zone) AND (dt_inicio <= '2020-02-19 23:59:59-03'::timestamp with time zone))
  • Rows Removed by Filter: 0
30. 50.783 50.793 ↑ 1.0 8 50,793

Materialize (cost=0.00..1.29 rows=8 width=4) (actual time=0.000..0.001 rows=8 loops=50,793)

31. 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.008..0.010 rows=8 loops=1)

  • Filter: ((tp_ocorrencia)::smallint = 0)
  • Rows Removed by Filter: 12
32. 0.870 0.870 ↑ 1.0 1 145

Index Only Scan using pk00_tb_veiculo on tb_veiculo ve_1 (cost=0.29..0.31 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=145)

  • Index Cond: (id_veiculo = (rd_1.id_veiculo)::integer)
  • Heap Fetches: 0
33. 0.557 7,086.832 ↓ 336.5 2,019 1

Hash (cost=38,912.43..38,912.43 rows=6 width=28) (actual time=7,086.831..7,086.832 rows=2,019 loops=1)

  • Buckets: 2,048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 135kB
34. 0.295 7,086.275 ↓ 336.5 2,019 1

Subquery Scan on tb_refeicao (cost=38,912.23..38,912.43 rows=6 width=28) (actual time=7,084.557..7,086.275 rows=2,019 loops=1)

35. 1.246 7,085.980 ↓ 336.5 2,019 1

GroupAggregate (cost=38,912.23..38,912.37 rows=6 width=28) (actual time=7,084.556..7,085.980 rows=2,019 loops=1)

  • Group Key: rd_2.id_rd
36. 1.924 7,084.734 ↓ 343.3 2,060 1

Sort (cost=38,912.23..38,912.25 rows=6 width=20) (actual time=7,084.539..7,084.734 rows=2,060 loops=1)

  • Sort Key: rd_2.id_rd
  • Sort Method: quicksort Memory: 257kB
37. 3.592 7,082.810 ↓ 343.3 2,060 1

Nested Loop (cost=380.65..38,912.15 rows=6 width=20) (actual time=391.296..7,082.810 rows=2,060 loops=1)

38. 4.049 7,073.038 ↓ 343.3 2,060 1

Hash Join (cost=380.36..38,910.30 rows=6 width=24) (actual time=391.268..7,073.038 rows=2,060 loops=1)

  • Hash Cond: ((v1_1.id_rd)::integer = (rd_2.id_rd)::integer)
39. 11.289 7,055.821 ↓ 2.0 7,128 1

Nested Loop (cost=26.61..38,546.97 rows=3,644 width=20) (actual time=195.916..7,055.821 rows=7,128 loops=1)

40. 19.481 4,663.780 ↓ 2.0 7,128 1

Nested Loop (cost=26.17..36,884.85 rows=3,644 width=20) (actual time=181.716..4,663.780 rows=7,128 loops=1)

41. 10.842 239.195 ↓ 2.0 7,128 1

Hash Join (cost=25.75..26,703.72 rows=3,644 width=20) (actual time=169.138..239.195 rows=7,128 loops=1)

  • Hash Cond: ((o_1.id_modelo_ocorrencia)::integer = (mo_1.id_modelo_ocorrencia)::integer)
42. 228.021 228.342 ↓ 1.0 73,964 1

Bitmap Heap Scan on tb_ocorrencia o_1 (cost=24.48..26,470.62 rows=72,874 width=24) (actual time=69.239..228.342 rows=73,964 loops=1)

  • Recheck Cond: ((dt_inicio >= '2020-01-20 00:00:00-03'::timestamp with time zone) AND (dt_inicio <= '2020-02-19 23:59:59-03'::timestamp with time zone))
  • Rows Removed by Index Recheck: 114,574
  • Heap Blocks: lossy=2,667
43. 0.321 0.321 ↑ 2.8 26,880 1

Bitmap Index Scan on ind_tb_ocorrencia_dtinicio (cost=0.00..6.26 rows=74,876 width=0) (actual time=0.321..0.321 rows=26,880 loops=1)

  • Index Cond: ((dt_inicio >= '2020-01-20 00:00:00-03'::timestamp with time zone) AND (dt_inicio <= '2020-02-19 23:59:59-03'::timestamp with time zone))
44. 0.002 0.011 ↑ 1.0 1 1

Hash (cost=1.25..1.25 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
45. 0.009 0.009 ↑ 1.0 1 1

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

  • Filter: ((tp_ocorrencia)::smallint = 2)
  • Rows Removed by Filter: 19
46. 21.384 4,405.104 ↑ 2.0 1 7,128

Append (cost=0.43..2.77 rows=2 width=8) (actual time=0.611..0.618 rows=1 loops=7,128)

47. 4,369.464 4,369.464 ↑ 1.0 1 7,128

Index Scan using pk00_tb_trecho_viagem on tb_trecho_viagem tv1_2 (cost=0.43..0.79 rows=1 width=8) (actual time=0.610..0.613 rows=1 loops=7,128)

  • Index Cond: ((id_trecho_viagem)::integer = (o_1.id_trecho_viagem)::integer)
48. 14.256 14.256 ↓ 0.0 0 7,128

Index Scan using pk00_tbtrechoviagemu20191111 on tb_trecho_viagem_clust_until_20191111 tv1_3 (cost=0.43..1.98 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=7,128)

  • Index Cond: ((id_trecho_viagem)::integer = (o_1.id_trecho_viagem)::integer)
49. 2,380.752 2,380.752 ↑ 1.0 1 7,128

Index Scan using pk00_tb_viagem on tb_viagem v1_1 (cost=0.43..0.46 rows=1 width=8) (actual time=0.334..0.334 rows=1 loops=7,128)

  • Index Cond: ((id_viagem)::integer = (tv1_2.id_viagem)::integer)
50. 9.956 13.168 ↓ 1.0 8,681 1

Hash (cost=248.16..248.16 rows=8,448 width=8) (actual time=13.168..13.168 rows=8,681 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 468kB
51. 3.212 3.212 ↓ 1.0 8,681 1

Index Only Scan using ind_tb_rd_idfilial_dtini_idveiculo_idrd on tb_rd rd_2 (cost=0.43..248.16 rows=8,448 width=8) (actual time=0.040..3.212 rows=8,681 loops=1)

  • Index Cond: ((id_filial = 55) AND (dt_inicio_terminal >= '2020-01-20 00:00:00-03'::timestamp with time zone) AND (dt_inicio_terminal <= '2020-02-19 23:59:59-03'::timestamp with time zone))
  • Heap Fetches: 0
52. 6.180 6.180 ↑ 1.0 1 2,060

Index Only Scan using pk00_tb_veiculo on tb_veiculo ve_2 (cost=0.29..0.31 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=2,060)

  • Index Cond: (id_veiculo = (rd_2.id_veiculo)::integer)
  • Heap Fetches: 0
53. 164.939 164.939 ↑ 1.0 2 8,681

Index Scan using ix01f_tb_viagem on tb_viagem v (cost=0.43..2.56 rows=2 width=10) (actual time=0.014..0.019 rows=2 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
54. 94.374 471.870 ↑ 2.3 3 15,729

Append (cost=0.43..1.06 rows=7 width=61) (actual time=0.016..0.030 rows=3 loops=15,729)

55. 267.393 267.393 ↑ 1.0 3 15,729

Index Scan using ix01f_tb_trecho_viagem on tb_trecho_viagem tv (cost=0.43..0.48 rows=3 width=116) (actual time=0.012..0.017 rows=3 loops=15,729)

  • Index Cond: ((id_viagem)::integer = (v.id_viagem)::integer)
56. 110.103 110.103 ↓ 0.0 0 15,729

Index Scan using ix01f_tbtrechoviagemu20191111 on tb_trecho_viagem_clust_until_20191111 tv_1 (cost=0.43..0.54 rows=4 width=54) (actual time=0.007..0.007 rows=0 loops=15,729)

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

SubPlan (for GroupAggregate)

58. 95.491 34,689.276 ↑ 1.0 1 8,681

Aggregate (cost=390.10..390.11 rows=1 width=16) (actual time=3.996..3.996 rows=1 loops=8,681)

59. 43.405 34,593.785 ↑ 7.0 31 8,681

Append (cost=114.81..389.01 rows=218 width=16) (actual time=3.969..3.985 rows=31 loops=8,681)

60. 7,257.316 34,472.251 ↑ 3.4 31 8,681

Bitmap Heap Scan on tb_parada pa (cost=114.81..241.84 rows=105 width=16) (actual time=3.966..3.971 rows=31 loops=8,681)

  • Recheck Cond: ((id_rd)::integer = (rd.id_rd)::integer)
  • Heap Blocks: exact=11,007
61. 27,214.935 27,214.935 ↑ 3.4 31 8,681

Bitmap Index Scan on ind_tb_parada_idrd_gin (cost=0.00..114.79 rows=105 width=0) (actual time=3.135..3.135 rows=31 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
62. 17.362 78.129 ↓ 0.0 0 8,681

Bitmap Heap Scan on tb_parada_until_201810 pa_1 (cost=9.27..146.08 rows=113 width=16) (actual time=0.009..0.009 rows=0 loops=8,681)

  • Recheck Cond: ((id_rd)::integer = (rd.id_rd)::integer)
63. 60.767 60.767 ↓ 0.0 0 8,681

Bitmap Index Scan on ind_tb_tbparadau201810_idrd (cost=0.00..9.24 rows=113 width=0) (actual time=0.007..0.007 rows=0 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
64. 17.362 6,797.223 ↓ 0.0 0 8,681

Limit (cost=15.67..15.67 rows=1 width=40) (actual time=0.782..0.783 rows=0 loops=8,681)

65. 52.086 6,779.861 ↓ 0.0 0 8,681

Sort (cost=15.67..15.68 rows=3 width=40) (actual time=0.781..0.781 rows=0 loops=8,681)

  • Sort Key: eq.dt_inicio
  • Sort Method: quicksort Memory: 25kB
66. 14.474 6,727.775 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=1.15..15.65 rows=3 width=40) (actual time=0.662..0.775 rows=0 loops=8,681)

67. 45.051 6,684.370 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=0.86..14.74 rows=3 width=12) (actual time=0.657..0.770 rows=0 loops=8,681)

68. 2,456.723 2,456.723 ↓ 0.0 0 8,681

Index Scan using ix03f_tb_equipe on tb_equipe eq (cost=0.43..2.88 rows=3 width=12) (actual time=0.277..0.283 rows=0 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
69. 4,182.596 4,182.596 ↑ 1.0 1 4,133

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1 (cost=0.43..3.94 rows=1 width=8) (actual time=0.806..1.012 rows=1 loops=4,133)

  • Index Cond: ((eq.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 1)
  • Rows Removed by Filter: 2
70. 28.931 28.931 ↑ 1.0 1 4,133

Index Scan using pk00_tb_coletor on tb_coletor c1 (cost=0.29..0.31 rows=1 width=28) (actual time=0.006..0.007 rows=1 loops=4,133)

  • Index Cond: ((ec1.id_coletor)::integer = (id_coletor)::integer)
71. 8.681 121.534 ↓ 0.0 0 8,681

Limit (cost=15.67..15.67 rows=1 width=40) (actual time=0.014..0.014 rows=0 loops=8,681)

72. 8.681 112.853 ↓ 0.0 0 8,681

Sort (cost=15.67..15.68 rows=3 width=40) (actual time=0.013..0.013 rows=0 loops=8,681)

  • Sort Key: eq_1.dt_inicio
  • Sort Method: quicksort Memory: 25kB
73. 26.458 104.172 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=1.15..15.65 rows=3 width=40) (actual time=0.011..0.012 rows=0 loops=8,681)

74. 26.873 69.448 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=0.86..14.74 rows=3 width=12) (actual time=0.008..0.008 rows=0 loops=8,681)

75. 26.043 26.043 ↓ 0.0 0 8,681

Index Scan using ix03f_tb_equipe on tb_equipe eq_1 (cost=0.43..2.88 rows=3 width=12) (actual time=0.002..0.003 rows=0 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
76. 16.532 16.532 ↑ 1.0 1 4,133

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_1 (cost=0.43..3.94 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=4,133)

  • Index Cond: ((eq_1.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 2)
  • Rows Removed by Filter: 2
77. 8.266 8.266 ↑ 1.0 1 4,133

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=4,133)

  • Index Cond: ((ec1_1.id_coletor)::integer = (id_coletor)::integer)
78. 8.681 130.215 ↓ 0.0 0 8,681

Limit (cost=15.67..15.67 rows=1 width=40) (actual time=0.015..0.015 rows=0 loops=8,681)

79. 8.681 121.534 ↓ 0.0 0 8,681

Sort (cost=15.67..15.68 rows=3 width=40) (actual time=0.014..0.014 rows=0 loops=8,681)

  • Sort Key: eq_2.dt_inicio
  • Sort Method: quicksort Memory: 25kB
80. 39.687 112.853 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=1.15..15.65 rows=3 width=40) (actual time=0.013..0.013 rows=0 loops=8,681)

81. 31.006 60.767 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=0.86..14.74 rows=3 width=12) (actual time=0.007..0.007 rows=0 loops=8,681)

82. 17.362 17.362 ↓ 0.0 0 8,681

Index Scan using ix03f_tb_equipe on tb_equipe eq_2 (cost=0.43..2.88 rows=3 width=12) (actual time=0.002..0.002 rows=0 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
83. 12.399 12.399 ↑ 1.0 1 4,133

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_2 (cost=0.43..3.94 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=4,133)

  • Index Cond: ((eq_2.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 3)
  • Rows Removed by Filter: 2
84. 12.399 12.399 ↑ 1.0 1 4,133

Index Scan using pk00_tb_coletor on tb_coletor c1_2 (cost=0.29..0.31 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=4,133)

  • Index Cond: ((ec1_2.id_coletor)::integer = (id_coletor)::integer)
85. 8.681 121.534 ↓ 0.0 0 8,681

Limit (cost=15.67..15.67 rows=1 width=40) (actual time=0.013..0.014 rows=0 loops=8,681)

86. 17.362 112.853 ↓ 0.0 0 8,681

Sort (cost=15.67..15.68 rows=3 width=40) (actual time=0.013..0.013 rows=0 loops=8,681)

  • Sort Key: eq_3.dt_inicio
  • Sort Method: quicksort Memory: 25kB
87. 30.591 95.491 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=1.15..15.65 rows=3 width=40) (actual time=0.011..0.011 rows=0 loops=8,681)

88. 26.873 60.767 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=0.86..14.74 rows=3 width=12) (actual time=0.007..0.007 rows=0 loops=8,681)

89. 17.362 17.362 ↓ 0.0 0 8,681

Index Scan using ix03f_tb_equipe on tb_equipe eq_3 (cost=0.43..2.88 rows=3 width=12) (actual time=0.002..0.002 rows=0 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
90. 16.532 16.532 ↓ 0.0 0 4,133

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_3 (cost=0.43..3.94 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=4,133)

  • Index Cond: ((eq_3.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 4)
  • Rows Removed by Filter: 2
91. 4.133 4.133 ↓ 0.0 0 4,133

Index Scan using pk00_tb_coletor on tb_coletor c1_3 (cost=0.29..0.31 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=4,133)

  • Index Cond: ((ec1_3.id_coletor)::integer = (id_coletor)::integer)
92. 17.362 138.896 ↓ 0.0 0 8,681

Limit (cost=15.68..15.68 rows=1 width=40) (actual time=0.016..0.016 rows=0 loops=8,681)

93. 8.681 121.534 ↓ 0.0 0 8,681

Sort (cost=15.68..15.68 rows=3 width=40) (actual time=0.014..0.014 rows=0 loops=8,681)

  • Sort Key: eq_4.dt_inicio
  • Sort Method: quicksort Memory: 25kB
94. 21.910 112.853 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=1.15..15.66 rows=3 width=40) (actual time=0.013..0.013 rows=0 loops=8,681)

95. 35.969 86.810 ↓ 0.0 0 8,681

Nested Loop Left Join (cost=0.86..14.74 rows=3 width=12) (actual time=0.010..0.010 rows=0 loops=8,681)

96. 26.043 26.043 ↓ 0.0 0 8,681

Index Scan using ix03f_tb_equipe on tb_equipe eq_4 (cost=0.43..2.88 rows=3 width=12) (actual time=0.003..0.003 rows=0 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
97. 24.798 24.798 ↓ 0.0 0 4,133

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_4 (cost=0.43..3.94 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=4,133)

  • Index Cond: ((eq_4.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 5)
  • Rows Removed by Filter: 3
98. 4.133 4.133 ↓ 0.0 0 4,133

Index Scan using pk00_tb_coletor on tb_coletor c1_4 (cost=0.29..0.31 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=4,133)

  • Index Cond: ((ec1_4.id_coletor)::integer = (id_coletor)::integer)
99. 17.362 34.724 ↓ 0.0 0 8,681

Limit (cost=0.43..2.88 rows=1 width=1) (actual time=0.004..0.004 rows=0 loops=8,681)

100. 17.362 17.362 ↓ 0.0 0 8,681

Index Scan using ix03f_tb_equipe on tb_equipe eq_5 (cost=0.43..2.88 rows=1 width=1) (actual time=0.002..0.002 rows=0 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
  • Filter: (NOT vf_inicial)
  • Rows Removed by Filter: 0
101. 43.405 442.731 ↓ 0.0 0 8,681

Limit (cost=0.42..2.84 rows=1 width=5) (actual time=0.051..0.051 rows=0 loops=8,681)

102. 399.326 399.326 ↓ 0.0 0 8,681

Index Scan using ix00f_tb_abastecimento on tb_abastecimento (cost=0.42..2.84 rows=1 width=5) (actual time=0.046..0.046 rows=0 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
103. 17.362 34.724 ↓ 0.0 0 8,681

Limit (cost=0.42..2.84 rows=1 width=4) (actual time=0.003..0.004 rows=0 loops=8,681)

104. 17.362 17.362 ↓ 0.0 0 8,681

Index Scan using ix00f_tb_abastecimento on tb_abastecimento tb_abastecimento_1 (cost=0.42..2.84 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=8,681)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
105. 0.354 0.354 ↑ 1.0 1 59

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

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
106. 1.064 1.064 ↑ 1.0 1 266

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

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
107. 4.496 4.496 ↑ 1.0 1 1,124

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

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
108. 23.301 23.301 ↑ 1.0 1 2,589

Index Scan using pk00_tb_geometria on tb_geometria g_1 (cost=0.43..2.85 rows=1 width=43) (actual time=0.008..0.009 rows=1 loops=2,589)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
109. 62.988 62.988 ↑ 1.0 1 5,249

Index Scan using pk00_tb_geometria on tb_geometria g (cost=0.43..2.85 rows=1 width=43) (actual time=0.011..0.012 rows=1 loops=5,249)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
Planning time : 66.637 ms
Execution time : 192,181.407 ms