explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3oBm

Settings
# exclusive inclusive rows x rows loops node
1. 86,997.469 86,997.469 ↓ 57.6 461 1

CTE Scan on trechos (cost=569,569.60..569,569.76 rows=8 width=32) (actual time=86,970.310..86,997.469 rows=461 loops=1)

  • Functions: 319
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 70.038 ms, Inlining 13.312 ms, Optimization 2062.362 ms, Emission 1156.000 ms, Total 3301.712 ms
2.          

CTE dataset

3. 0.000 83,760.352 ↓ 164.0 67,422 1

Append (cost=2,459.40..3,283.14 rows=411 width=32) (actual time=39,026.496..83,760.352 rows=67,422 loops=1)

4.          

Initplan (for Append)

5. 0.005 10.432 ↑ 1.0 1 1

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

6.          

Initplan (for Subquery Scan)

7. 0.004 10.351 ↑ 1.0 1 1

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

8.          

Initplan (for Result)

9. 0.008 10.347 ↑ 1.0 1 1

Limit (cost=5.74..5.98 rows=1 width=8) (actual time=10.342..10.347 rows=1 loops=1)

10. 0.009 10.339 ↑ 10,700.0 1 1

Merge Append (cost=5.74..2,567.38 rows=10,700 width=8) (actual time=10.339..10.339 rows=1 loops=1)

  • Sort Key: ddn_mapa10.dt_hr_utc_inicial
11. 1.181 1.181 ↑ 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=1.181..1.181 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.730 0.730 ↑ 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.729..0.730 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. 1.049 1.049 ↑ 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=1.049..1.049 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.976 0.976 ↑ 1,039.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..286.68 rows=1,039 width=8) (actual time=0.976..0.976 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. 1.008 1.008 ↑ 1,043.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..284.27 rows=1,043 width=8) (actual time=1.008..1.008 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. 1.036 1.036 ↑ 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=1.036..1.036 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. 1.049 1.049 ↑ 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=1.049..1.049 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. 1.117 1.117 ↑ 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=1.117..1.117 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. 1.139 1.139 ↑ 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=1.139..1.139 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. 1.045 1.045 ↑ 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=1.045..1.045 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.008 0.076 ↑ 1.0 1 1

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

22. 0.068 0.068 ↓ 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.068..0.068 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.006 35,778.832 ↑ 1.0 1 1

Subquery Scan on t_1 (cost=2,404.71..2,404.73 rows=1 width=8) (actual time=35,778.831..35,778.832 rows=1 loops=1)

24.          

Initplan (for Subquery Scan)

25. 24.015 35,778.772 ↑ 1.0 1 1

Aggregate (cost=2,389.49..2,389.50 rows=1 width=8) (actual time=35,778.772..35,778.772 rows=1 loops=1)

26. 20.326 35,754.757 ↓ 10.1 107,619 1

Append (cost=0.56..2,362.74 rows=10,700 width=8) (actual time=0.021..35,754.757 rows=107,619 loops=1)

27. 6,641.760 6,641.760 ↓ 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.021..6,641.760 rows=10,794 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 10754
28. 1,930.647 1,930.647 ↓ 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.035..1,930.647 rows=10,572 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 2705
29. 1,985.701 1,985.701 ↓ 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.039..1,985.701 rows=10,795 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 2723
30. 4,201.702 4,201.702 ↓ 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..284.08 rows=1,039 width=8) (actual time=0.042..4,201.702 rows=10,901 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 5513
31. 3,925.232 3,925.232 ↓ 10.3 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..281.67 rows=1,043 width=8) (actual time=0.037..3,925.232 rows=10,777 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 5266
32. 3,283.798 3,283.798 ↓ 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.040..3,283.798 rows=10,970 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 4993
33. 3,173.117 3,173.117 ↓ 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.039..3,173.117 rows=10,652 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 4881
34. 3,293.899 3,293.899 ↓ 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.041..3,293.899 rows=10,644 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 5010
35. 3,691.623 3,691.623 ↓ 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.037..3,691.623 rows=10,703 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 4992
36. 3,606.952 3,606.952 ↓ 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.038..3,606.952 rows=10,811 loops=1)

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

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

38. 0.051 0.051 ↓ 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.051..0.051 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. 39,057.788 39,057.788 ↓ 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=39,026.495..39,057.788 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. 5,960.194 5,960.194 ↓ 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.388..5,960.194 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. 6,303.245 6,303.245 ↓ 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.039..6,303.245 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. 3,835.678 3,835.678 ↓ 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.35 rows=40 width=32) (actual time=0.044..3,835.678 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. 3,753.326 3,753.326 ↓ 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..80.03 rows=40 width=32) (actual time=0.036..3,753.326 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. 4,038.405 4,038.405 ↓ 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.046..4,038.405 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. 4,006.247 4,006.247 ↓ 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.051..4,006.247 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. 3,936.468 3,936.468 ↓ 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.038..3,936.468 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. 5,246.140 5,246.140 ↓ 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.036..5,246.140 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. 7,611.289 7,611.289 ↓ 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.051..7,611.289 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. 122.023 84,079.856 ↓ 164.0 67,422 1

WindowAgg (cost=26.06..37.37 rows=411 width=40) (actual time=83,945.834..84,079.856 rows=67,422 loops=1)

51. 140.194 83,957.833 ↓ 164.0 67,422 1

Sort (cost=26.06..27.09 rows=411 width=32) (actual time=83,945.799..83,957.833 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. 83,817.639 83,817.639 ↓ 164.0 67,422 1

CTE Scan on dataset d (cost=0.00..8.22 rows=411 width=32) (actual time=39,026.501..83,817.639 rows=67,422 loops=1)

53.          

CTE last_and_lag

54. 1.900 84,132.863 ↓ 1.2 474 1

WindowAgg (cost=28.12..37.37 rows=411 width=32) (actual time=84,130.729..84,132.863 rows=474 loops=1)

55. 0.483 84,130.963 ↓ 1.2 474 1

Sort (cost=28.12..29.15 rows=411 width=24) (actual time=84,130.708..84,130.963 rows=474 loops=1)

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

CTE Scan on lead_operacao_talhao lot (cost=0.00..10.28 rows=411 width=24) (actual time=83,945.891..84,130.480 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. 20.886 86,997.171 ↓ 57.6 461 1

GroupAggregate (cost=566,211.46..566,211.72 rows=8 width=48) (actual time=86,970.305..86,997.171 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. 68.378 86,976.285 ↓ 8,643.1 69,145 1

Sort (cost=566,211.46..566,211.48 rows=8 width=48) (actual time=86,970.276..86,976.285 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. 14.238 86,907.907 ↓ 8,643.1 69,145 1

Nested Loop (cost=0.56..566,211.34 rows=8 width=48) (actual time=84,130.897..86,907.907 rows=69,145 loops=1)

61. 84,133.567 84,133.567 ↓ 1.2 474 1

CTE Scan on last_and_lag lal (cost=0.00..8.22 rows=411 width=32) (actual time=84,130.731..84,133.567 rows=474 loops=1)

62. 14.694 2,760.102 ↓ 14.6 146 474

Append (cost=0.56..1,377.52 rows=10 width=32) (actual time=0.547..5.823 rows=146 loops=474)

63. 318.528 318.528 ↓ 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.211..0.672 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. 255.486 255.486 ↓ 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.129..0.539 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. 326.586 326.586 ↓ 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.245..0.689 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. 290.088 290.088 ↓ 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.81 rows=1 width=32) (actual time=0.168..0.612 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. 273.972 273.972 ↓ 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.92 rows=1 width=32) (actual time=0.187..0.578 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. 259.278 259.278 ↓ 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.198..0.547 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. 267.336 267.336 ↓ 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.202..0.564 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. 237.000 237.000 ↓ 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.159..0.500 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. 240.792 240.792 ↓ 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.148..0.508 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. 276.342 276.342 ↓ 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.199..0.583 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 : 51.597 ms