# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.064 | 1,194.921 | ↓ 1.3 | 67 | 1 |
→
Sort (cost=7,040,751.44..7,040,751.57 rows=52 width=952) (actual time=1,194.919..1,194.921 rows=67 loops=1)
|
2. |
CTE caixa_meta |
|||||
3. | 0.009 | 0.016 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=2.65..2.66 rows=1 width=24) (actual time=0.015..0.016 rows=1 loops=1) |
4. | 0.007 | 0.007 | ↑ 1.0 | 1 | 1 |
→
Index Scan using caixa_pkey on caixa cai_6 (cost=0.42..2.64 rows=1 width=12) (actual time=0.006..0.007 rows=1 loops=1)
|
5. | 0.274 | 1,194.857 | ↓ 1.3 | 67 | 1 |
→
WindowAgg (cost=7,040,742.23..7,040,747.30 rows=52 width=952) (actual time=1,194.598..1,194.857 rows=67 loops=1) |
6. | 0.065 | 1,194.583 | ↓ 1.3 | 67 | 1 |
→
Sort (cost=7,040,742.23..7,040,742.36 rows=52 width=728) (actual time=1,194.580..1,194.583 rows=67 loops=1)
|
7. | 0.045 | 1,194.518 | ↓ 1.3 | 67 | 1 |
→
Group (cost=7,040,737.24..7,040,740.75 rows=52 width=728) (actual time=1,194.474..1,194.518 rows=67 loops=1)
|
8. | 0.151 | 1,194.473 | ↓ 1.3 | 67 | 1 |
→
Sort (cost=7,040,737.24..7,040,737.37 rows=52 width=728) (actual time=1,194.471..1,194.473 rows=67 loops=1)
|
9. | 0.130 | 1,194.322 | ↓ 1.3 | 67 | 1 |
→
Nested Loop (cost=4,394,178.31..7,040,735.76 rows=52 width=728) (actual time=788.217..1,194.322 rows=67 loops=1) |
10. | 0.069 | 813.230 | ↓ 1.3 | 67 | 1 |
→
Nested Loop (cost=4,392,829.56..6,970,598.55 rows=52 width=632) (actual time=786.313..813.230 rows=67 loops=1) |
11. | 0.900 | 796.880 | ↓ 1.3 | 67 | 1 |
→
GroupAggregate (cost=4,392,816.65..6,969,924.68 rows=52 width=604) (actual time=786.298..796.880 rows=67 loops=1)
|
12. |
Initplan (for GroupAggregate) |
|||||
13. | 0.003 | 0.008 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=2.65..2.65 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1) |
14. | 0.005 | 0.005 | ↑ 1.0 | 1 | 1 |
→
Index Scan using caixa_pkey on caixa caii (cost=0.42..2.64 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=1)
|
15. | 1.092 | 786.375 | ↓ 11.9 | 621 | 1 |
→
Sort (cost=4,392,813.99..4,392,814.12 rows=52 width=580) (actual time=786.276..786.375 rows=621 loops=1)
|
16. | 0.296 | 785.283 | ↓ 11.9 | 621 | 1 |
→
Subquery Scan on abt (cost=3.11..4,392,812.51 rows=52 width=580) (actual time=0.097..785.283 rows=621 loops=1) |
17. | 0.137 | 784.987 | ↓ 11.9 | 621 | 1 |
→
Append (cost=3.11..4,392,811.99 rows=52 width=612) (actual time=0.096..784.987 rows=621 loops=1) |
18. | 0.460 | 15.310 | ↓ 36.4 | 618 | 1 |
→
Subquery Scan on *SELECT* 1 (cost=3.11..3,450.62 rows=17 width=192) (actual time=0.095..15.310 rows=618 loops=1) |
19. | 1.026 | 14.850 | ↓ 36.4 | 618 | 1 |
→
Nested Loop (cost=3.11..3,450.37 rows=17 width=136) (actual time=0.093..14.850 rows=618 loops=1) |
20. | 0.571 | 12.588 | ↓ 36.4 | 618 | 1 |
→
Nested Loop (cost=2.83..3,411.63 rows=17 width=91) (actual time=0.082..12.588 rows=618 loops=1) |
21. | 0.835 | 10.163 | ↓ 36.4 | 618 | 1 |
→
Nested Loop (cost=2.41..3,368.62 rows=17 width=63) (actual time=0.071..10.163 rows=618 loops=1) |
22. | 0.369 | 8.092 | ↓ 36.4 | 618 | 1 |
→
Nested Loop (cost=2.12..3,328.88 rows=17 width=51) (actual time=0.063..8.092 rows=618 loops=1) |
23. | 0.494 | 4.383 | ↓ 35.2 | 668 | 1 |
→
Nested Loop (cost=1.56..3,278.06 rows=19 width=18) (actual time=0.051..4.383 rows=668 loops=1) |
24. | 0.154 | 0.914 | ↓ 74.4 | 595 | 1 |
→
Nested Loop (cost=0.99..350.31 rows=8 width=12) (actual time=0.039..0.914 rows=595 loops=1) |
25. | 0.018 | 0.018 | ↑ 1.0 | 1 | 1 |
→
Index Scan using caixa_pkey on caixa cai (cost=0.42..2.65 rows=1 width=12) (actual time=0.018..0.018 rows=1 loops=1)
|
26. | 0.742 | 0.742 | ↓ 74.4 | 595 | 1 |
→
Index Scan using venda_idx_caixa on venda ven (cost=0.56..347.59 rows=8 width=12) (actual time=0.019..0.742 rows=595 loops=1)
|
27. | 2.975 | 2.975 | ↑ 412.0 | 1 | 595 |
→
Index Scan using venda_item_idx_venda_rebuild_1 on venda_item vei (cost=0.57..361.85 rows=412 width=14) (actual time=0.004..0.005 rows=1 loops=595)
|
28. | 3.340 | 3.340 | ↑ 1.0 | 1 | 668 |
→
Index Scan using abastecimento_abt_cd_venda_item_key on abastecimento abt_1 (cost=0.57..2.67 rows=1 width=41) (actual time=0.005..0.005 rows=1 loops=668)
|
29. | 1.236 | 1.236 | ↑ 1.0 | 1 | 618 |
→
Index Scan using bico_pkey on bico bic (cost=0.28..2.34 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=618)
|
30. | 1.854 | 1.854 | ↑ 1.0 | 1 | 618 |
→
Index Scan using produto_pkey on produto pro (cost=0.42..2.53 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=618)
|
31. | 1.236 | 1.236 | ↑ 1.0 | 1 | 618 |
→
Index Scan using bomba_pkey on bomba bom (cost=0.28..2.28 rows=1 width=13) (actual time=0.002..0.002 rows=1 loops=618)
|
32. | 0.000 | 0.254 | ↓ 0.0 | 0 | 1 |
→
Subquery Scan on *SELECT* 2 (cost=2.40..60.53 rows=1 width=218) (actual time=0.254..0.254 rows=0 loops=1) |
33. | 0.000 | 0.254 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=2.40..60.51 rows=1 width=134) (actual time=0.254..0.254 rows=0 loops=1)
|
34. | 0.001 | 0.254 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=1.97..57.85 rows=1 width=90) (actual time=0.254..0.254 rows=0 loops=1) |
35. | 0.001 | 0.253 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=1.69..56.00 rows=1 width=85) (actual time=0.253..0.253 rows=0 loops=1) |
36. | 0.000 | 0.252 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=1.27..53.36 rows=1 width=57) (actual time=0.252..0.252 rows=0 loops=1) |
37. | 0.030 | 0.252 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=0.99..51.39 rows=1 width=45) (actual time=0.252..0.252 rows=0 loops=1) |
38. | 0.030 | 0.030 | ↓ 3.7 | 48 | 1 |
→
Index Scan using abastecimento_afericao_idx_aba_cd_caixa on abastecimento_afericao aba (cost=0.42..15.15 rows=13 width=8) (actual time=0.010..0.030 rows=48 loops=1)
|
39. | 0.192 | 0.192 | ↓ 0.0 | 0 | 48 |
→
Index Scan using abastecimento_pkey on abastecimento abt_2 (cost=0.57..2.79 rows=1 width=45) (actual time=0.004..0.004 rows=0 loops=48)
|
40. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using bico_pkey on bico bic_1 (cost=0.28..1.88 rows=1 width=20) (never executed)
|
|
41. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using produto_pkey on produto pro_1 (cost=0.42..2.64 rows=1 width=32) (never executed)
|
|
42. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using bomba_pkey on bomba bom_1 (cost=0.28..1.85 rows=1 width=13) (never executed)
|
|
43. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using caixa_pkey on caixa cai_1 (cost=0.42..2.65 rows=1 width=12) (never executed)
|
|
44. | 0.007 | 769.286 | ↑ 11.3 | 3 | 1 |
→
Subquery Scan on *SELECT* 3 (cost=949.81..4,389,300.58 rows=34 width=321) (actual time=52.505..769.286 rows=3 loops=1) |
45. | 0.273 | 769.279 | ↑ 11.3 | 3 | 1 |
→
Nested Loop Anti Join (cost=949.81..4,389,299.73 rows=34 width=153) (actual time=52.502..769.279 rows=3 loops=1)
|
46. | 0.068 | 763.600 | ↑ 1.0 | 34 | 1 |
→
Nested Loop (cost=947.69..4,388,576.97 rows=34 width=93) (actual time=47.183..763.600 rows=34 loops=1) |
47. | 0.059 | 2.986 | ↑ 1.0 | 34 | 1 |
→
Nested Loop (cost=0.98..7,154.70 rows=34 width=57) (actual time=0.246..2.986 rows=34 loops=1) |
48. | 0.080 | 2.791 | ↑ 1.0 | 34 | 1 |
→
Nested Loop (cost=0.70..7,076.46 rows=34 width=52) (actual time=0.241..2.791 rows=34 loops=1) |
49. | 0.053 | 2.507 | ↑ 1.0 | 34 | 1 |
→
Nested Loop (cost=0.28..6,986.70 rows=34 width=24) (actual time=0.234..2.507 rows=34 loops=1) |
50. | 2.420 | 2.420 | ↑ 1.0 | 34 | 1 |
→
Index Scan using bico_pkey on bico bic_2 (cost=0.28..6,986.01 rows=34 width=16) (actual time=0.213..2.420 rows=34 loops=1)
|
51. | 0.034 | 0.034 | ↑ 1.0 | 1 | 34 |
→
CTE Scan on caixa_meta cm (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=34) |
52. | 0.204 | 0.204 | ↑ 1.0 | 1 | 34 |
→
Index Scan using produto_pkey on produto pro_2 (cost=0.42..2.64 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=34)
|
53. | 0.136 | 0.136 | ↑ 1.0 | 1 | 34 |
→
Index Scan using bomba_pkey on bomba bom_2 (cost=0.28..2.30 rows=1 width=13) (actual time=0.004..0.004 rows=1 loops=34)
|
54. | 0.102 | 760.546 | ↑ 1.0 | 1 | 34 |
→
Limit (cost=946.71..128,865.34 rows=1 width=36) (actual time=22.367..22.369 rows=1 loops=34) |
55. | 2.210 | 760.444 | ↑ 1.0 | 1 | 34 |
→
GroupAggregate (cost=946.71..128,865.34 rows=1 width=36) (actual time=22.366..22.366 rows=1 loops=34)
|
56. | 47.158 | 758.234 | ↑ 10.4 | 76 | 34 |
→
Nested Loop (cost=946.71..128,855.48 rows=788 width=36) (actual time=1.813..22.301 rows=76 loops=34) |
57. | 9.792 | 147.254 | ↓ 3.0 | 2,369 | 34 |
→
Nested Loop (cost=946.70..127,271.60 rows=788 width=1,399) (actual time=1.361..4.331 rows=2,369 loops=34) |
58. | 0.510 | 84.150 | ↑ 24.8 | 14 | 34 |
→
Nested Loop (cost=946.14..14,022.68 rows=347 width=8) (actual time=1.355..2.475 rows=14 loops=34) |
59. | 0.034 | 0.034 | ↑ 1.0 | 1 | 34 |
→
CTE Scan on caixa_meta cm_2 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.001 rows=1 loops=34) |
60. | 74.630 | 83.606 | ↑ 24.8 | 14 | 34 |
→
Bitmap Heap Scan on caixa cai_3 (cost=946.14..14,019.19 rows=347 width=20) (actual time=1.342..2.459 rows=14 loops=34)
|
61. | 8.976 | 8.976 | ↑ 16.2 | 4,103 | 34 |
→
Bitmap Index Scan on caixa_idx_data_pdv_turno (cost=0.00..946.05 rows=66,402 width=0) (actual time=0.264..0.264 rows=4,103 loops=34)
|
62. | 53.312 | 53.312 | ↓ 21.1 | 169 | 476 |
→
Index Scan using venda_idx_caixa on venda ven_2 (cost=0.56..326.29 rows=8 width=1,407) (actual time=0.006..0.112 rows=169 loops=476)
|
63. | 563.822 | 563.822 | ↓ 0.0 | 0 | 80,546 |
→
Function Scan on jsonb_array_elements vei_2 (cost=0.01..2.00 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=80,546)
|
64. | 0.222 | 5.406 | ↓ 55.5 | 111 | 34 |
→
Materialize (cost=2.12..721.75 rows=2 width=4) (actual time=0.002..0.159 rows=111 loops=34) |
65. | 0.550 | 5.184 | ↓ 309.0 | 618 | 1 |
→
Nested Loop (cost=2.12..721.74 rows=2 width=4) (actual time=0.040..5.184 rows=618 loops=1) |
66. | 0.016 | 3.298 | ↓ 334.0 | 668 | 1 |
→
Nested Loop (cost=1.56..716.39 rows=2 width=4) (actual time=0.030..3.298 rows=668 loops=1) |
67. | 0.421 | 1.497 | ↓ 595.0 | 595 | 1 |
→
Nested Loop (cost=0.99..350.42 rows=1 width=4) (actual time=0.020..1.497 rows=595 loops=1) |
68. | 0.095 | 0.481 | ↓ 595.0 | 595 | 1 |
→
Nested Loop (cost=0.56..347.77 rows=1 width=8) (actual time=0.013..0.481 rows=595 loops=1)
|
69. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on caixa_meta cm_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.001 rows=1 loops=1) |
70. | 0.385 | 0.385 | ↓ 74.4 | 595 | 1 |
→
Index Scan using venda_idx_caixa on venda ven_1 (cost=0.56..347.59 rows=8 width=12) (actual time=0.010..0.385 rows=595 loops=1)
|
71. | 0.595 | 0.595 | ↑ 1.0 | 1 | 595 |
→
Index Only Scan using caixa_pkey on caixa cai_2 (cost=0.42..2.64 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=595)
|
72. | 1.785 | 1.785 | ↑ 412.0 | 1 | 595 |
→
Index Scan using venda_item_idx_venda_rebuild_1 on venda_item vei_1 (cost=0.57..361.85 rows=412 width=8) (actual time=0.003..0.003 rows=1 loops=595)
|
73. | 1.336 | 1.336 | ↑ 1.0 | 1 | 668 |
→
Index Scan using abastecimento_abt_cd_venda_item_key on abastecimento abt_3 (cost=0.57..2.67 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=668)
|
74. |
SubPlan (for GroupAggregate) |
|||||
75. | 0.039 | 9.597 | ↑ 1.0 | 1 | 3 |
→
Hash Join (cost=351.04..49,559.68 rows=1 width=0) (actual time=3.199..3.199 rows=1 loops=3)
|
76. | 0.013 | 8.640 | ↑ 2,711.3 | 3 | 3 |
→
Nested Loop (cost=1.14..49,188.42 rows=8,134 width=4) (actual time=2.871..2.880 rows=3 loops=3) |
77. | 1.971 | 8.595 | ↑ 2,711.3 | 3 | 3 |
→
Nested Loop (cost=0.57..26,886.87 rows=8,134 width=4) (actual time=2.862..2.865 rows=3 loops=3)
|
78. | 0.000 | 0.000 | ↑ 1.0 | 1 | 3 |
→
CTE Scan on caixa_meta cm_5 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=3) |
79. | 6.624 | 6.624 | ↑ 6.4 | 3,813 | 3 |
→
Index Scan using abastecimento_idx_cd_bico on abastecimento abtc (cost=0.57..26,581.82 rows=24,402 width=8) (actual time=0.010..2.208 rows=3,813 loops=3)
|
80. | 0.032 | 0.032 | ↑ 1.0 | 1 | 8 |
→
Index Scan using venda_item_pkey on venda_item vei_6 (cost=0.57..2.74 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=8)
|
81. | 0.204 | 0.918 | ↓ 1.9 | 598 | 3 |
→
Hash (cost=346.04..346.04 rows=309 width=4) (actual time=0.306..0.306 rows=598 loops=3)
|
82. | 0.714 | 0.714 | ↓ 1.9 | 598 | 3 |
→
Index Scan using venda_idx_caixa on venda ven_6 (cost=0.56..346.04 rows=309 width=4) (actual time=0.008..0.238 rows=598 loops=3)
|
83. | 0.201 | 16.281 | ↑ 1.0 | 1 | 67 |
→
Aggregate (cost=12.92..12.93 rows=1 width=32) (actual time=0.243..0.243 rows=1 loops=67) |
84. | 0.402 | 16.080 | ↓ 10.0 | 10 | 67 |
→
Nested Loop (cost=2.12..12.91 rows=1 width=6) (actual time=0.067..0.240 rows=10 loops=67)
|
85. | 0.179 | 15.678 | ↓ 11.0 | 11 | 67 |
→
Nested Loop (cost=2.12..12.88 rows=1 width=14) (actual time=0.035..0.234 rows=11 loops=67) |
86. | 0.505 | 14.003 | ↓ 11.0 | 11 | 67 |
→
Nested Loop (cost=1.70..10.35 rows=1 width=14) (actual time=0.031..0.209 rows=11 loops=67) |
87. | 0.566 | 8.107 | ↓ 27.0 | 27 | 67 |
→
Nested Loop (cost=1.14..7.61 rows=1 width=14) (actual time=0.018..0.121 rows=27 loops=67) |
88. | 2.144 | 2.144 | ↓ 27.0 | 27 | 67 |
→
Index Scan using abt_unidade_dtfiscal_bico on abastecimento b (cost=0.57..4.83 rows=1 width=14) (actual time=0.012..0.032 rows=27 loops=67)
|
89. | 5.397 | 5.397 | ↑ 1.0 | 1 | 1,799 |
→
Index Scan using venda_item_pkey on venda_item vei_3 (cost=0.57..2.79 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1,799)
|
90. | 5.391 | 5.391 | ↓ 0.0 | 0 | 1,797 |
→
Index Scan using venda_pkey on venda ven_3 (cost=0.56..2.74 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=1,797)
|
91. | 1.496 | 1.496 | ↑ 1.0 | 1 | 748 |
→
Index Scan using caixa_pkey on caixa cai_4 (cost=0.42..2.53 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=748)
|
92. | 0.000 | 0.000 | ↑ 1.0 | 1 | 748 |
→
CTE Scan on caixa_meta cm_3 (cost=0.00..0.02 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=748) |
93. | 0.134 | 380.962 | ↑ 1.0 | 1 | 67 |
→
Aggregate (cost=1,348.74..1,348.75 rows=1 width=64) (actual time=5.686..5.686 rows=1 loops=67) |
94. | 0.670 | 380.828 | ↓ 0.0 | 0 | 67 |
→
Nested Loop (cost=2.69..1,348.73 rows=1 width=19) (actual time=5.421..5.684 rows=0 loops=67)
|
95. | 1.858 | 380.158 | ↓ 19.0 | 19 | 67 |
→
Nested Loop Semi Join (cost=2.69..1,348.70 rows=1 width=23) (actual time=0.623..5.674 rows=19 loops=67)
|
96. | 0.436 | 132.124 | ↓ 19.0 | 19 | 67 |
→
Nested Loop (cost=2.12..375.38 rows=1 width=35) (actual time=0.224..1.972 rows=19 loops=67) |
97. | 0.000 | 129.176 | ↓ 19.0 | 19 | 67 |
→
Nested Loop (cost=1.70..372.73 rows=1 width=35) (actual time=0.222..1.928 rows=19 loops=67) |
98. | 2.948 | 104.252 | ↓ 126.0 | 126 | 67 |
→
Nested Loop (cost=1.13..369.97 rows=1 width=12) (actual time=0.025..1.556 rows=126 loops=67) |
99. | 21.574 | 21.574 | ↓ 74.4 | 595 | 67 |
→
Index Scan using venda_idx_caixa on venda ven_4 (cost=0.56..347.59 rows=8 width=12) (actual time=0.005..0.322 rows=595 loops=67)
|
100. | 79.730 | 79.730 | ↓ 0.0 | 0 | 39,865 |
→
Index Scan using idx_tst_01_rebuild_1 on venda_item vei_4 (cost=0.57..2.79 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=39,865)
|
101. | 25.242 | 25.242 | ↓ 0.0 | 0 | 8,414 |
→
Index Scan using abastecimento_abt_cd_venda_item_key on abastecimento b_1 (cost=0.57..2.75 rows=1 width=35) (actual time=0.003..0.003 rows=0 loops=8,414)
|
102. | 2.512 | 2.512 | ↑ 1.0 | 1 | 1,256 |
→
Index Scan using caixa_pkey on caixa cai_5 (cost=0.42..2.65 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=1,256)
|
103. | 16.338 | 246.176 | ↑ 309.0 | 1 | 1,256 |
→
Nested Loop (cost=0.57..967.14 rows=309 width=36) (actual time=0.189..0.196 rows=1 loops=1,256) |
104. | 17.584 | 17.584 | ↑ 12.9 | 24 | 1,256 |
→
Index Scan using venda_idx_caixa on venda ven_5 (cost=0.56..346.04 rows=309 width=1,403) (actual time=0.005..0.014 rows=24 loops=1,256)
|
105. | 212.254 | 212.254 | ↓ 0.0 | 0 | 30,322 |
→
Function Scan on jsonb_array_elements vei_5 (cost=0.01..2.00 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=30,322)
|
106. | 0.000 | 0.000 | ↑ 1.0 | 1 | 1,256 |
→
CTE Scan on caixa_meta cm_4 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1,256) |
Planning time | : | 15.952 ms |
---|---|---|
Execution time | : | 1,195.794 ms |