explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oiTz

Settings
# exclusive inclusive rows x rows loops node
1. 3,665.723 3,665.723 ↓ 57.6 461 1

CTE Scan on trechos (cost=569,313.54..569,313.70 rows=8 width=32) (actual time=3,656.476..3,665.723 rows=461 loops=1)

  • Functions: 319
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 27.068 ms, Inlining 9.651 ms, Optimization 1251.648 ms, Emission 773.158 ms, Total 2061.525 ms
2.          

CTE dataset

3. 0.000 2,221.100 ↓ 164.0 67,422 1

Append (cost=2,454.76..3,277.89 rows=411 width=32) (actual time=2,114.971..2,221.100 rows=67,422 loops=1)

4.          

Initplan (forAppend)

5. 0.003 0.235 ↑ 1.0 1 1

Subquery Scan on t (cost=54.09..54.11 rows=1 width=8) (actual time=0.234..0.235 rows=1 loops=1)

6.          

Initplan (forSubquery Scan)

7. 0.004 0.156 ↑ 1.0 1 1

Result (cost=5.98..5.99 rows=1 width=8) (actual time=0.156..0.156 rows=1 loops=1)

8.          

Initplan (forResult)

9. 0.005 0.152 ↑ 1.0 1 1

Limit (cost=5.74..5.98 rows=1 width=8) (actual time=0.150..0.152 rows=1 loops=1)

10. 0.004 0.147 ↑ 10,692.0 1 1

Merge Append (cost=5.74..2,562.61 rows=10,692 width=8) (actual time=0.147..0.147 rows=1 loops=1)

  • Sort Key: ddn_mapa10.dt_hr_utc_inicial
11. 0.016 0.016 ↑ 1,207.0 1 1

Index Only Scan using ddn_mapa10_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa10 (cost=0.56..276.94 rows=1,207 width=8) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 1
12. 0.012 0.012 ↑ 1,003.0 1 1

Index Only Scan using ddn_mapa11_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa11 (cost=0.56..118.96 rows=1,003 width=8) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 0
13. 0.012 0.012 ↑ 975.0 1 1

Index Only Scan using ddn_mapa12_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa12 (cost=0.56..116.72 rows=975 width=8) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 1
14. 0.016 0.016 ↑ 1,035.0 1 1

Index Only Scan using ddn_mapa13_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa13 (cost=0.56..284.38 rows=1,035 width=8) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 1
15. 0.012 0.012 ↑ 1,039.0 1 1

Index Only Scan using ddn_mapa14_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa14 (cost=0.56..281.97 rows=1,039 width=8) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 1
16. 0.015 0.015 ↑ 1,136.0 1 1

Index Only Scan using ddn_mapa15_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa15 (cost=0.56..278.88 rows=1,136 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 1
17. 0.015 0.015 ↑ 1,091.0 1 1

Index Only Scan using ddn_mapa16_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa16 (cost=0.56..267.25 rows=1,091 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 1
18. 0.016 0.016 ↑ 1,106.0 1 1

Index Only Scan using ddn_mapa17_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa17 (cost=0.56..271.18 rows=1,106 width=8) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 1
19. 0.015 0.015 ↑ 1,001.0 1 1

Index Only Scan using ddn_mapa18_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa18 (cost=0.56..206.75 rows=1,001 width=8) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 1
20. 0.014 0.014 ↑ 1,099.0 1 1

Index Only Scan using ddn_mapa19_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa19 (cost=0.56..228.35 rows=1,099 width=8) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial IS NOT NULL))
  • Heap Fetches: 1
21. 0.007 0.076 ↑ 1.0 1 1

Aggregate (cost=48.10..48.11 rows=1 width=8) (actual time=0.075..0.076 rows=1 loops=1)

22. 0.069 0.069 ↓ 0.0 0 1

Index Only Scan using trecho_operacao_talhao_cd_cliente_cd_equipamento_cd_operac_key1 on trecho_operacao_talhao (cost=0.42..47.92 rows=69 width=8) (actual time=0.069..0.069 rows=0 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_equipamento = 1475) AND (dt_fim < '2019-03-01 11:52:08'::timestamp without time zone))
  • Heap Fetches: 0
23. 0.005 76.044 ↑ 1.0 1 1

Subquery Scan on t_1 (cost=2,400.07..2,400.09 rows=1 width=8) (actual time=76.043..76.044 rows=1 loops=1)

24.          

Initplan (forSubquery Scan)

25. 4.929 76.019 ↑ 1.0 1 1

Aggregate (cost=2,384.85..2,384.86 rows=1 width=8) (actual time=76.019..76.019 rows=1 loops=1)

26. 7.626 71.090 ↓ 10.1 107,619 1

Append (cost=0.56..2,358.12 rows=10,692 width=8) (actual time=0.009..71.090 rows=107,619 loops=1)

27. 10.715 10.715 ↓ 8.9 10,794 1

Index Only Scan using ddn_mapa10_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa10 ddn_mapa10_1 (cost=0.56..273.92 rows=1,207 width=8) (actual time=0.009..10.715 rows=10,794 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 10754
28. 4.361 4.361 ↓ 10.5 10,572 1

Index Only Scan using ddn_mapa11_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa11 ddn_mapa11_1 (cost=0.56..116.46 rows=1,003 width=8) (actual time=0.018..4.361 rows=10,572 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 2700
29. 4.533 4.533 ↓ 11.1 10,795 1

Index Only Scan using ddn_mapa12_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa12 ddn_mapa12_1 (cost=0.56..114.29 rows=975 width=8) (actual time=0.015..4.533 rows=10,795 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 2720
30. 6.560 6.560 ↓ 10.5 10,901 1

Index Only Scan using ddn_mapa13_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa13 ddn_mapa13_1 (cost=0.56..281.79 rows=1,035 width=8) (actual time=0.021..6.560 rows=10,901 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 5513
31. 6.236 6.236 ↓ 10.4 10,777 1

Index Only Scan using ddn_mapa14_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa14 ddn_mapa14_1 (cost=0.56..279.37 rows=1,039 width=8) (actual time=0.021..6.236 rows=10,777 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 5266
32. 6.145 6.145 ↓ 9.7 10,970 1

Index Only Scan using ddn_mapa15_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa15 ddn_mapa15_1 (cost=0.56..276.04 rows=1,136 width=8) (actual time=0.020..6.145 rows=10,970 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 4993
33. 6.204 6.204 ↓ 9.8 10,652 1

Index Only Scan using ddn_mapa16_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa16 ddn_mapa16_1 (cost=0.56..264.52 rows=1,091 width=8) (actual time=0.018..6.204 rows=10,652 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 4879
34. 6.127 6.127 ↓ 9.6 10,644 1

Index Only Scan using ddn_mapa17_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa17 ddn_mapa17_1 (cost=0.56..268.41 rows=1,106 width=8) (actual time=0.022..6.127 rows=10,644 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 5010
35. 6.189 6.189 ↓ 10.7 10,703 1

Index Only Scan using ddn_mapa18_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa18 ddn_mapa18_1 (cost=0.56..204.25 rows=1,001 width=8) (actual time=0.018..6.189 rows=10,703 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 4992
36. 6.394 6.394 ↓ 9.8 10,811 1

Index Only Scan using ddn_mapa19_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa19 ddn_mapa19_1 (cost=0.56..225.61 rows=1,099 width=8) (actual time=0.022..6.394 rows=10,811 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 4999
37. 0.002 0.020 ↑ 1.0 1 1

Aggregate (cost=15.21..15.22 rows=1 width=8) (actual time=0.020..0.020 rows=1 loops=1)

38. 0.018 0.018 ↓ 0.0 0 1

Index Only Scan using trecho_operacao_talhao_cd_cliente_cd_equipamento_cd_operac_key1 on trecho_operacao_talhao trecho_operacao_talhao_1 (cost=0.42..15.18 rows=12 width=8) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_equipamento = 1475) AND (dt_inicio > '2019-05-22 16:49:05'::timestamp without time zone))
  • Heap Fetches: 0
39. 2,125.348 2,125.348 ↓ 143.4 6,742 1

Index Scan using ddn_mapa10_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa10 glot (cost=0.56..93.89 rows=47 width=32) (actual time=2,114.970..2,125.348 rows=6,742 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 4052
40. 10.041 10.041 ↓ 174.4 6,629 1

Index Scan using ddn_mapa11_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa11 glot_1 (cost=0.56..77.32 rows=38 width=32) (actual time=0.024..10.041 rows=6,629 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 3943
41. 9.942 9.942 ↓ 183.6 6,795 1

Index Scan using ddn_mapa12_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa12 glot_2 (cost=0.56..74.98 rows=37 width=32) (actual time=0.040..9.942 rows=6,795 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 4000
42. 10.142 10.142 ↓ 170.3 6,814 1

Index Scan using ddn_mapa13_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa13 glot_3 (cost=0.56..79.34 rows=40 width=32) (actual time=0.025..10.142 rows=6,814 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 4087
43. 9.998 9.998 ↓ 168.9 6,758 1

Index Scan using ddn_mapa14_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa14 glot_4 (cost=0.56..79.43 rows=40 width=32) (actual time=0.025..9.998 rows=6,758 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 4019
44. 10.341 10.341 ↓ 153.7 6,763 1

Index Scan using ddn_mapa15_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa15 glot_5 (cost=0.56..86.93 rows=44 width=32) (actual time=0.025..10.341 rows=6,763 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 4207
45. 10.032 10.032 ↓ 158.9 6,673 1

Index Scan using ddn_mapa16_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa16 glot_6 (cost=0.56..83.29 rows=42 width=32) (actual time=0.024..10.032 rows=6,673 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 3979
46. 10.021 10.021 ↓ 156.4 6,725 1

Index Scan using ddn_mapa17_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa17 glot_7 (cost=0.56..84.76 rows=43 width=32) (actual time=0.025..10.021 rows=6,725 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 3919
47. 10.011 10.011 ↓ 177.9 6,759 1

Index Scan using ddn_mapa18_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa18 glot_8 (cost=0.56..77.20 rows=38 width=32) (actual time=0.028..10.011 rows=6,759 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 3944
48. 10.164 10.164 ↓ 161.0 6,764 1

Index Scan using ddn_mapa19_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa19 glot_9 (cost=0.56..84.50 rows=42 width=32) (actual time=0.026..10.164 rows=6,764 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475) AND (dt_hr_utc_inicial >= $2) AND (dt_hr_utc_final <= $4))
  • Filter: ((cd_id_talhao <> '-1'::integer) AND (cd_estado = 'E'::bpchar))
  • Rows Removed by Filter: 4047
49.          

CTE lead_operacao_talhao

50. 34.444 2,324.276 ↓ 164.0 67,422 1

WindowAgg (cost=26.06..37.37 rows=411 width=40) (actual time=2,286.254..2,324.276 rows=67,422 loops=1)

51. 46.965 2,289.832 ↓ 164.0 67,422 1

Sort (cost=26.06..27.09 rows=411 width=32) (actual time=2,286.228..2,289.832 rows=67,422 loops=1)

  • Sort Key: d.cd_cliente, d.cd_id_equipamento, d.dt_hr_utc_inicial, d.dt_hr_utc_final
  • Sort Method: quicksort Memory: 8340kB
52. 2,242.867 2,242.867 ↓ 164.0 67,422 1

CTE Scan on dataset d (cost=0.00..8.22 rows=411 width=32) (actual time=2,114.974..2,242.867 rows=67,422 loops=1)

53.          

CTE last_and_lag

54. 0.796 2,342.230 ↓ 1.2 474 1

WindowAgg (cost=28.12..37.37 rows=411 width=32) (actual time=2,341.281..2,342.230 rows=474 loops=1)

55. 0.283 2,341.434 ↓ 1.2 474 1

Sort (cost=28.12..29.15 rows=411 width=24) (actual time=2,341.267..2,341.434 rows=474 loops=1)

  • Sort Key: lot.cd_cliente, lot.cd_id_equipamento, lot.dt_hr_utc_final
  • Sort Method: quicksort Memory: 62kB
56. 2,341.151 2,341.151 ↓ 1.2 474 1

CTE Scan on lead_operacao_talhao lot (cost=0.00..10.28 rows=411 width=24) (actual time=2,286.296..2,341.151 rows=474 loops=1)

  • Filter: ((cd_id_operacao <> ld_cd_operacao) OR (cd_id_talhao <> ld_cd_talhao))
  • Rows Removed by Filter: 66948
57.          

CTE trechos

58. 5.494 3,665.553 ↓ 57.6 461 1

GroupAggregate (cost=565,960.67..565,960.93 rows=8 width=48) (actual time=3,656.471..3,665.553 rows=461 loops=1)

  • Group Key: lal.cd_cliente, lal.cd_id_equipamento, lal.cd_id_operacao, lal.cd_id_talhao, lal.dt_fim_trecho_anterior, lal.dt_fim
59. 35.627 3,660.059 ↓ 8,643.1 69,145 1

Sort (cost=565,960.67..565,960.69 rows=8 width=48) (actual time=3,656.448..3,660.059 rows=69,145 loops=1)

  • Sort Key: lal.cd_cliente, lal.cd_id_equipamento, lal.cd_id_operacao, lal.cd_id_talhao, lal.dt_fim_trecho_anterior, lal.dt_fim
  • Sort Method: quicksort Memory: 8474kB
60. 7.316 3,624.432 ↓ 8,643.1 69,145 1

Nested Loop (cost=0.56..565,960.55 rows=8 width=48) (actual time=2,341.434..3,624.432 rows=69,145 loops=1)

61. 2,342.530 2,342.530 ↓ 1.2 474 1

CTE Scan on last_and_lag lal (cost=0.00..8.22 rows=411 width=32) (actual time=2,341.282..2,342.530 rows=474 loops=1)

62. 8.058 1,274.586 ↓ 14.6 146 474

Append (cost=0.56..1,376.91 rows=10 width=32) (actual time=0.249..2.689 rows=146 loops=474)

63. 148.836 148.836 ↓ 15.0 15 474

Index Scan using ddn_mapa10_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa10 glot_10 (cost=0.56..140.32 rows=1 width=32) (actual time=0.099..0.314 rows=15 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 6
64. 127.506 127.506 ↓ 14.0 14 474

Index Scan using ddn_mapa11_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa11 glot_11 (cost=0.56..138.31 rows=1 width=32) (actual time=0.073..0.269 rows=14 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 6
65. 124.188 124.188 ↓ 15.0 15 474

Index Scan using ddn_mapa12_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa12 glot_12 (cost=0.56..138.71 rows=1 width=32) (actual time=0.082..0.262 rows=15 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 6
66. 127.032 127.032 ↓ 15.0 15 474

Index Scan using ddn_mapa13_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa13 glot_13 (cost=0.56..137.26 rows=1 width=32) (actual time=0.081..0.268 rows=15 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 6
67. 122.766 122.766 ↓ 15.0 15 474

Index Scan using ddn_mapa14_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa14 glot_14 (cost=0.56..137.86 rows=1 width=32) (actual time=0.074..0.259 rows=15 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 6
68. 123.240 123.240 ↓ 15.0 15 474

Index Scan using ddn_mapa15_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa15 glot_15 (cost=0.56..137.32 rows=1 width=32) (actual time=0.083..0.260 rows=15 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 7
69. 122.766 122.766 ↓ 14.0 14 474

Index Scan using ddn_mapa16_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa16 glot_16 (cost=0.56..135.54 rows=1 width=32) (actual time=0.082..0.259 rows=14 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 6
70. 122.292 122.292 ↓ 15.0 15 474

Index Scan using ddn_mapa17_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa17 glot_17 (cost=0.56..137.60 rows=1 width=32) (actual time=0.076..0.258 rows=15 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 6
71. 123.240 123.240 ↓ 15.0 15 474

Index Scan using ddn_mapa18_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa18 glot_18 (cost=0.56..136.89 rows=1 width=32) (actual time=0.084..0.260 rows=15 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 6
72. 124.662 124.662 ↓ 15.0 15 474

Index Scan using ddn_mapa19_cd_cliente_cd_id_equipamento_dt_hr_utc_inicial_d_idx on ddn_mapa19 glot_19 (cost=0.56..137.05 rows=1 width=32) (actual time=0.079..0.263 rows=15 loops=474)

  • Index Cond: ((cd_cliente = lal.cd_cliente) AND (cd_id_equipamento = lal.cd_id_equipamento) AND (dt_hr_utc_inicial >= lal.dt_fim_trecho_anterior) AND (dt_hr_utc_final <= lal.dt_fim))
  • Filter: (((cd_id_operacao_cb = lal.cd_id_operacao) OR (cd_id_operacao_cb IS NULL)) AND ((cd_id_talhao = lal.cd_id_talhao) OR (cd_id_talhao IS NULL)))
  • Rows Removed by Filter: 6
Planning time : 23.576 ms