explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pc0A

Settings
# exclusive inclusive rows x rows loops node
1. 10.223 119,995.601 ↑ 3.1 3,563 1

Sort (cost=2,008,056.12..2,008,084.15 rows=11,215 width=746) (actual time=119,995.093..119,995.601 rows=3,563 loops=1)

  • Sort Key: rd.dt_inicio_terminal
  • Sort Method: quicksort Memory: 1,219kB
2. 111,871.516 119,985.378 ↑ 3.1 3,563 1

GroupAggregate (cost=65,454.26..2,003,581.23 rows=11,215 width=746) (actual time=5,915.169..119,985.378 rows=3,563 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,513.939 7,110.491 ↓ 40.6 455,083 1

Sort (cost=65,454.26..65,482.30 rows=11,215 width=610) (actual time=5,913.589..7,110.491 rows=455,083 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: 179,048kB
4. 203.606 3,596.552 ↓ 40.6 455,083 1

Nested Loop (cost=55,723.45..61,630.38 rows=11,215 width=610) (actual time=1,541.175..3,596.552 rows=455,083 loops=1)

5. 435.749 1,990.178 ↓ 34.0 175,346 1

Hash Join (cost=55,723.03..57,125.66 rows=5,163 width=504) (actual time=1,539.274..1,990.178 rows=175,346 loops=1)

  • Hash Cond: ((v.id_rd)::integer = (rd.id_rd)::integer)
6. 21.989 21.989 ↑ 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.021..21.989 rows=62,909 loops=1)

7. 86.356 1,532.440 ↓ 28.6 98,409 1

Hash (cost=55,680.02..55,680.02 rows=3,441 width=498) (actual time=1,532.440..1,532.440 rows=98,409 loops=1)

  • Buckets: 16,384 (originally 4096) Batches: 8 (originally 1) Memory Usage: 3,969kB
8. 29.887 1,446.084 ↓ 28.6 98,409 1

Hash Left Join (cost=5,169.03..55,680.02 rows=3,441 width=498) (actual time=217.547..1,446.084 rows=98,409 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_refeicao.id_rd)::integer)
9. 24.712 1,362.823 ↓ 28.6 98,409 1

Hash Left Join (cost=3,250.86..53,752.80 rows=3,441 width=474) (actual time=164.161..1,362.823 rows=98,409 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_sos.id_rd)::integer)
10. 30.581 1,227.754 ↓ 28.6 98,409 1

Hash Join (cost=1,332.54..51,825.46 rows=3,441 width=434) (actual time=53.777..1,227.754 rows=98,409 loops=1)

  • Hash Cond: ((rd.id_veiculo)::integer = (ve.id_veiculo)::integer)
11. 31.057 1,188.211 ↓ 28.6 98,409 1

Hash Join (cost=947.68..51,431.57 rows=3,441 width=428) (actual time=44.789..1,188.211 rows=98,409 loops=1)

  • Hash Cond: ((rd.id_modelo_coleta)::integer = (mc.id_modelo_coleta)::integer)
12. 263.744 1,156.846 ↓ 28.6 98,409 1

Hash Right Join (cost=946.12..51,419.44 rows=3,441 width=400) (actual time=44.465..1,156.846 rows=98,409 loops=1)

  • Hash Cond: (((pa.id_rd)::integer = (rd.id_rd)::integer) AND ((pa.id_veiculo)::integer = (rd.id_veiculo)::integer))
13. 161.042 859.371 ↑ 1.0 1,547,610 1

Append (cost=0.00..42,343.90 rows=1,548,460 width=8) (actual time=0.200..859.371 rows=1,547,610 loops=1)

14. 698.322 698.322 ↑ 1.0 1,547,610 1

Seq Scan on tb_parada pa (cost=0.00..34,583.10 rows=1,547,610 width=8) (actual time=0.199..698.322 rows=1,547,610 loops=1)

15. 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=8) (actual time=0.007..0.007 rows=0 loops=1)

16. 3.162 33.731 ↓ 1.0 3,563 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 809kB
17. 28.492 30.569 ↓ 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.125..30.569 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
18. 2.077 2.077 ↓ 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.077..2.077 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))
19. 0.007 0.308 ↑ 1.0 25 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
20. 0.301 0.301 ↑ 1.0 25 1

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

21. 3.156 8.962 ↑ 1.0 10,216 1

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

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

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

23. 0.018 110.357 ↑ 2.2 25 1

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

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

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

25. 0.067 110.333 ↑ 2.2 25 1

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

  • Group Key: rd_1.id_rd
26. 0.210 110.266 ↑ 1.7 31 1

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

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

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

28. 0.504 107.508 ↑ 1.7 31 1

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

29. 1.533 78.094 ↑ 2.2 295 1

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

30. 0.409 60.041 ↑ 2.2 295 1

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

31. 2.521 15.972 ↑ 2.2 295 1

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

  • Hash Cond: ((o.id_modelo_ocorrencia)::integer = (mo.id_modelo_ocorrencia)::integer)
32. 12.946 13.190 ↓ 1.0 13,243 1

Bitmap Heap Scan on tb_ocorrencia o (cost=15.34..623.52 rows=13,153 width=24) (actual time=3.156..13.190 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
33. 0.244 0.244 ↑ 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.244..0.244 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))
34. 0.007 0.261 ↓ 8.0 8 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
35. 0.254 0.254 ↓ 8.0 8 1

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

  • Filter: ((tp_ocorrencia)::smallint = 0)
  • Rows Removed by Filter: 12
36. 0.885 43.660 ↑ 2.0 1 295

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

37. 41.890 41.890 ↑ 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.141..0.142 rows=1 loops=295)

  • Index Cond: ((id_trecho_viagem)::integer = (o.id_trecho_viagem)::integer)
38. 0.885 0.885 ↓ 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.003..0.003 rows=0 loops=295)

  • Index Cond: ((id_trecho_viagem)::integer = (o.id_trecho_viagem)::integer)
39. 16.520 16.520 ↑ 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.056..0.056 rows=1 loops=295)

  • Index Cond: ((id_viagem)::integer = (tv1.id_viagem)::integer)
40. 28.910 28.910 ↓ 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.098..0.098 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
41. 2.232 2.232 ↑ 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.072..0.072 rows=1 loops=31)

  • Index Cond: (id_veiculo = (rd_1.id_veiculo)::integer)
  • Heap Fetches: 31
42. 0.079 53.374 ↓ 8.1 437 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 34kB
43. 0.050 53.295 ↓ 8.1 437 1

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

44. 0.217 53.245 ↓ 8.1 437 1

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

  • Group Key: rd_2.id_rd
45. 0.390 53.028 ↓ 8.2 443 1

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

  • Sort Key: rd_2.id_rd
  • Sort Method: quicksort Memory: 59kB
46. 0.849 52.638 ↓ 8.2 443 1

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

47. 1.258 49.574 ↓ 8.2 443 1

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

48. 2.352 37.326 ↓ 2.4 1,570 1

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

49. 0.904 28.694 ↓ 2.4 1,570 1

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

50. 2.198 7.380 ↓ 2.4 1,570 1

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

  • Hash Cond: ((o_1.id_modelo_ocorrencia)::integer = (mo_1.id_modelo_ocorrencia)::integer)
51. 5.131 5.164 ↓ 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.365..5.164 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
52. 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))
53. 0.002 0.018 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
54. 0.016 0.016 ↑ 1.0 1 1

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

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

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

56. 17.270 17.270 ↑ 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.010..0.011 rows=1 loops=1,570)

  • Index Cond: ((id_trecho_viagem)::integer = (o_1.id_trecho_viagem)::integer)
57. 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)
58. 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)
59. 10.990 10.990 ↓ 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.007..0.007 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
60. 2.215 2.215 ↑ 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.005..0.005 rows=1 loops=443)

  • Index Cond: (id_veiculo = (rd_2.id_veiculo)::integer)
  • Heap Fetches: 443
61. 175.346 1,402.768 ↑ 2.0 3 175,346

Append (cost=0.42..0.81 rows=6 width=114) (actual time=0.005..0.008 rows=3 loops=175,346)

62. 1,052.076 1,052.076 ↑ 1.0 3 175,346

Index Scan using ix01f_tb_trecho_viagem on tb_trecho_viagem tv (cost=0.42..0.58 rows=3 width=114) (actual time=0.004..0.006 rows=3 loops=175,346)

  • Index Cond: ((id_viagem)::integer = (v.id_viagem)::integer)
63. 175.346 175.346 ↓ 0.0 0 175,346

Index Scan using ix01f_tbtrechoviagemu20191111 on tb_trecho_viagem_clust_until_20191111 tv_1 (cost=0.15..0.20 rows=3 width=54) (actual time=0.001..0.001 rows=0 loops=175,346)

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

SubPlan (for GroupAggregate)

65. 10.689 103.327 ↓ 0.0 0 3,563

Limit (cost=20.57..20.58 rows=1 width=40) (actual time=0.028..0.029 rows=0 loops=3,563)

66. 17.815 92.638 ↓ 0.0 0 3,563

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

  • Sort Key: eq.dt_inicio
  • Sort Method: quicksort Memory: 25kB
67. 9.373 74.823 ↓ 0.0 0 3,563

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

68. 8.995 57.008 ↓ 0.0 0 3,563

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

69. 32.067 32.067 ↓ 0.0 0 3,563

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,563)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
70. 15.946 15.946 ↑ 1.0 1 938

Index Scan using pk00_tb_equipe_coletor on tb_equipe_coletor ec1 (cost=0.29..11.86 rows=1 width=8) (actual time=0.015..0.017 rows=1 loops=938)

  • Index Cond: ((eq.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 1)
  • Rows Removed by Filter: 2
71. 8.442 8.442 ↑ 1.0 1 938

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

  • Index Cond: ((ec1.id_coletor)::integer = (id_coletor)::integer)
72. 7.126 42.756 ↓ 0.0 0 3,563

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

73. 7.126 35.630 ↓ 0.0 0 3,563

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

  • Sort Key: eq_1.dt_inicio
  • Sort Method: quicksort Memory: 25kB
74. 5.061 28.504 ↓ 0.0 0 3,563

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

75. 3.374 17.815 ↓ 0.0 0 3,563

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

76. 10.689 10.689 ↓ 0.0 0 3,563

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.003 rows=0 loops=3,563)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
77. 3.752 3.752 ↑ 1.0 1 938

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=938)

  • Index Cond: ((eq_1.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 2)
  • Rows Removed by Filter: 2
78. 5.628 5.628 ↑ 1.0 1 938

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

  • Index Cond: ((ec1_1.id_coletor)::integer = (id_coletor)::integer)
79. 3.563 49.882 ↓ 0.0 0 3,563

Limit (cost=20.64..20.64 rows=1 width=40) (actual time=0.014..0.014 rows=0 loops=3,563)

80. 7.126 46.319 ↓ 0.0 0 3,563

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

  • Sort Key: eq_2.dt_inicio
  • Sort Method: quicksort Memory: 25kB
81. 4.494 39.193 ↓ 0.0 0 3,563

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

82. 6.937 17.815 ↓ 0.0 0 3,563

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

83. 7.126 7.126 ↓ 0.0 0 3,563

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,563)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
84. 3.752 3.752 ↑ 1.0 1 938

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=938)

  • Index Cond: ((eq_2.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 3)
  • Rows Removed by Filter: 2
85. 16.884 16.884 ↑ 1.0 1 938

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

  • Index Cond: ((ec1_2.id_coletor)::integer = (id_coletor)::integer)
86. 7.126 39.193 ↓ 0.0 0 3,563

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

87. 3.563 32.067 ↓ 0.0 0 3,563

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

  • Sort Key: eq_3.dt_inicio
  • Sort Method: quicksort Memory: 25kB
88. 4.123 28.504 ↓ 0.0 0 3,563

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

89. 6.937 17.815 ↓ 0.0 0 3,563

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

90. 7.126 7.126 ↓ 0.0 0 3,563

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,563)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
91. 3.752 3.752 ↓ 0.0 0 938

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=938)

  • Index Cond: ((eq_3.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 4)
  • Rows Removed by Filter: 2
92. 6.566 6.566 ↓ 0.0 0 938

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

  • Index Cond: ((ec1_3.id_coletor)::integer = (id_coletor)::integer)
93. 7.126 46.319 ↓ 0.0 0 3,563

Limit (cost=21.42..21.43 rows=1 width=40) (actual time=0.012..0.013 rows=0 loops=3,563)

94. 7.126 39.193 ↓ 0.0 0 3,563

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

  • Sort Key: eq_4.dt_inicio
  • Sort Method: quicksort Memory: 25kB
95. 16.877 32.067 ↓ 0.0 0 3,563

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

96. 3.374 14.252 ↓ 0.0 0 3,563

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

97. 7.126 7.126 ↓ 0.0 0 3,563

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,563)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
98. 3.752 3.752 ↓ 0.0 0 938

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.004 rows=0 loops=938)

  • Index Cond: ((eq_4.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 5)
  • Rows Removed by Filter: 3
99. 0.938 0.938 ↓ 0.0 0 938

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=938)

  • Index Cond: ((ec1_4.id_coletor)::integer = (id_coletor)::integer)
100. 3.563 10.689 ↓ 0.0 0 3,563

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

101. 7.126 7.126 ↓ 0.0 0 3,563

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,563)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
  • Filter: (NOT vf_inicial)
  • Rows Removed by Filter: 0
102. 3.563 28.504 ↓ 0.0 0 3,563

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

103. 24.941 24.941 ↓ 0.0 0 3,563

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

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
104. 0.000 7.126 ↓ 0.0 0 3,563

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

105. 7.126 7.126 ↓ 0.0 0 3,563

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,563)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
106. 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)
107. 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)
108. 63.090 63.090 ↑ 1.0 1 10,515

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.006 rows=1 loops=10,515)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
109. 197.286 197.286 ↑ 1.0 1 32,881

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.006 rows=1 loops=32,881)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
110. 403.403 403.403 ↑ 1.0 1 57,629

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

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
Planning time : 29.904 ms
Execution time : 120,022.774 ms