# | 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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
Planning time | : | 51.597 ms |
---|