explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b70y

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 81.731 ↑ 1.2 12 1

Sort (cost=8,593,317.24..8,593,317.28 rows=15 width=952) (actual time=81.731..81.731 rows=12 loops=1)

  • Sort Key: abt.referencia_bico, (min(COALESCE((min((b_1.abt_vl_encerrante - b_1.abt_vl_abastecimento))), (COALESCE(min(abt.encerrante_inicial_abt) FILTER (WHERE ((abt.data_abt >= $6) OR (NOT (SubPlan 3)))), '0'::numeric)))) OVER (?)), (max(CASE WHEN ((((max(abt.encerrante_final_abt)) - (COALESCE(min(abt.encerrante_inicial_abt) FILTER (WHERE ((abt.data_abt >= $6) OR (NOT (SubPlan 3)))), '0'::numeric))) - (sum(abt.quantidade_afericao))) > (COALESCE(sum(b.abt_vl_volume_abastecido), '0'::numeric))) THEN ((max(abt.encerrante_final_abt)) - (COALESCE(sum(b.abt_vl_volume_abastecido), '0'::numeric))) ELSE (max(abt.encerrante_final_abt)) END) OVER (?)), abt.preco_bomba
  • Sort Method: quicksort Memory: 28kB
2.          

CTE caixa_meta

3. 0.008 0.014 ↑ 1.0 1 1

Aggregate (cost=2.65..2.66 rows=1 width=24) (actual time=0.014..0.014 rows=1 loops=1)

4. 0.006 0.006 ↑ 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.005..0.006 rows=1 loops=1)

  • Index Cond: (cai_cd_caixa = 1353808)
5. 0.056 81.715 ↑ 1.2 12 1

WindowAgg (cost=8,593,312.82..8,593,314.29 rows=15 width=952) (actual time=81.675..81.715 rows=12 loops=1)

6. 0.009 81.659 ↑ 1.2 12 1

Sort (cost=8,593,312.82..8,593,312.86 rows=15 width=728) (actual time=81.658..81.659 rows=12 loops=1)

  • Sort Key: abt.bico, abt.substituicao, abt.produto
  • Sort Method: quicksort Memory: 26kB
7. 0.010 81.650 ↑ 1.2 12 1

Group (cost=8,593,311.52..8,593,312.53 rows=15 width=728) (actual time=81.642..81.650 rows=12 loops=1)

  • Group Key: abt.referencia_bico, abt.descricao_produto, (sum(abt.quantidade_afericao)), (sum(abt.qtd_abastecimento)), abt.preco_bomba, (CASE WHEN (sum((abt.valor_venda_item - abt.valor_abastecimento)) > '0'::numeric) THEN sum((abt.valor_venda_item - abt.valor_abastecimento)) ELSE '0'::numeric END), (CASE WHEN (sum((abt.valor_venda_item - abt.valor_abastecimento)) < '0'::numeric) THEN abs(sum((abt.valor_venda_item - abt.valor_abastecimento))) ELSE '0'::numeric END), (COALESCE(sum(abt.valor_venda_item), '0'::numeric)), abt.substituicao, abt.descricao_bomba, (COALESCE(min(abt.encerrante_inicial_abt) FILTER (WHERE ((abt.data_abt >= $6) OR (NOT (SubPlan 3)))), '0'::numeric)), (COALESCE(sum(b_1.abt_vl_volume_abastecido), '0'::numeric)), (max(abt.encerrante_final_abt)), (COALESCE(sum(b.abt_vl_volume_abastecido), '0'::numeric)), abt.bico, abt.produto, (((((abt.bico)::character varying)::text || ((abt.substituicao)::character varying)::text) || ((abt.produto)::character varying)::text)), (min((b_1.abt_vl_encerrante - b_1.abt_vl_abastecimento)))
8. 0.016 81.640 ↑ 1.2 12 1

Sort (cost=8,593,311.52..8,593,311.56 rows=15 width=728) (actual time=81.639..81.640 rows=12 loops=1)

  • Sort Key: abt.referencia_bico, abt.descricao_produto, (sum(abt.quantidade_afericao)), (sum(abt.qtd_abastecimento)), abt.preco_bomba, (CASE WHEN (sum((abt.valor_venda_item - abt.valor_abastecimento)) > '0'::numeric) THEN sum((abt.valor_venda_item - abt.valor_abastecimento)) ELSE '0'::numeric END), (CASE WHEN (sum((abt.valor_venda_item - abt.valor_abastecimento)) < '0'::numeric) THEN abs(sum((abt.valor_venda_item - abt.valor_abastecimento))) ELSE '0'::numeric END), (COALESCE(sum(abt.valor_venda_item), '0'::numeric)), abt.substituicao, abt.descricao_bomba, (COALESCE(min(abt.encerrante_inicial_abt) FILTER (WHERE ((abt.data_abt >= $6) OR (NOT (SubPlan 3)))), '0'::numeric)), (COALESCE(sum(b_1.abt_vl_volume_abastecido), '0'::numeric)), (max(abt.encerrante_final_abt)), (COALESCE(sum(b.abt_vl_volume_abastecido), '0'::numeric)), abt.bico, abt.produto, (((((abt.bico)::character varying)::text || ((abt.substituicao)::character varying)::text) || ((abt.produto)::character varying)::text)), (min((b_1.abt_vl_encerrante - b_1.abt_vl_abastecimento)))
  • Sort Method: quicksort Memory: 26kB
9. 0.020 81.624 ↑ 1.2 12 1

Nested Loop (cost=5,037,077.98..8,593,311.22 rows=15 width=728) (actual time=81.447..81.624 rows=12 loops=1)

10. 0.011 81.472 ↑ 1.2 12 1

Nested Loop (cost=4,874,703.87..6,157,698.89 rows=15 width=632) (actual time=81.417..81.472 rows=12 loops=1)

11. 0.031 81.425 ↑ 1.2 12 1

GroupAggregate (cost=4,873,828.22..6,144,563.57 rows=15 width=604) (actual time=81.404..81.425 rows=12 loops=1)

  • Group Key: abt.referencia_bico, abt.descricao_produto, abt.preco_bomba, abt.substituicao, abt.descricao_bomba, abt.produto, abt.bico
12.          

Initplan (for GroupAggregate)

13. 0.002 0.010 ↑ 1.0 1 1

Aggregate (cost=2.64..2.65 rows=1 width=4) (actual time=0.010..0.010 rows=1 loops=1)

14. 0.008 0.008 ↑ 1.0 1 1

Index Scan using caixa_pkey on caixa caii (cost=0.42..2.64 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (cai_cd_caixa = 1353808)
15. 0.017 81.384 ↑ 1.2 12 1

Sort (cost=4,873,825.57..4,873,825.61 rows=15 width=580) (actual time=81.383..81.384 rows=12 loops=1)

  • Sort Key: abt.referencia_bico, abt.descricao_produto, abt.preco_bomba, abt.substituicao, abt.descricao_bomba, abt.produto, abt.bico
  • Sort Method: quicksort Memory: 26kB
16. 0.004 81.367 ↑ 1.2 12 1

Subquery Scan on abt (cost=3.10..4,873,825.28 rows=15 width=580) (actual time=71.449..81.367 rows=12 loops=1)

17. 0.003 81.363 ↑ 1.2 12 1

Append (cost=3.10..4,873,825.13 rows=15 width=612) (actual time=71.448..81.363 rows=12 loops=1)

18. 0.000 0.102 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=3.10..987.77 rows=2 width=189) (actual time=0.102..0.102 rows=0 loops=1)

19. 0.000 0.102 ↓ 0.0 0 1

Nested Loop (cost=3.10..987.74 rows=2 width=133) (actual time=0.102..0.102 rows=0 loops=1)

20. 0.001 0.102 ↓ 0.0 0 1

Nested Loop (cost=2.82..983.24 rows=2 width=89) (actual time=0.102..0.102 rows=0 loops=1)

21. 0.000 0.101 ↓ 0.0 0 1

Nested Loop (cost=2.40..978.18 rows=2 width=62) (actual time=0.101..0.101 rows=0 loops=1)

22. 0.002 0.101 ↓ 0.0 0 1

Nested Loop (cost=2.12..973.50 rows=2 width=50) (actual time=0.101..0.101 rows=0 loops=1)

23. 0.006 0.079 ↓ 2.5 5 1

Nested Loop (cost=1.55..968.16 rows=2 width=17) (actual time=0.043..0.079 rows=5 loops=1)

24. 0.006 0.053 ↓ 4.0 4 1

Nested Loop (cost=0.99..499.20 rows=1 width=12) (actual time=0.032..0.053 rows=4 loops=1)

25. 0.027 0.027 ↓ 4.0 4 1

Index Scan using venda_idx_caixa on venda ven (cost=0.56..496.54 rows=1 width=12) (actual time=0.020..0.027 rows=4 loops=1)

  • Index Cond: (ven_cd_caixa = 1353808)
  • Filter: ((ven_cd_unidade_negocio = 647) AND (ven_fl_cancelada = 'N'::bpchar))
26. 0.020 0.020 ↑ 1.0 1 4

Index Scan using caixa_pkey on caixa cai (cost=0.42..2.64 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=4)

  • Index Cond: (cai_cd_caixa = 1353808)
  • Filter: (cai_cd_unidade_negocio = 647)
27. 0.020 0.020 ↑ 427.0 1 4

Index Scan using venda_item_idx_venda_rebuild_2 on venda_item vei (cost=0.57..464.69 rows=427 width=13) (actual time=0.004..0.005 rows=1 loops=4)

  • Index Cond: (vei_cd_venda = ven.ven_cd_venda)
28. 0.020 0.020 ↓ 0.0 0 5

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.004..0.004 rows=0 loops=5)

  • Index Cond: (abt_cd_venda_item = vei.vei_cd_venda_item)
  • Filter: (NOT abt_bl_afericao)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using bico_pkey on bico bic (cost=0.28..2.34 rows=1 width=16) (never executed)

  • Index Cond: (bic_cd_bico = abt_1.abt_cd_bico)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using produto_pkey on produto pro (cost=0.42..2.53 rows=1 width=31) (never executed)

  • Index Cond: (pro_cd_produto = bic.bic_cd_produto)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using bomba_pkey on bomba bom (cost=0.28..2.24 rows=1 width=12) (never executed)

  • Index Cond: (bom_cd_bomba = bic.bic_cd_bomba)
32. 0.001 0.008 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=2.26..38.67 rows=1 width=216) (actual time=0.007..0.008 rows=0 loops=1)

33. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=2.26..38.65 rows=1 width=132) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (abt_2.abt_dt_abastecimento >= cai_1.cai_dt_movimento)
34. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.84..35.99 rows=1 width=88) (actual time=0.007..0.007 rows=0 loops=1)

35. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=1.56..34.04 rows=1 width=84) (actual time=0.007..0.007 rows=0 loops=1)

36. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.14..31.40 rows=1 width=57) (actual time=0.006..0.006 rows=0 loops=1)

37. 0.000 0.006 ↓ 0.0 0 1

Nested Loop (cost=0.86..29.49 rows=1 width=45) (actual time=0.006..0.006 rows=0 loops=1)

38. 0.006 0.006 ↓ 0.0 0 1

Index Scan using abastecimento_afericao_idx_aba_cd_caixa on abastecimento_afericao aba (cost=0.29..4.40 rows=9 width=8) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (aba_cd_caixa = 1353808)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using abastecimento_pkey on abastecimento abt_2 (cost=0.57..2.79 rows=1 width=45) (never executed)

  • Index Cond: (abt_cd_abastecimento = aba.aba_cd_abastecimento)
  • Filter: ((NOT abt_bl_afericao) AND (abt_cd_unidade_negocio = 647))
40. 0.000 0.000 ↓ 0.0 0

Index Scan using bico_pkey on bico bic_1 (cost=0.28..1.74 rows=1 width=20) (never executed)

  • Index Cond: (bic_cd_bico = abt_2.abt_cd_bico)
  • Filter: (bic_cd_unidade_negocio = 647)
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=31) (never executed)

  • Index Cond: (pro_cd_produto = bic_1.bic_cd_produto)
42. 0.000 0.000 ↓ 0.0 0

Index Scan using bomba_pkey on bomba bom_1 (cost=0.28..1.94 rows=1 width=12) (never executed)

  • Index Cond: (bom_cd_bomba = bic_1.bic_cd_bomba)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using caixa_pkey on caixa cai_1 (cost=0.42..2.64 rows=1 width=12) (never executed)

  • Index Cond: (cai_cd_caixa = 1353808)
  • Filter: (cai_cd_unidade_negocio = 647)
44. 0.010 81.250 ↑ 1.0 12 1

Subquery Scan on *SELECT* 3 (cost=291,657.70..4,872,798.62 rows=12 width=319) (actual time=71.336..81.250 rows=12 loops=1)

45. 0.003 81.240 ↑ 1.0 12 1

Nested Loop Anti Join (cost=291,657.70..4,872,798.32 rows=12 width=151) (actual time=71.334..81.240 rows=12 loops=1)

  • Join Filter: (abt_3.abt_cd_bico = bic_2.bic_cd_bico)
46. 0.004 81.177 ↑ 1.3 12 1

Nested Loop (cost=291,655.58..4,668,446.72 rows=16 width=91) (actual time=71.277..81.177 rows=12 loops=1)

47. 0.011 1.717 ↑ 1.0 16 1

Nested Loop (cost=0.98..1,969.89 rows=16 width=55) (actual time=1.110..1.717 rows=16 loops=1)

48. 0.015 1.674 ↑ 1.0 16 1

Nested Loop (cost=0.70..1,932.17 rows=16 width=51) (actual time=1.100..1.674 rows=16 loops=1)

49. 0.016 1.611 ↑ 1.0 16 1

Nested Loop (cost=0.28..1,889.93 rows=16 width=24) (actual time=1.087..1.611 rows=16 loops=1)

50. 1.579 1.579 ↑ 1.0 16 1

Index Scan using bico_pkey on bico bic_2 (cost=0.28..1,889.60 rows=16 width=16) (actual time=1.067..1.579 rows=16 loops=1)

  • Filter: (bic_cd_unidade_negocio = 647)
  • Rows Removed by Filter: 3169
51. 0.016 0.016 ↑ 1.0 1 16

CTE Scan on caixa_meta cm (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=16)

52. 0.048 0.048 ↑ 1.0 1 16

Index Scan using produto_pkey on produto pro_2 (cost=0.42..2.64 rows=1 width=31) (actual time=0.003..0.003 rows=1 loops=16)

  • Index Cond: (pro_cd_produto = bic_2.bic_cd_produto)
53. 0.032 0.032 ↑ 1.0 1 16

Index Scan using bomba_pkey on bomba bom_2 (cost=0.28..2.36 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=16)

  • Index Cond: (bom_cd_bomba = bic_2.bic_cd_bomba)
54. 0.032 79.456 ↑ 1.0 1 16

Limit (cost=291,654.60..291,654.78 rows=1 width=40) (actual time=4.965..4.966 rows=1 loops=16)

55. 0.048 79.424 ↑ 825.0 1 16

GroupAggregate (cost=291,654.60..291,803.62 rows=825 width=40) (actual time=4.964..4.964 rows=1 loops=16)

  • Group Key: abt_4.abt_cd_substituicao
56. 0.096 79.376 ↑ 938.5 15 16

Sort (cost=291,654.60..291,689.79 rows=14,077 width=12) (actual time=4.960..4.961 rows=15 loops=16)

  • Sort Key: abt_4.abt_cd_substituicao DESC
  • Sort Method: quicksort Memory: 25kB
57. 0.640 79.280 ↑ 469.2 30 16

Hash Join (cost=17,237.77..290,684.62 rows=14,077 width=12) (actual time=4.297..4.955 rows=30 loops=16)

  • Hash Cond: (ven_2.ven_cd_caixa = cai_3.cai_cd_caixa)
58. 1.646 13.376 ↑ 332.5 127 16

Nested Loop (cost=1.70..273,149.41 rows=42,231 width=16) (actual time=0.011..0.836 rows=127 loops=16)

59. 2.000 7.680 ↑ 332.5 127 16

Nested Loop (cost=1.14..160,433.57 rows=42,231 width=16) (actual time=0.008..0.480 rows=127 loops=16)

60. 1.360 1.360 ↑ 312.8 135 16

Index Scan using abastecimento_idx_cd_bico on abastecimento abt_4 (cost=0.57..45,257.83 rows=42,231 width=16) (actual time=0.004..0.085 rows=135 loops=16)

  • Index Cond: (abt_cd_bico = bic_2.bic_cd_bico)
61. 4.320 4.320 ↑ 1.0 1 2,160

Index Scan using venda_item_pkey on venda_item vei_2 (cost=0.57..2.73 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=2,160)

  • Index Cond: (vei_cd_venda_item = abt_4.abt_cd_venda_item)
62. 4.050 4.050 ↑ 1.0 1 2,025

Index Scan using venda_pkey on venda ven_2 (cost=0.56..2.67 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=2,025)

  • Index Cond: (ven_cd_venda = vei_2.vei_cd_venda)
63. 18.909 65.264 ↑ 1.9 89,769 1

Hash (cost=15,119.66..15,119.66 rows=169,313 width=4) (actual time=65.264..65.264 rows=89,769 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 5204kB
64. 13.532 46.355 ↑ 1.9 89,769 1

Nested Loop (cost=1,824.10..15,119.66 rows=169,313 width=4) (actual time=9.006..46.355 rows=89,769 loops=1)

65. 0.003 0.003 ↑ 1.0 1 1

CTE Scan on caixa_meta cm_1 (cost=0.00..0.02 rows=1 width=8) (actual time=0.001..0.003 rows=1 loops=1)

66. 24.964 32.820 ↑ 1.9 89,769 1

Bitmap Heap Scan on caixa cai_3 (cost=1,824.10..13,426.51 rows=169,313 width=12) (actual time=8.991..32.820 rows=89,769 loops=1)

  • Recheck Cond: (cai_ts_abertura < cm_1.min_ts_abertura)
  • Heap Blocks: exact=5065
67. 7.856 7.856 ↑ 1.9 89,769 1

Bitmap Index Scan on caixa_abertura (cost=0.00..1,781.77 rows=169,313 width=0) (actual time=7.855..7.856 rows=89,769 loops=1)

  • Index Cond: (cai_ts_abertura < cm_1.min_ts_abertura)
68. 0.007 0.060 ↓ 0.0 0 12

Materialize (cost=2.12..204,151.63 rows=842 width=4) (actual time=0.005..0.005 rows=0 loops=12)

69. 0.004 0.053 ↓ 0.0 0 1

Nested Loop (cost=2.12..204,147.42 rows=842 width=4) (actual time=0.053..0.053 rows=0 loops=1)

70. 0.003 0.039 ↑ 201.2 5 1

Nested Loop (cost=1.55..201,458.94 rows=1,006 width=4) (actual time=0.028..0.039 rows=5 loops=1)

71. 0.002 0.020 ↑ 111.2 4 1

Nested Loop (cost=0.99..501.41 rows=445 width=4) (actual time=0.016..0.020 rows=4 loops=1)

72. 0.008 0.008 ↑ 1.0 1 1

Index Only Scan using caixa_pkey on caixa cai_2 (cost=0.42..2.64 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (cai_cd_caixa = 1353808)
  • Heap Fetches: 1
73. 0.010 0.010 ↑ 111.2 4 1

Index Scan using venda_idx_caixa on venda ven_1 (cost=0.56..494.32 rows=445 width=8) (actual time=0.007..0.010 rows=4 loops=1)

  • Index Cond: (ven_cd_caixa = 1353808)
74. 0.016 0.016 ↑ 427.0 1 4

Index Scan using venda_item_idx_venda_rebuild_2 on venda_item vei_1 (cost=0.57..447.32 rows=427 width=8) (actual time=0.004..0.004 rows=1 loops=4)

  • Index Cond: (vei_cd_venda = ven_1.ven_cd_venda)
75. 0.010 0.010 ↓ 0.0 0 5

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=0 loops=5)

  • Index Cond: (abt_cd_venda_item = vei_1.vei_cd_venda_item)
76.          

SubPlan (for GroupAggregate)

77. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=502.13..84,715.60 rows=1 width=0) (never executed)

  • Hash Cond: (vei_6.vei_cd_venda = ven_6.ven_cd_venda)
78. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.14..84,177.65 rows=14,077 width=4) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..45,785.74 rows=14,077 width=4) (never executed)

  • Join Filter: (abtc_1.abt_dt_abastecimento >= cm_4.min_dt_movimento)
80. 0.000 0.000 ↓ 0.0 0

CTE Scan on caixa_meta cm_4 (cost=0.00..0.02 rows=1 width=4) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Index Scan using abastecimento_idx_cd_bico on abastecimento abtc_1 (cost=0.57..45,257.83 rows=42,231 width=8) (never executed)

  • Index Cond: (abt_cd_bico = abt.bico)
82. 0.000 0.000 ↓ 0.0 0

Index Scan using venda_item_pkey on venda_item vei_6 (cost=0.57..2.73 rows=1 width=8) (never executed)

  • Index Cond: (vei_cd_venda_item = abtc_1.abt_cd_venda_item)
83. 0.000 0.000 ↓ 0.0 0

Hash (cost=495.42..495.42 rows=446 width=4) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Index Scan using venda_idx_caixa on venda ven_6 (cost=0.56..495.42 rows=446 width=4) (never executed)

  • Index Cond: (ven_cd_caixa = abt.caixa)
85. 0.000 0.036 ↑ 1.0 1 12

Aggregate (cost=875.65..875.66 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=12)

86. 0.000 0.036 ↓ 0.0 0 12

Nested Loop (cost=2.12..875.64 rows=1 width=6) (actual time=0.003..0.003 rows=0 loops=12)

  • Join Filter: (cai_4.cai_ts_abertura > cm_2.max_ts_abertura)
87. 0.000 0.036 ↓ 0.0 0 12

Nested Loop (cost=2.12..875.61 rows=1 width=14) (actual time=0.003..0.003 rows=0 loops=12)

88. 0.012 0.036 ↓ 0.0 0 12

Nested Loop (cost=1.70..873.08 rows=1 width=14) (actual time=0.003..0.003 rows=0 loops=12)

89. 0.000 0.024 ↓ 0.0 0 12

Nested Loop (cost=1.14..870.34 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=12)

90. 0.024 0.024 ↓ 0.0 0 12

Index Scan using abt_unidade_dtfiscal_bico on abastecimento b (cost=0.57..867.55 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=12)

  • Index Cond: ((abt_cd_unidade_negocio = 647) AND (abt_dt_fiscal >= (max(abt.maior_data))) AND (abt_cd_bico = abt.bico))
  • Filter: ((abt_vl_encerrante < (max(abt.encerrante_final_abt))) AND (abt_cd_substituicao = abt.substituicao))
91. 0.000 0.000 ↓ 0.0 0

Index Scan using venda_item_pkey on venda_item vei_3 (cost=0.57..2.79 rows=1 width=8) (never executed)

  • Index Cond: (vei_cd_venda_item = b.abt_cd_venda_item)
  • Filter: (vei_cd_produto = abt.produto)
92. 0.000 0.000 ↓ 0.0 0

Index Scan using venda_pkey on venda ven_3 (cost=0.56..2.74 rows=1 width=12) (never executed)

  • Index Cond: (ven_cd_venda = vei_3.vei_cd_venda)
  • Filter: ((ven_cd_caixa <> 1353808) AND (ven_cd_unidade_negocio = 647) AND (ven_fl_cancelada = 'N'::bpchar))
93. 0.000 0.000 ↓ 0.0 0

Index Scan using caixa_pkey on caixa cai_4 (cost=0.42..2.53 rows=1 width=16) (never executed)

  • Index Cond: (cai_cd_caixa = ven_3.ven_cd_caixa)
  • Filter: (cai_cd_unidade_negocio = 647)
94. 0.000 0.000 ↓ 0.0 0

CTE Scan on caixa_meta cm_2 (cost=0.00..0.02 rows=1 width=8) (never executed)

95. 0.000 0.132 ↑ 1.0 1 12

Aggregate (cost=162,374.11..162,374.12 rows=1 width=64) (actual time=0.011..0.011 rows=1 loops=12)

96. 0.000 0.132 ↓ 0.0 0 12

Nested Loop (cost=503.14..162,374.10 rows=1 width=19) (actual time=0.011..0.011 rows=0 loops=12)

  • Join Filter: (b_1.abt_dt_abastecimento < cm_3.min_dt_movimento)
97. 0.000 0.132 ↓ 0.0 0 12

Nested Loop Semi Join (cost=503.14..162,374.06 rows=1 width=23) (actual time=0.011..0.011 rows=0 loops=12)

  • Join Filter: (abtc.abt_dt_abastecimento >= cai_5.cai_dt_movimento)
98. 0.000 0.132 ↓ 0.0 0 12

Nested Loop (cost=2.12..506.95 rows=1 width=35) (actual time=0.011..0.011 rows=0 loops=12)

99. 0.012 0.132 ↓ 0.0 0 12

Nested Loop (cost=1.70..504.29 rows=1 width=35) (actual time=0.011..0.011 rows=0 loops=12)

100. 0.024 0.120 ↓ 0.0 0 12

Nested Loop (cost=1.13..499.34 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=12)

101. 0.048 0.048 ↓ 4.0 4 12

Index Scan using venda_idx_caixa on venda ven_4 (cost=0.56..496.54 rows=1 width=12) (actual time=0.002..0.004 rows=4 loops=12)

  • Index Cond: (ven_cd_caixa = 1353808)
  • Filter: ((ven_cd_unidade_negocio = 647) AND (ven_fl_cancelada = 'N'::bpchar))
102. 0.048 0.048 ↓ 0.0 0 48

Index Scan using idx_tst_01_rebuild_2 on venda_item vei_4 (cost=0.57..2.79 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=48)

  • Index Cond: ((vei_cd_venda = ven_4.ven_cd_venda) AND (vei_cd_produto = abt.produto))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using abastecimento_abt_cd_venda_item_key on abastecimento b_1 (cost=0.57..2.76 rows=1 width=35) (never executed)

  • Index Cond: (abt_cd_venda_item = vei_4.vei_cd_venda_item)
  • Filter: ((abt_cd_unidade_negocio = 647) AND (abt_cd_bico = abt.bico) AND (abt_cd_substituicao = abt.substituicao))
104. 0.000 0.000 ↓ 0.0 0

Index Scan using caixa_pkey on caixa cai_5 (cost=0.42..2.64 rows=1 width=12) (never executed)

  • Index Cond: (cai_cd_caixa = 1353808)
  • Filter: (cai_cd_unidade_negocio = 647)
105. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=501.02..161,867.10 rows=1 width=12) (never executed)

  • Hash Cond: (vei_5.vei_cd_venda = ven_5.ven_cd_venda)
106. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.14..161,256.37 rows=42,231 width=12) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Index Scan using abastecimento_idx_cd_bico on abastecimento abtc (cost=0.57..45,257.83 rows=42,231 width=12) (never executed)

  • Index Cond: (abt_cd_bico = abt.bico)
108. 0.000 0.000 ↓ 0.0 0

Index Scan using venda_item_pkey on venda_item vei_5 (cost=0.57..2.75 rows=1 width=8) (never executed)

  • Index Cond: (vei_cd_venda_item = abtc.abt_cd_venda_item)
109. 0.000 0.000 ↓ 0.0 0

Hash (cost=494.32..494.32 rows=445 width=8) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Index Scan using venda_idx_caixa on venda ven_5 (cost=0.56..494.32 rows=445 width=8) (never executed)

  • Index Cond: (ven_cd_caixa = 1353808)
111. 0.000 0.000 ↓ 0.0 0

CTE Scan on caixa_meta cm_3 (cost=0.00..0.02 rows=1 width=4) (never executed)

Planning time : 16.520 ms
Execution time : 82.435 ms