explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D2n3

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 57.941 ↓ 2.0 2 1

GroupAggregate (cost=3,639.02..3,639.15 rows=1 width=270) (actual time=57.934..57.941 rows=2 loops=1)

  • Group Key: ped.ped_nidpedido, ((((cliente.cli_nrutcliente)::text || '-'::text) || (cliente.cli_sdigverificador)::text)), ped.ped_nrutoperador, territorio.ter_scodterritorio, zona.zon_sdeszona, cliente.cli_stipocluster, jerarquia_categoria.jca_scodcategor (...)
2.          

CTE cw

3. 0.371 0.444 ↑ 1.1 697 1

Bitmap Heap Scan on inversion_ctacorriente_mov (cost=18.21..1,585.64 rows=747 width=14) (actual time=0.089..0.444 rows=697 loops=1)

  • Recheck Cond: (cmv_nrutoperador = '76265773'::numeric)
  • Heap Blocks: exact=105
4. 0.073 0.073 ↑ 1.1 697 1

Bitmap Index Scan on inversion_ctacorriente_mov_cmv_nrutoperador_idx (cost=0.00..18.02 rows=747 width=0) (actual time=0.073..0.073 rows=697 loops=1)

  • Index Cond: (cmv_nrutoperador = '76265773'::numeric)
5. 0.023 57.897 ↓ 2.0 2 1

Sort (cost=2,053.38..2,053.38 rows=1 width=129) (actual time=57.897..57.897 rows=2 loops=1)

  • Sort Key: ped.ped_nidpedido, ((((cliente.cli_nrutcliente)::text || '-'::text) || (cliente.cli_sdigverificador)::text)), territorio.ter_scodterritorio, zona.zon_sdeszona, cliente.cli_stipocluster, jerarquia_categoria.jca_scodcategoria
  • Sort Method: quicksort Memory: 25kB
6. 0.246 57.874 ↓ 2.0 2 1

Nested Loop Left Join (cost=12.53..2,053.37 rows=1 width=129) (actual time=34.523..57.874 rows=2 loops=1)

  • Join Filter: ((ped.ped_nidpedido = cw.cmv_nidpedido) AND ((cw.cmv_scodcategoria)::text = (jerarquia_categoria.jca_scodcategoria)::text))
  • Rows Removed by Join Filter: 1394
7. 0.005 56.944 ↓ 2.0 2 1

Nested Loop (cost=12.53..2,027.21 rows=1 width=105) (actual time=33.771..56.944 rows=2 loops=1)

  • Join Filter: (((detalle_pedido.dpe_scodformato)::text = (precio_articulo.pra_scodformato)::text) AND ((detalle_pedido.dpe_scodvariedad)::text = (precio_articulo.pra_scodvariedad)::text))
8. 0.005 56.839 ↓ 2.0 2 1

Nested Loop (cost=12.24..2,026.66 rows=1 width=111) (actual time=33.712..56.839 rows=2 loops=1)

  • Join Filter: ((jerarquia_agrupacion.jag_scodcategoria)::text = (jerarquia_categoria.jca_scodcategoria)::text)
  • Rows Removed by Join Filter: 12
9. 0.012 56.820 ↓ 2.0 2 1

Nested Loop (cost=12.24..2,024.10 rows=1 width=97) (actual time=33.699..56.820 rows=2 loops=1)

  • Join Filter: ((jerarquia_productobase.jpb_scodagrupacion)::text = (jerarquia_agrupacion.jag_scodagrupacion)::text)
  • Rows Removed by Join Filter: 62
10. 0.018 56.800 ↓ 2.0 2 1

Nested Loop (cost=12.24..2,017.05 rows=1 width=97) (actual time=33.689..56.800 rows=2 loops=1)

  • Join Filter: ((articulo.art_scodjerproducbase)::text = (jerarquia_productobase.jpb_scodproductobase)::text)
  • Rows Removed by Join Filter: 101
11. 0.007 56.764 ↓ 2.0 2 1

Nested Loop (cost=12.24..1,997.22 rows=1 width=97) (actual time=33.661..56.764 rows=2 loops=1)

12. 0.007 56.731 ↓ 2.0 2 1

Nested Loop (cost=11.96..1,996.38 rows=1 width=81) (actual time=33.639..56.731 rows=2 loops=1)

  • Join Filter: (ped.ped_nrutcliente = cliente.cli_nrutcliente)
13. 0.006 56.706 ↓ 2.0 2 1

Nested Loop (cost=11.54..1,992.96 rows=1 width=83) (actual time=33.622..56.706 rows=2 loops=1)

14. 0.000 56.646 ↓ 3.0 3 1

Nested Loop (cost=10.98..1,984.38 rows=1 width=69) (actual time=31.588..56.646 rows=3 loops=1)

15. 1.710 11.747 ↓ 18.6 7,500 1

Nested Loop (cost=10.56..661.37 rows=403 width=54) (actual time=0.161..11.747 rows=7,500 loops=1)

16. 0.034 0.237 ↓ 7.0 28 1

Hash Join (cost=10.14..61.39 rows=4 width=48) (actual time=0.111..0.237 rows=28 loops=1)

  • Hash Cond: ((territorio.ter_scodzona)::text = (zona.zon_scodzona)::text)
17. 0.125 0.159 ↑ 1.5 28 1

Bitmap Heap Scan on territorio (cost=4.82..55.72 rows=43 width=25) (actual time=0.060..0.159 rows=28 loops=1)

  • Recheck Cond: (ter_nrutoperador = '76265773'::numeric)
  • Filter: (((ter_scodzona)::text >= ''::text) AND ((ter_scodzona)::text <= 'zzzzz'::text) AND ((ter_scodterritorio)::text >= ''::text) AND ((ter_scodterritorio)::text <= 'zzzzz': (...)
  • Rows Removed by Filter: 43
  • Heap Blocks: exact=11
18. 0.034 0.034 ↑ 1.0 71 1

Bitmap Index Scan on idx_ter_extra (cost=0.00..4.81 rows=71 width=0) (actual time=0.034..0.034 rows=71 loops=1)

  • Index Cond: (ter_nrutoperador = '76265773'::numeric)
19. 0.005 0.044 ↑ 1.0 8 1

Hash (cost=5.21..5.21 rows=8 width=33) (actual time=0.044..0.044 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.039 0.039 ↑ 1.0 8 1

Seq Scan on zona (cost=0.00..5.21 rows=8 width=33) (actual time=0.015..0.039 rows=8 loops=1)

  • Filter: (zon_nrutoperador = '76265773'::numeric)
  • Rows Removed by Filter: 170
21. 9.800 9.800 ↓ 7.2 268 28

Index Scan using idx_rco_operador_territorio on relacion_comer_localcliente (cost=0.42..149.62 rows=37 width=29) (actual time=0.025..0.350 rows=268 loops=28)

  • Index Cond: ((rco_nrutoperador = '76265773'::numeric) AND (rco_nidterritorio = territorio.ter_nidterritorio))
22. 45.000 45.000 ↓ 0.0 0 7,500

Index Scan using "idx$$_1c5d0001" on pedido ped (cost=0.42..3.27 rows=1 width=45) (actual time=0.006..0.006 rows=0 loops=7,500)

  • Index Cond: ((ped_nrutcliente = relacion_comer_localcliente.rco_nrutcliente) AND (ped_nrutoperador = '76265773'::numeric))
  • Filter: ((ped_dfhocreacion >= '2020-03-16 00:00:00'::timestamp without time zone) AND (ped_dfhocreacion <= '2020-03-19 23:59:59'::timestamp without time zone) AND ((ped_scodestado)::text = (...)
  • Rows Removed by Filter: 1
23. 0.054 0.054 ↑ 1.0 1 3

Index Scan using pk_detalle_pedido on detalle_pedido (cost=0.55..8.57 rows=1 width=28) (actual time=0.016..0.018 rows=1 loops=3)

  • Index Cond: ((dpe_nidpedido = ped.ped_nidpedido) AND (dpe_nrutoperador = '76265773'::numeric))
  • Filter: (dpe_nporcdescuento > '0'::numeric)
  • Rows Removed by Filter: 8
24. 0.018 0.018 ↑ 1.0 1 2

Index Scan using pk_cliente on cliente (cost=0.42..3.40 rows=1 width=17) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: ((cli_nrutcliente = relacion_comer_localcliente.rco_nrutcliente) AND (cli_nrutoperador = '76265773'::numeric))
25. 0.026 0.026 ↑ 1.0 1 2

Index Scan using pk_articulo on articulo (cost=0.28..0.84 rows=1 width=16) (actual time=0.013..0.013 rows=1 loops=2)

  • Index Cond: (((art_scodformato)::text = (detalle_pedido.dpe_scodformato)::text) AND ((art_scodvariedad)::text = (detalle_pedido.dpe_scodvariedad)::text))
26. 0.018 0.018 ↑ 11.0 52 2

Seq Scan on jerarquia_productobase (cost=0.00..12.70 rows=570 width=10) (actual time=0.006..0.009 rows=52 loops=2)

27. 0.008 0.008 ↑ 5.6 32 2

Seq Scan on jerarquia_agrupacion (cost=0.00..4.80 rows=180 width=10) (actual time=0.002..0.004 rows=32 loops=2)

28. 0.014 0.014 ↑ 8.1 7 2

Seq Scan on jerarquia_categoria (cost=0.00..1.85 rows=57 width=19) (actual time=0.004..0.007 rows=7 loops=2)

  • Filter: (((jca_scodcategoria)::text >= ''::text) AND ((jca_scodcategoria)::text <= 'zzzzz'::text))
  • Rows Removed by Filter: 1
29. 0.100 0.100 ↑ 1.0 1 2

Index Scan using precio_articulo_extra1 on precio_articulo (cost=0.29..0.54 rows=1 width=12) (actual time=0.047..0.050 rows=1 loops=2)

  • Index Cond: (((pra_scodformato)::text = (articulo.art_scodformato)::text) AND ((pra_scodvariedad)::text = (articulo.art_scodvariedad)::text))
  • Filter: ((pra_dfhoiniciovigencia <= sysdate) AND (pra_dfhofinvigencia > sysdate))
  • Rows Removed by Filter: 20
30. 0.684 0.684 ↑ 1.1 697 2

CTE Scan on cw (cost=0.00..14.94 rows=747 width=40) (actual time=0.047..0.342 rows=697 loops=2)

Planning time : 21.997 ms
Execution time : 58.254 ms