explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ajge

Settings
# exclusive inclusive rows x rows loops node
1. 4,670.626 4,670.626 ↓ 57.6 461 1

CTE Scan on trechos (cost=569,101.45..569,101.61 rows=8 width=32) (actual time=4,661.614..4,670.626 rows=461 loops=1)

  • Functions: 319
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 27.579 ms, Inlining 41.130 ms, Optimization 1452.603 ms, Emission 775.656 ms, Total 2296.969 ms
2.          

CTE dataset

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

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

4.          

Initplan (for Append)

5. 0.002 0.739 ↑ 1.0 1 1

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

6.          

Initplan (for Subquery Scan)

7. 0.003 0.616 ↑ 1.0 1 1

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

8.          

Initplan (for Result)

9. 0.005 0.613 ↑ 1.0 1 1

Limit (cost=5.74..5.98 rows=1 width=8) (actual time=0.610..0.613 rows=1 loops=1)

10. 0.003 0.608 ↑ 10,692.0 1 1

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

  • Sort Key: ddn_mapa10.dt_hr_utc_inicial
11. 0.094 0.094 ↑ 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.094..0.094 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.052 0.052 ↑ 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.052..0.052 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.049 0.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=0.049..0.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.074 0.074 ↑ 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.074..0.074 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.036 0.036 ↑ 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.036..0.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
16. 0.073 0.073 ↑ 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.073..0.073 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.068 0.068 ↑ 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.068..0.068 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.070 0.070 ↑ 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.070..0.070 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.050 0.050 ↑ 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.049..0.050 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.039 0.039 ↑ 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.039..0.039 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.006 0.121 ↑ 1.0 1 1

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

22. 0.115 0.115 ↓ 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.115..0.115 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 168.950 ↑ 1.0 1 1

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

24.          

Initplan (for Subquery Scan)

25. 5.145 168.917 ↑ 1.0 1 1

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

26. 8.095 163.772 ↓ 10.1 107,619 1

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

27. 39.238 39.238 ↓ 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.010..39.238 rows=10,794 loops=1)

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

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

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 2720
30. 14.287 14.287 ↓ 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.028..14.287 rows=10,901 loops=1)

  • Index Cond: ((cd_cliente = 4) AND (cd_id_equipamento = 1475))
  • Heap Fetches: 5513
31. 13.306 13.306 ↓ 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.029..13.306 rows=10,777 loops=1)

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

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

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

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

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

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

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

38. 0.025 0.025 ↓ 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.025..0.025 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,454.713 2,454.713 ↓ 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,443.814..2,454.713 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. 16.718 16.718 ↓ 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.030..16.718 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. 16.790 16.790 ↓ 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.031..16.790 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. 15.783 15.783 ↓ 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.030..15.783 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. 16.740 16.740 ↓ 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.029..16.740 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. 17.958 17.958 ↓ 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.032..17.958 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. 17.148 17.148 ↓ 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.034..17.148 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. 16.553 16.553 ↓ 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.028..16.553 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. 15.172 15.172 ↓ 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.030..15.172 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. 13.106 13.106 ↓ 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.033..13.106 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.460 2,708.742 ↓ 164.0 67,422 1

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

51. 46.604 2,674.282 ↓ 164.0 67,422 1

Sort (cost=26.06..27.09 rows=411 width=32) (actual time=2,670.790..2,674.282 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,627.678 2,627.678 ↓ 164.0 67,422 1

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

53.          

CTE last_and_lag

54. 1.499 2,727.415 ↓ 1.2 474 1

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

55. 0.343 2,725.916 ↓ 1.2 474 1

Sort (cost=28.12..29.15 rows=411 width=24) (actual time=2,725.701..2,725.916 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,725.573 2,725.573 ↓ 1.2 474 1

CTE Scan on lead_operacao_talhao lot (cost=0.00..10.28 rows=411 width=24) (actual time=2,670.866..2,725.573 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.452 4,670.458 ↓ 57.6 461 1

GroupAggregate (cost=565,748.58..565,748.84 rows=8 width=48) (actual time=4,661.610..4,670.458 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. 42.066 4,665.006 ↓ 8,643.1 69,145 1

Sort (cost=565,748.58..565,748.60 rows=8 width=48) (actual time=4,661.587..4,665.006 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. 10.371 4,622.940 ↓ 8,643.1 69,145 1

Nested Loop (cost=0.56..565,748.46 rows=8 width=48) (actual time=2,725.873..4,622.940 rows=69,145 loops=1)

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

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

62. 12.798 1,884.624 ↓ 14.6 146 474

Append (cost=0.56..1,376.40 rows=10 width=32) (actual time=0.364..3.976 rows=146 loops=474)

63. 217.566 217.566 ↓ 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.145..0.459 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. 193.392 193.392 ↓ 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.125..0.408 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. 181.068 181.068 ↓ 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.118..0.382 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. 186.282 186.282 ↓ 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.118..0.393 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. 187.704 187.704 ↓ 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.35 rows=1 width=32) (actual time=0.128..0.396 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. 182.016 182.016 ↓ 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.127..0.384 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. 178.698 178.698 ↓ 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.122..0.377 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. 178.698 178.698 ↓ 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.110..0.377 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. 182.016 182.016 ↓ 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.123..0.384 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. 184.386 184.386 ↓ 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.121..0.389 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 : 45.211 ms