explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 37cQ

Settings
# exclusive inclusive rows x rows loops node
1. 11.619 30,142.377 ↑ 3.1 3,563 1

Sort (cost=2,033,653.46..2,033,681.50 rows=11,215 width=746) (actual time=30,141.863..30,142.377 rows=3,563 loops=1)

  • Sort Key: rd.dt_inicio_terminal
  • Sort Method: quicksort Memory: 1,220kB
2. 27,077.781 30,130.758 ↑ 3.1 3,563 1

GroupAggregate (cost=91,051.61..2,029,178.58 rows=11,215 width=746) (actual time=2,227.727..30,130.758 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. 623.466 2,548.796 ↓ 8.9 100,300 1

Sort (cost=91,051.61..91,079.65 rows=11,215 width=610) (actual time=2,226.512..2,548.796 rows=100,300 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: 32,072kB
4. 36.629 1,925.330 ↓ 8.9 100,300 1

Hash Left Join (cost=11,473.87..87,227.72 rows=11,215 width=610) (actual time=355.134..1,925.330 rows=100,300 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_refeicao.id_rd)::integer)
5. 28.705 1,846.390 ↓ 8.9 100,300 1

Hash Left Join (cost=9,555.70..85,280.11 rows=11,215 width=586) (actual time=312.807..1,846.390 rows=100,300 loops=1)

  • Hash Cond: ((rd.id_rd)::integer = (tb_sos.id_rd)::integer)
6. 35.625 1,754.062 ↓ 8.9 100,300 1

Hash Join (cost=7,637.38..83,332.35 rows=11,215 width=546) (actual time=249.165..1,754.062 rows=100,300 loops=1)

  • Hash Cond: ((rd.id_veiculo)::integer = (ve.id_veiculo)::integer)
7. 41.981 1,708.941 ↓ 8.9 100,300 1

Hash Join (cost=7,252.52..82,918.04 rows=11,215 width=540) (actual time=239.646..1,708.941 rows=100,300 loops=1)

  • Hash Cond: ((rd.id_modelo_coleta)::integer = (mc.id_modelo_coleta)::integer)
8. 600.465 1,666.671 ↓ 8.9 100,300 1

Hash Right Join (cost=7,250.96..82,882.04 rows=11,215 width=512) (actual time=239.340..1,666.671 rows=100,300 loops=1)

  • Hash Cond: (((pa.id_rd)::integer = (rd.id_rd)::integer) AND ((pa.id_veiculo)::integer = (rd.id_veiculo)::integer) AND ((pa.id_trecho_viagem)::integer = (tv.id_trecho_viagem)::integer))
9. 140.868 837.463 ↑ 1.0 1,547,610 1

Append (cost=0.00..42,343.90 rows=1,548,460 width=12) (actual time=0.306..837.463 rows=1,547,610 loops=1)

10. 696.588 696.588 ↑ 1.0 1,547,610 1

Seq Scan on tb_parada pa (cost=0.00..34,583.10 rows=1,547,610 width=12) (actual time=0.306..696.588 rows=1,547,610 loops=1)

11. 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=12) (actual time=0.006..0.007 rows=0 loops=1)

12. 11.180 228.743 ↑ 1.1 10,654 1

Hash (cost=6,309.70..6,309.70 rows=11,215 width=516) (actual time=228.743..228.743 rows=10,654 loops=1)

  • Buckets: 8,192 Batches: 2 Memory Usage: 2,176kB
13. 28.962 217.563 ↑ 1.1 10,654 1

Hash Join (cost=2,282.30..6,309.70 rows=11,215 width=516) (actual time=106.820..217.563 rows=10,654 loops=1)

  • Hash Cond: ((tv.id_viagem)::integer = (v.id_viagem)::integer)
14. 12.926 114.202 ↑ 1.0 136,143 1

Append (cost=0.00..3,402.80 rows=136,653 width=118) (actual time=0.275..114.202 rows=136,143 loops=1)

15. 101.268 101.268 ↑ 1.0 136,143 1

Seq Scan on tb_trecho_viagem tv (cost=0.00..2,704.43 rows=136,143 width=118) (actual time=0.273..101.268 rows=136,143 loops=1)

16. 0.008 0.008 ↓ 0.0 0 1

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

17. 4.650 74.399 ↑ 1.0 5,118 1

Hash (cost=2,217.77..2,217.77 rows=5,163 width=406) (actual time=74.399..74.399 rows=5,118 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,437kB
18. 16.042 69.749 ↑ 1.0 5,118 1

Hash Join (cost=937.52..2,217.77 rows=5,163 width=406) (actual time=42.844..69.749 rows=5,118 loops=1)

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

20. 2.881 38.076 ↓ 1.0 3,563 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 809kB
21. 32.866 35.195 ↓ 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.383..35.195 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.329 2.329 ↓ 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.329..2.329 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.010 0.289 ↑ 1.0 25 1

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

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

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

25. 3.506 9.496 ↑ 1.0 10,216 1

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

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

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

27. 0.020 63.623 ↑ 2.2 25 1

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

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

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

29. 0.217 63.594 ↑ 2.2 25 1

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

  • Group Key: rd_1.id_rd
30. 0.187 63.377 ↑ 1.7 31 1

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

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

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

32. 0.314 60.591 ↑ 1.7 31 1

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

33. 0.942 30.187 ↑ 2.2 295 1

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

34. 0.381 25.410 ↑ 2.2 295 1

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

35. 1.950 14.999 ↑ 2.2 295 1

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

  • Hash Cond: ((o.id_modelo_ocorrencia)::integer = (mo.id_modelo_ocorrencia)::integer)
36. 12.475 12.737 ↓ 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.125..12.737 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.262 0.262 ↑ 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.262..0.262 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.312 ↓ 8.0 8 1

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

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

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

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

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

41. 8.850 8.850 ↑ 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.029..0.030 rows=1 loops=295)

  • Index Cond: ((id_trecho_viagem)::integer = (o.id_trecho_viagem)::integer)
42. 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)
43. 3.835 3.835 ↑ 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.013..0.013 rows=1 loops=295)

  • Index Cond: ((id_viagem)::integer = (tv1.id_viagem)::integer)
44. 30.090 30.090 ↓ 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.102..0.102 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. 2.418 2.418 ↑ 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.078..0.078 rows=1 loops=31)

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

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

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

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

48. 0.307 42.048 ↓ 8.1 437 1

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

  • Group Key: rd_2.id_rd
49. 0.384 41.741 ↓ 8.2 443 1

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

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

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

51. 0.659 39.297 ↓ 8.2 443 1

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

52. 2.071 27.648 ↓ 2.4 1,570 1

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

53. 0.512 20.867 ↓ 2.4 1,570 1

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

54. 2.193 7.795 ↓ 2.4 1,570 1

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

  • Hash Cond: ((o_1.id_modelo_ocorrencia)::integer = (mo_1.id_modelo_ocorrencia)::integer)
55. 5.534 5.577 ↓ 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.512..5.577 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.043 0.043 ↑ 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.043..0.043 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.025 ↑ 1.0 1 1

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

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

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

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

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

60. 9.420 9.420 ↑ 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.005..0.006 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. 4.710 4.710 ↑ 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.003..0.003 rows=1 loops=1,570)

  • Index Cond: ((id_viagem)::integer = (tv1_2.id_viagem)::integer)
63. 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
64. 1.772 1.772 ↑ 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.004..0.004 rows=1 loops=443)

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

SubPlan (for GroupAggregate)

66. 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)

67. 21.378 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
68. 7.686 71.260 ↓ 0.0 0 3,563

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

69. 9.933 57.008 ↓ 0.0 0 3,563

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

70. 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)
71. 15.008 15.008 ↑ 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.014..0.016 rows=1 loops=938)

  • Index Cond: ((eq.id_equipe)::integer = (id_equipe)::integer)
  • Filter: (vl_ordem = 1)
  • Rows Removed by Filter: 2
72. 6.566 6.566 ↑ 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.007..0.007 rows=1 loops=938)

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

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

74. 7.126 39.193 ↓ 0.0 0 3,563

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

  • Sort Key: eq_1.dt_inicio
  • Sort Method: quicksort Memory: 25kB
75. 8.624 32.067 ↓ 0.0 0 3,563

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

76. 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)

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

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
78. 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
79. 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)
80. 7.126 46.319 ↓ 0.0 0 3,563

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

81. 7.126 39.193 ↓ 0.0 0 3,563

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

  • Sort Key: eq_2.dt_inicio
  • Sort Method: quicksort Memory: 25kB
82. 5.810 32.067 ↓ 0.0 0 3,563

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

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

84. 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)
85. 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
86. 8.442 8.442 ↑ 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.009..0.009 rows=1 loops=938)

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

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

88. 7.126 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
89. 3.374 24.941 ↓ 0.0 0 3,563

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

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

91. 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)
92. 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
93. 3.752 3.752 ↓ 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.004..0.004 rows=0 loops=938)

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

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

95. 7.126 28.504 ↓ 0.0 0 3,563

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

  • Sort Key: eq_4.dt_inicio
  • Sort Method: quicksort Memory: 25kB
96. 2.625 21.378 ↓ 0.0 0 3,563

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

97. 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)

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

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
99. 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.004..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
100. 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)
101. 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)

102. 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
103. 10.689 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)

104. 17.815 17.815 ↓ 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.005..0.005 rows=0 loops=3,563)

  • Index Cond: ((id_rd)::integer = (rd.id_rd)::integer)
105. 3.563 10.689 ↓ 0.0 0 3,563

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

106. 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)
107. 0.030 0.030 ↑ 1.0 1 3

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

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
108. 0.738 0.738 ↑ 1.0 1 123

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

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
109. 5.952 5.952 ↑ 1.0 1 992

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

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
110. 38.682 38.682 ↑ 1.0 1 6,447

Index Scan using pk00_tb_geometria on tb_geometria g_1 (cost=0.42..8.44 rows=1 width=18) (actual time=0.005..0.006 rows=1 loops=6,447)

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
111. 141.672 141.672 ↑ 1.0 1 23,612

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

  • Index Cond: ((id_geometria)::integer = (tv.id_local_clt)::integer)
Planning time : 29.245 ms
Execution time : 30,149.388 ms