explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8mN6

Settings
# exclusive inclusive rows x rows loops node
1. 9.823 115,217.289 ↑ 124.3 3,333 1

Sort (cost=72,226,880.17..72,227,915.49 rows=414,128 width=746) (actual time=115,216.849..115,217.289 rows=3,333 loops=1)

  • Sort Key: rd.dt_inicio_terminal
  • Sort Method: quicksort Memory: 1,158kB
2. 108,073.049 115,207.466 ↑ 124.3 3,333 1

GroupAggregate (cost=345,860.22..71,913,639.62 rows=414,128 width=746) (actual time=5,013.715..115,207.466 rows=3,333 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. 3,896.244 6,135.971 ↓ 1.1 454,659 1

Sort (cost=345,860.22..346,895.54 rows=414,128 width=610) (actual time=5,011.476..6,135.971 rows=454,659 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: external merge Disk: 178,848kB
4. 924.461 2,239.727 ↓ 1.1 454,659 1

Hash Join (cost=11,606.33..80,744.66 rows=414,128 width=610) (actual time=369.791..2,239.727 rows=454,659 loops=1)

  • Hash Cond: ((pa.id_rd)::integer = (rd.id_rd)::integer)
5. 189.099 955.739 ↑ 1.0 1,547,610 1

Append (cost=0.00..42,343.90 rows=1,548,460 width=4) (actual time=1.328..955.739 rows=1,547,610 loops=1)

6. 766.633 766.633 ↑ 1.0 1,547,610 1

Seq Scan on tb_parada pa (cost=0.00..34,583.10 rows=1,547,610 width=4) (actual time=1.327..766.633 rows=1,547,610 loops=1)

7. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on tb_parada_until_201810 pa_1 (cost=0.00..18.50 rows=850 width=4) (actual time=0.007..0.007 rows=0 loops=1)

8. 9.449 359.527 ↑ 1.1 10,654 1

Hash (cost=10,589.14..10,589.14 rows=11,215 width=614) (actual time=359.527..359.527 rows=10,654 loops=1)

  • Buckets: 8,192 Batches: 2 Memory Usage: 2,331kB
9. 25.838 350.078 ↑ 1.1 10,654 1

Hash Join (cost=6,561.74..10,589.14 rows=11,215 width=614) (actual time=254.051..350.078 rows=10,654 loops=1)

  • Hash Cond: ((tv.id_viagem)::integer = (v.id_viagem)::integer)
10. 12.240 91.637 ↑ 1.0 136,143 1

Append (cost=0.00..3,402.80 rows=136,653 width=114) (actual time=0.366..91.637 rows=136,143 loops=1)

11. 79.390 79.390 ↑ 1.0 136,143 1

Seq Scan on tb_trecho_viagem tv (cost=0.00..2,704.43 rows=136,143 width=114) (actual time=0.365..79.390 rows=136,143 loops=1)

12. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on tb_trecho_viagem_clust_until_20191111 tv_1 (cost=0.00..15.10 rows=510 width=54) (actual time=0.007..0.007 rows=0 loops=1)

13. 2.534 232.603 ↑ 1.0 5,118 1

Hash (cost=6,497.21..6,497.21 rows=5,163 width=508) (actual time=232.603..232.603 rows=5,118 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,593kB
14. 1.596 230.069 ↑ 1.0 5,118 1

Hash Left Join (cost=5,160.43..6,497.21 rows=5,163 width=508) (actual time=202.634..230.069 rows=5,118 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_refeicao.id_rd)::integer)
15. 1.440 183.024 ↑ 1.0 5,118 1

Hash Left Join (cost=3,242.25..4,565.47 rows=5,163 width=484) (actual time=157.172..183.024 rows=5,118 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_sos.id_rd)::integer)
16. 1.717 71.707 ↑ 1.0 5,118 1

Hash Join (cost=1,323.94..2,633.61 rows=5,163 width=444) (actual time=47.275..71.707 rows=5,118 loops=1)

  • Hash Cond: ((rd.id_veiculo)::integer = (ve.id_veiculo)::integer)
17. 1.556 62.553 ↑ 1.0 5,118 1

Hash Join (cost=939.08..2,235.18 rows=5,163 width=438) (actual time=39.819..62.553 rows=5,118 loops=1)

  • Hash Cond: ((rd.id_modelo_coleta)::integer = (mc.id_modelo_coleta)::integer)
18. 0.000 60.713 ↑ 1.0 5,118 1

Hash Join (cost=937.52..2,217.77 rows=5,163 width=410) (actual time=39.516..60.713 rows=5,118 loops=1)

  • Hash Cond: ((v.id_rd)::integer = (rd.id_rd)::integer)
19. 11.314 11.314 ↑ 1.0 62,909 1

Seq Scan on tb_viagem v (cost=0.00..1,115.09 rows=62,909 width=10) (actual time=0.016..11.314 rows=62,909 loops=1)

20. 20.641 52.502 ↓ 1.0 3,563 1

Hash (cost=894.51..894.51 rows=3,441 width=400) (actual time=34.760..52.502 rows=3,563 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 809kB
21. 29.003 31.861 ↓ 1.0 3,563 1

Bitmap Heap Scan on tb_rd rd (cost=116.29..894.51 rows=3,441 width=400) (actual time=2.924..31.861 rows=3,563 loops=1)

  • Recheck Cond: (((id_filial)::integer = 55) AND (dt_inicio_terminal >= '2020-05-01 00:00:00-03'::timestamp with time zone) AND (dt_inicio_terminal <= '2020-05-31 23:59:59-03'::timestamp with time zone))
  • Heap Blocks: exact=162
22. 2.858 2.858 ↓ 1.0 3,563 1

Bitmap Index Scan on ind_tb_rd_idfilial_dtini_idveiculo_idrd (cost=0.00..115.43 rows=3,441 width=0) (actual time=2.858..2.858 rows=3,563 loops=1)

  • Index Cond: (((id_filial)::integer = 55) AND (dt_inicio_terminal >= '2020-05-01 00:00:00-03'::timestamp with time zone) AND (dt_inicio_terminal <= '2020-05-31 23:59:59-03'::timestamp with time zone))
23. 0.013 0.284 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=36) (actual time=0.283..0.284 rows=25 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
24. 0.271 0.271 ↑ 1.0 25 1

Seq Scan on tb_modelo_coleta mc (cost=0.00..1.25 rows=25 width=36) (actual time=0.265..0.271 rows=25 loops=1)

25. 2.761 7.437 ↑ 1.0 10,216 1

Hash (cost=257.16..257.16 rows=10,216 width=14) (actual time=7.437..7.437 rows=10,216 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 615kB
26. 4.676 4.676 ↑ 1.0 10,216 1

Seq Scan on tb_veiculo ve (cost=0.00..257.16 rows=10,216 width=14) (actual time=0.222..4.676 rows=10,216 loops=1)

27. 0.014 109.877 ↑ 2.2 25 1

Hash (cost=1,917.64..1,917.64 rows=54 width=44) (actual time=109.877..109.877 rows=25 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
28. 0.006 109.863 ↑ 2.2 25 1

Subquery Scan on tb_sos (cost=1,915.75..1,917.64 rows=54 width=44) (actual time=109.825..109.863 rows=25 loops=1)

29. 0.055 109.857 ↑ 2.2 25 1

GroupAggregate (cost=1,915.75..1,917.10 rows=54 width=44) (actual time=109.823..109.857 rows=25 loops=1)

  • Group Key: rd_1.id_rd
30. 0.204 109.802 ↑ 1.7 31 1

Sort (cost=1,915.75..1,915.88 rows=54 width=20) (actual time=109.798..109.802 rows=31 loops=1)

  • Sort Key: rd_1.id_rd
  • Sort Method: quicksort Memory: 27kB
31. 0.081 109.598 ↑ 1.7 31 1

Nested Loop (cost=17.88..1,914.19 rows=54 width=20) (actual time=28.487..109.598 rows=31 loops=1)

32. 0.519 105.921 ↑ 1.7 31 1

Nested Loop (cost=17.60..1,886.25 rows=54 width=24) (actual time=26.523..105.921 rows=31 loops=1)

33. 1.719 72.657 ↑ 2.2 295 1

Nested Loop (cost=17.31..1,644.04 rows=658 width=20) (actual time=8.870..72.657 rows=295 loops=1)

34. 0.473 62.088 ↑ 2.2 295 1

Nested Loop (cost=17.02..1,428.99 rows=658 width=20) (actual time=8.540..62.088 rows=295 loops=1)

35. 2.932 24.150 ↑ 2.2 295 1

Hash Join (cost=16.60..666.63 rows=658 width=20) (actual time=4.770..24.150 rows=295 loops=1)

  • Hash Cond: ((o.id_modelo_ocorrencia)::integer = (mo.id_modelo_ocorrencia)::integer)
36. 19.994 20.952 ↓ 1.0 13,243 1

Bitmap Heap Scan on tb_ocorrencia o (cost=15.34..623.52 rows=13,153 width=24) (actual time=4.480..20.952 rows=13,243 loops=1)

  • Recheck Cond: ((dt_inicio >= '2020-05-01 00:00:00-03'::timestamp with time zone) AND (dt_inicio <= '2020-05-31 23:59:59-03'::timestamp with time zone))
  • Rows Removed by Index Recheck: 7,232
  • Heap Blocks: lossy=288
37. 0.958 0.958 ↑ 4.7 2,880 1

Bitmap Index Scan on ind_tb_ocorrencia_dtinicio (cost=0.00..12.05 rows=13,412 width=0) (actual time=0.958..0.958 rows=2,880 loops=1)

  • Index Cond: ((dt_inicio >= '2020-05-01 00:00:00-03'::timestamp with time zone) AND (dt_inicio <= '2020-05-31 23:59:59-03'::timestamp with time zone))
38. 0.006 0.266 ↓ 8.0 8 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
39. 0.260 0.260 ↓ 8.0 8 1

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

  • Filter: ((tp_ocorrencia)::smallint = 0)
  • Rows Removed by Filter: 12
40. 1.180 37.465 ↑ 2.0 1 295

Append (cost=0.42..1.14 rows=2 width=8) (actual time=0.120..0.127 rows=1 loops=295)

41. 35.105 35.105 ↑ 1.0 1 295

Index Scan using pk00_tb_trecho_viagem on tb_trecho_viagem tv1 (cost=0.42..0.96 rows=1 width=8) (actual time=0.119..0.119 rows=1 loops=295)

  • Index Cond: ((id_trecho_viagem)::integer = (o.id_trecho_viagem)::integer)
42. 1.180 1.180 ↓ 0.0 0 295

Index Scan using pk00_tbtrechoviagemu20191111 on tb_trecho_viagem_clust_until_20191111 tv1_1 (cost=0.15..0.17 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=295)

  • Index Cond: ((id_trecho_viagem)::integer = (o.id_trecho_viagem)::integer)
43. 8.850 8.850 ↑ 1.0 1 295

Index Scan using pk00_tb_viagem on tb_viagem v1 (cost=0.29..0.33 rows=1 width=8) (actual time=0.030..0.030 rows=1 loops=295)

  • Index Cond: ((id_viagem)::integer = (tv1.id_viagem)::integer)
44. 32.745 32.745 ↓ 0.0 0 295

Index Scan using pk00_tb_rd on tb_rd rd_1 (cost=0.29..0.37 rows=1 width=8) (actual time=0.111..0.111 rows=0 loops=295)

  • Index Cond: ((id_rd)::integer = (v1.id_rd)::integer)
  • Filter: ((dt_inicio_terminal >= '2020-05-01 00:00:00-03'::timestamp with time zone) AND (dt_inicio_terminal <= '2020-05-31 23:59:59-03'::timestamp with time zone) AND ((id_filial)::integer = 55))
  • Rows Removed by Filter: 1
45. 3.596 3.596 ↑ 1.0 1 31

Index Only Scan using pk00_tb_veiculo on tb_veiculo ve_1 (cost=0.29..0.52 rows=1 width=4) (actual time=0.116..0.116 rows=1 loops=31)

  • Index Cond: (id_veiculo = (rd_1.id_veiculo)::integer)
  • Heap Fetches: 31
46. 0.102 45.449 ↓ 8.1 437 1

Hash (cost=1,917.50..1,917.50 rows=54 width=28) (actual time=45.449..45.449 rows=437 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 34kB
47. 0.055 45.347 ↓ 8.1 437 1

Subquery Scan on tb_refeicao (cost=1,915.75..1,917.50 rows=54 width=28) (actual time=44.944..45.347 rows=437 loops=1)

48. 0.314 45.292 ↓ 8.1 437 1

GroupAggregate (cost=1,915.75..1,916.96 rows=54 width=28) (actual time=44.942..45.292 rows=437 loops=1)

  • Group Key: rd_2.id_rd
49. 0.367 44.978 ↓ 8.2 443 1

Sort (cost=1,915.75..1,915.88 rows=54 width=20) (actual time=44.932..44.978 rows=443 loops=1)

  • Sort Key: rd_2.id_rd
  • Sort Method: quicksort Memory: 59kB
50. 0.624 44.611 ↓ 8.2 443 1

Nested Loop (cost=17.88..1,914.19 rows=54 width=20) (actual time=0.795..44.611 rows=443 loops=1)

51. 1.403 42.658 ↓ 8.2 443 1

Nested Loop (cost=17.60..1,886.25 rows=54 width=24) (actual time=0.784..42.658 rows=443 loops=1)

52. 1.329 31.835 ↓ 2.4 1,570 1

Nested Loop (cost=17.31..1,644.04 rows=658 width=20) (actual time=0.772..31.835 rows=1,570 loops=1)

53. 1.221 24.226 ↓ 2.4 1,570 1

Nested Loop (cost=17.02..1,428.99 rows=658 width=20) (actual time=0.745..24.226 rows=1,570 loops=1)

54. 2.161 7.305 ↓ 2.4 1,570 1

Hash Join (cost=16.60..666.63 rows=658 width=20) (actual time=0.366..7.305 rows=1,570 loops=1)

  • Hash Cond: ((o_1.id_modelo_ocorrencia)::integer = (mo_1.id_modelo_ocorrencia)::integer)
55. 5.094 5.127 ↓ 1.0 13,243 1

Bitmap Heap Scan on tb_ocorrencia o_1 (cost=15.34..623.52 rows=13,153 width=24) (actual time=0.334..5.127 rows=13,243 loops=1)

  • Recheck Cond: ((dt_inicio >= '2020-05-01 00:00:00-03'::timestamp with time zone) AND (dt_inicio <= '2020-05-31 23:59:59-03'::timestamp with time zone))
  • Rows Removed by Index Recheck: 7,232
  • Heap Blocks: lossy=288
56. 0.033 0.033 ↑ 4.7 2,880 1

Bitmap Index Scan on ind_tb_ocorrencia_dtinicio (cost=0.00..12.05 rows=13,412 width=0) (actual time=0.033..0.033 rows=2,880 loops=1)

  • Index Cond: ((dt_inicio >= '2020-05-01 00:00:00-03'::timestamp with time zone) AND (dt_inicio <= '2020-05-31 23:59:59-03'::timestamp with time zone))
57. 0.002 0.017 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
58. 0.015 0.015 ↑ 1.0 1 1

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

  • Filter: ((tp_ocorrencia)::smallint = 2)
  • Rows Removed by Filter: 19
59. 1.570 15.700 ↑ 2.0 1 1,570

Append (cost=0.42..1.14 rows=2 width=8) (actual time=0.008..0.010 rows=1 loops=1,570)

60. 12.560 12.560 ↑ 1.0 1 1,570

Index Scan using pk00_tb_trecho_viagem on tb_trecho_viagem tv1_2 (cost=0.42..0.96 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=1,570)

  • Index Cond: ((id_trecho_viagem)::integer = (o_1.id_trecho_viagem)::integer)
61. 1.570 1.570 ↓ 0.0 0 1,570

Index Scan using pk00_tbtrechoviagemu20191111 on tb_trecho_viagem_clust_until_20191111 tv1_3 (cost=0.15..0.17 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,570)

  • Index Cond: ((id_trecho_viagem)::integer = (o_1.id_trecho_viagem)::integer)
62. 6.280 6.280 ↑ 1.0 1 1,570

Index Scan using pk00_tb_viagem on tb_viagem v1_1 (cost=0.29..0.33 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1,570)

  • Index Cond: ((id_viagem)::integer = (tv1_2.id_viagem)::integer)
63. 9.420 9.420 ↓ 0.0 0 1,570

Index Scan using pk00_tb_rd on tb_rd rd_2 (cost=0.29..0.37 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1,570)

  • Index Cond: ((id_rd)::integer = (v1_1.id_rd)::integer)
  • Filter: ((dt_inicio_terminal >= '2020-05-01 00:00:00-03'::timestamp with time zone) AND (dt_inicio_terminal <= '2020-05-31 23:59:59-03'::timestamp with time zone) AND ((id_filial)::integer = 55))
  • Rows Removed by Filter: 1
64. 1.329 1.329 ↑ 1.0 1 443

Index Only Scan using pk00_tb_veiculo on tb_veiculo ve_2 (cost=0.29..0.52 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=443)

  • Index Cond: (id_veiculo = (rd_2.id_veiculo)::integer)
  • Heap Fetches: 443
65.          

SubPlan (for GroupAggregate)

66. 9.999 103.323 ↓ 0.0 0 3,333

Limit (cost=20.57..20.58 rows=1 width=40) (actual time=0.030..0.031 rows=0 loops=3,333)

67. 19.998 93.324 ↓ 0.0 0 3,333

Sort (cost=20.57..20.58 rows=1 width=40) (actual time=0.028..0.028 rows=0 loops=3,333)

  • Sort Key: eq.dt_inicio
  • Sort Method: quicksort Memory: 25kB
68. 6.060 73.326 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.86..20.56 rows=1 width=40) (actual time=0.021..0.022 rows=0 loops=3,333)

69. 7.272 49.995 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.58..20.18 rows=1 width=12) (actual time=0.014..0.015 rows=0 loops=3,333)

70. 29.997 29.997 ↓ 0.0 0 3,333

Index Scan using ix03f_tb_equipe on tb_equipe eq (cost=0.29..8.30 rows=1 width=12) (actual time=0.009..0.009 rows=0 loops=3,333)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
71. 12.726 12.726 ↑ 1.0 1 909

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1 (cost=0.29..11.86 rows=1 width=8) (actual time=0.011..0.014 rows=1 loops=909)

  • Index Cond: ((eq.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 1)
  • Rows Removed by Filter: 2
72. 17.271 17.271 ↑ 1.0 1 909

Index Scan using pk00_tb_coletor on tb_coletor c1 (cost=0.29..0.39 rows=1 width=28) (actual time=0.019..0.019 rows=1 loops=909)

  • Index Cond: ((ec1.id_coletor)::integer = (id_coletor)::integer)
73. 3.333 39.996 ↓ 0.0 0 3,333

Limit (cost=20.63..20.63 rows=1 width=40) (actual time=0.012..0.012 rows=0 loops=3,333)

74. 9.999 36.663 ↓ 0.0 0 3,333

Sort (cost=20.63..20.63 rows=1 width=40) (actual time=0.011..0.011 rows=0 loops=3,333)

  • Sort Key: eq_1.dt_inicio
  • Sort Method: quicksort Memory: 25kB
75. 2.727 26.664 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.86..20.62 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=3,333)

76. 6.363 16.665 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.58..20.18 rows=1 width=12) (actual time=0.005..0.005 rows=0 loops=3,333)

77. 6.666 6.666 ↓ 0.0 0 3,333

Index Scan using ix03f_tb_equipe on tb_equipe eq_1 (cost=0.29..8.30 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=3,333)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
78. 3.636 3.636 ↑ 1.0 1 909

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_1 (cost=0.29..11.86 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=909)

  • Index Cond: ((eq_1.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 2)
  • Rows Removed by Filter: 2
79. 7.272 7.272 ↑ 1.0 1 909

Index Scan using pk00_tb_coletor on tb_coletor c1_1 (cost=0.29..0.44 rows=1 width=28) (actual time=0.008..0.008 rows=1 loops=909)

  • Index Cond: ((ec1_1.id_coletor)::integer = (id_coletor)::integer)
80. 6.666 36.663 ↓ 0.0 0 3,333

Limit (cost=20.64..20.64 rows=1 width=40) (actual time=0.010..0.011 rows=0 loops=3,333)

81. 6.666 29.997 ↓ 0.0 0 3,333

Sort (cost=20.64..20.64 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=3,333)

  • Sort Key: eq_2.dt_inicio
  • Sort Method: quicksort Memory: 25kB
82. 3.030 23.331 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.86..20.63 rows=1 width=40) (actual time=0.007..0.007 rows=0 loops=3,333)

83. 6.363 16.665 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.58..20.18 rows=1 width=12) (actual time=0.004..0.005 rows=0 loops=3,333)

84. 6.666 6.666 ↓ 0.0 0 3,333

Index Scan using ix03f_tb_equipe on tb_equipe eq_2 (cost=0.29..8.30 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=3,333)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
85. 3.636 3.636 ↑ 1.0 1 909

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_2 (cost=0.29..11.86 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=909)

  • Index Cond: ((eq_2.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 3)
  • Rows Removed by Filter: 2
86. 3.636 3.636 ↑ 1.0 1 909

Index Scan using pk00_tb_coletor on tb_coletor c1_2 (cost=0.29..0.45 rows=1 width=28) (actual time=0.004..0.004 rows=1 loops=909)

  • Index Cond: ((ec1_2.id_coletor)::integer = (id_coletor)::integer)
87. 6.666 33.330 ↓ 0.0 0 3,333

Limit (cost=20.67..20.68 rows=1 width=40) (actual time=0.010..0.010 rows=0 loops=3,333)

88. 6.666 26.664 ↓ 0.0 0 3,333

Sort (cost=20.67..20.68 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=3,333)

  • Sort Key: eq_3.dt_inicio
  • Sort Method: quicksort Memory: 25kB
89. 3.939 19.998 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.86..20.66 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=3,333)

90. 3.030 13.332 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.58..20.18 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=3,333)

91. 6.666 6.666 ↓ 0.0 0 3,333

Index Scan using ix03f_tb_equipe on tb_equipe eq_3 (cost=0.29..8.30 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=3,333)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
92. 3.636 3.636 ↓ 0.0 0 909

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_3 (cost=0.29..11.86 rows=1 width=8) (actual time=0.003..0.004 rows=0 loops=909)

  • Index Cond: ((eq_3.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 4)
  • Rows Removed by Filter: 2
93. 2.727 2.727 ↓ 0.0 0 909

Index Scan using pk00_tb_coletor on tb_coletor c1_3 (cost=0.29..0.49 rows=1 width=28) (actual time=0.003..0.003 rows=0 loops=909)

  • Index Cond: ((ec1_3.id_coletor)::integer = (id_coletor)::integer)
94. 3.333 29.997 ↓ 0.0 0 3,333

Limit (cost=21.42..21.43 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=3,333)

95. 6.666 26.664 ↓ 0.0 0 3,333

Sort (cost=21.42..21.43 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=3,333)

  • Sort Key: eq_4.dt_inicio
  • Sort Method: quicksort Memory: 25kB
96. 5.757 19.998 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.86..21.41 rows=1 width=40) (actual time=0.006..0.006 rows=0 loops=3,333)

97. 3.939 13.332 ↓ 0.0 0 3,333

Nested Loop Left Join (cost=0.58..20.18 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=3,333)

98. 6.666 6.666 ↓ 0.0 0 3,333

Index Scan using ix03f_tb_equipe on tb_equipe eq_4 (cost=0.29..8.30 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=3,333)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
99. 2.727 2.727 ↓ 0.0 0 909

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1_4 (cost=0.29..11.86 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=909)

  • Index Cond: ((eq_4.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 5)
  • Rows Removed by Filter: 3
100. 0.909 0.909 ↓ 0.0 0 909

Index Scan using pk00_tb_coletor on tb_coletor c1_4 (cost=0.29..1.24 rows=1 width=28) (actual time=0.001..0.001 rows=0 loops=909)

  • Index Cond: ((ec1_4.id_coletor)::integer = (id_coletor)::integer)
101. 3.333 9.999 ↓ 0.0 0 3,333

Limit (cost=0.29..8.30 rows=1 width=1) (actual time=0.003..0.003 rows=0 loops=3,333)

102. 6.666 6.666 ↓ 0.0 0 3,333

Index Scan using ix03f_tb_equipe on tb_equipe eq_5 (cost=0.29..8.30 rows=1 width=1) (actual time=0.002..0.002 rows=0 loops=3,333)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
  • Filter: (NOT vf_inicial)
  • Rows Removed by Filter: 0
103. 3.333 16.665 ↓ 0.0 0 3,333

Limit (cost=0.28..8.30 rows=1 width=5) (actual time=0.005..0.005 rows=0 loops=3,333)

104. 13.332 13.332 ↓ 0.0 0 3,333

Index Scan using ix00f_tb_abastecimento on tb_abastecimento (cost=0.28..8.30 rows=1 width=5) (actual time=0.004..0.004 rows=0 loops=3,333)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
105. 3.333 9.999 ↓ 0.0 0 3,333

Limit (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=3,333)

106. 6.666 6.666 ↓ 0.0 0 3,333

Index Scan using ix00f_tb_abastecimento on tb_abastecimento tb_abastecimento_1 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=3,333)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
107. 0.588 0.588 ↑ 1.0 1 98

Index Scan using pk00_tb_geometria on tb_geometria g_4 (cost=0.42..8.44 rows=1 width=18) (actual time=0.006..0.006 rows=1 loops=98)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
108. 11.208 11.208 ↑ 1.0 1 1,868

Index Scan using pk00_tb_geometria on tb_geometria g_3 (cost=0.42..8.44 rows=1 width=18) (actual time=0.006..0.006 rows=1 loops=1,868)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
109. 73.563 73.563 ↑ 1.0 1 10,509

Index Scan using pk00_tb_geometria on tb_geometria g_2 (cost=0.42..8.44 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=10,509)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
110. 230.055 230.055 ↑ 1.0 1 32,865

Index Scan using pk00_tb_geometria on tb_geometria g_1 (cost=0.42..8.44 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=32,865)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
111. 403.060 403.060 ↑ 1.0 1 57,580

Index Scan using pk00_tb_geometria on tb_geometria g (cost=0.42..8.44 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=57,580)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
Planning time : 56.491 ms
Execution time : 115,274.496 ms