explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UDD4

Settings
# exclusive inclusive rows x rows loops node
1. 794.813 5,454.260 ↑ 1.2 26,334 1

GroupAggregate (cost=144,827.23..155,901.03 rows=32,570 width=1,401) (actual time=4,640.032..5,454.260 rows=26,334 loops=1)

  • Group Key: territorio.ter_scodsupervisor, supervisor.sup_snombre, supervisor.sup_sapepaterno, supervisor.sup_sapematerno, zona.zon_scodzona, zona.zon_sdeszona, territorio.ter_scodterritorio, territorio.ter_sdesterritorio, cliente.cli_nrutcliente, cliente (...)
2. 3,271.491 4,659.447 ↓ 3.3 107,842 1

Sort (cost=144,827.23..144,908.65 rows=32,570 width=398) (actual time=4,639.956..4,659.447 rows=107,842 loops=1)

  • Sort Key: territorio.ter_scodsupervisor, supervisor.sup_snombre, supervisor.sup_sapepaterno, supervisor.sup_sapematerno, zona.zon_scodzona, zona.zon_sdeszona, territorio.ter_scodterritorio, territorio.ter_sdesterritorio, cliente.cli_nrutcliente, cl (...)
  • Sort Method: quicksort Memory: 58956kB
3. 257.181 1,387.956 ↓ 3.3 107,842 1

Hash Left Join (cost=76,196.13..142,385.90 rows=32,570 width=398) (actual time=527.617..1,387.956 rows=107,842 loops=1)

  • Hash Cond: ((territorio.ter_nrutoperador = zona.zon_nrutoperador) AND ((territorio.ter_scodfuerzavta)::text = (zona.zon_scodfuerzavta)::text) AND ((territorio.ter_scodzona)::text = (zona.zon_scodzona)::text))
4. 80.174 1,130.677 ↓ 3.3 107,842 1

Hash Left Join (cost=76,190.73..141,471.41 rows=32,570 width=362) (actual time=527.442..1,130.677 rows=107,842 loops=1)

  • Hash Cond: ((territorio.ter_nrutoperador = supervisor.sup_nrutoperador) AND ((territorio.ter_scodsupervisor)::text = (supervisor.sup_scodsupervisor)::text))
5. 87.745 1,050.433 ↓ 3.3 107,842 1

Hash Left Join (cost=76,187.64..141,295.36 rows=32,570 width=341) (actual time=527.334..1,050.433 rows=107,842 loops=1)

  • Hash Cond: ((relacion_comer_localcliente.rco_nrutoperador = territorio.ter_nrutoperador) AND (relacion_comer_localcliente.rco_nidterritorio = territorio.ter_nidterritorio))
6. 96.238 962.206 ↓ 4.1 107,842 1

Gather (cost=76,126.80..141,093.96 rows=26,495 width=312) (actual time=526.825..962.206 rows=107,842 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 18.536 865.968 ↓ 3.3 35,947 3

Hash Left Join (cost=75,126.80..137,444.46 rows=11,040 width=312) (actual time=479.180..865.968 rows=35,947 loops=3)

  • Hash Cond: ((relacion_comer_localcliente.rco_scodtipopago)::text = (pago1.par_codparametro01)::text)
8. 19.778 847.406 ↓ 3.3 35,947 3

Hash Left Join (cost=75,111.37..137,303.74 rows=11,040 width=299) (actual time=479.136..847.406 rows=35,947 loops=3)

  • Hash Cond: ((relacion_comer_localcliente.rco_scodtipocobro)::text = (cobro.par_codparametro01)::text)
9. 181.429 827.590 ↓ 3.3 35,947 3

Nested Loop Left Join (cost=75,095.93..137,162.89 rows=11,040 width=286) (actual time=479.075..827.590 rows=35,947 loops=3)

10. 76.768 646.143 ↑ 1.3 8,778 3

Nested Loop Left Join (cost=75,095.37..87,761.09 rows=11,040 width=276) (actual time=478.998..646.143 rows=8,778 loops=3)

11. 12.659 569.367 ↑ 1.3 8,778 3

Hash Left Join (cost=75,094.95..75,671.97 rows=11,040 width=246) (actual time=478.928..569.367 rows=8,778 loops=3)

  • Hash Cond: ((relacion_comer_localcliente.rco_nrutoperador = entrega.dic_nrutoperador) AND (relacion_comer_localcliente.rco_niddireccionentrega = entrega.dic_niddireccion) AND (relacion_comer_loc (...)
12. 13.203 505.387 ↑ 1.3 8,778 3

Hash Left Join (cost=63,946.90..64,436.98 rows=11,040 width=216) (actual time=427.251..505.387 rows=8,778 loops=3)

  • Hash Cond: ((relacion_comer_localcliente.rco_nrutoperador = visita.dic_nrutoperador) AND (relacion_comer_localcliente.rco_niddireccionvisita = visita.dic_niddireccion) AND (relacion_comer_ (...)
13. 5.573 444.320 ↑ 1.3 8,778 3

Hash Left Join (cost=52,798.85..53,201.99 rows=11,040 width=185) (actual time=379.049..444.320 rows=8,778 loops=3)

  • Hash Cond: ((local_cliente.loc_scodcategorianegocio)::text = (categoria_negocio.can_scodcatnegocio)::text)
14. 13.666 438.672 ↑ 1.3 8,778 3

Hash Left Join (cost=52,797.15..53,167.38 rows=11,040 width=171) (actual time=378.891..438.672 rows=8,778 loops=3)

  • Hash Cond: ((local_cliente.loc_nrutoperador = diclegal.dic_nrutoperador) AND (local_cliente.loc_niddireccion = diclegal.dic_niddireccion) AND (local_cliente.loc_nrutcliente = d (...)
15. 28.159 368.001 ↑ 1.3 8,778 3

Merge Left Join (cost=41,649.10..41,932.39 rows=11,040 width=154) (actual time=321.553..368.001 rows=8,778 loops=3)

  • Merge Cond: (cliente.cli_nrutcliente = local_cliente.loc_nrutcliente)
  • Join Filter: (local_cliente.loc_nrutoperador = cliente.cli_nrutoperador)
16. 3.443 20.968 ↑ 3.4 3,284 3

Sort (cost=9,769.16..9,796.76 rows=11,040 width=61) (actual time=19.922..20.968 rows=3,284 loops=3)

  • Sort Key: cliente.cli_nrutcliente
  • Sort Method: quicksort Memory: 482kB
17. 9.228 17.525 ↑ 3.4 3,284 3

Parallel Bitmap Heap Scan on cliente (cost=827.28..9,027.80 rows=11,040 width=61) (actual time=4.433..17.525 rows=3,284 loops=3)

  • Recheck Cond: (cli_nrutoperador = '76047659'::numeric)
  • Filter: ((cli_scodestado)::text = 'VIGEN'::text)
  • Rows Removed by Filter: 8881
  • Heap Blocks: exact=1326
18. 8.297 8.297 ↓ 1.0 36,497 1

Bitmap Index Scan on "idx$$_1c630002" (cost=0.00..820.65 rows=35,764 width=0) (actual time=8.297..8.297 rows=36,497 loops=1)

  • Index Cond: (cli_nrutoperador = '76047659'::numeric)
19. 108.401 318.874 ↓ 1.9 75,187 3

Sort (cost=31,879.94..31,980.18 rows=40,097 width=100) (actual time=301.547..318.874 rows=75,187 loops=3)

  • Sort Key: local_cliente.loc_nrutcliente
  • Sort Method: quicksort Memory: 19678kB
20. 97.034 210.473 ↓ 1.9 75,232 3

Hash Right Join (cost=10,844.13..28,814.28 rows=40,097 width=100) (actual time=70.062..210.473 rows=75,232 loops=3)

  • Hash Cond: ((relacion_comer_localcliente.rco_nrutoperador = local_cliente.loc_nrutoperador) AND (relacion_comer_localcliente.rco_nrutcliente = local_cliente.l (...)
21. 45.318 55.328 ↓ 1.0 70,210 3

Bitmap Heap Scan on relacion_comer_localcliente (cost=1,304.04..18,729.94 rows=69,112 width=74) (actual time=11.353..55.328 rows=70,210 loops=3)

  • Recheck Cond: (rco_nrutoperador = '76047659'::numeric)
  • Heap Blocks: exact=8349
22. 10.010 10.010 ↓ 1.0 70,216 3

Bitmap Index Scan on relcomerloccli_operador (cost=0.00..1,286.77 rows=69,112 width=0) (actual time=10.010..10.010 rows=70,216 loops=3)

  • Index Cond: (rco_nrutoperador = '76047659'::numeric)
23. 22.545 58.111 ↓ 1.0 40,198 3

Hash (cost=8,838.39..8,838.39 rows=40,097 width=26) (actual time=58.111..58.111 rows=40,198 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 2826kB
24. 28.340 35.566 ↓ 1.0 40,198 3

Bitmap Heap Scan on local_cliente (cost=1,111.17..8,838.39 rows=40,097 width=26) (actual time=7.882..35.566 rows=40,198 loops=3)

  • Recheck Cond: (loc_nrutoperador = '76047659'::numeric)
  • Heap Blocks: exact=4101
25. 7.226 7.226 ↓ 1.0 40,198 3

Bitmap Index Scan on "idx$$_1c630004" (cost=0.00..1,101.15 rows=40,097 width=0) (actual time=7.225..7.226 rows=40,198 loops=3)

  • Index Cond: (loc_nrutoperador = '76047659'::numeric)
26. 21.345 57.005 ↑ 1.0 42,752 3

Hash (cost=10,396.30..10,396.30 rows=42,957 width=53) (actual time=57.005..57.005 rows=42,752 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 4107kB
27. 31.081 35.660 ↑ 1.0 42,752 3

Bitmap Heap Scan on direccion_cliente diclegal (cost=809.34..10,396.30 rows=42,957 width=53) (actual time=5.400..35.660 rows=42,752 loops=3)

  • Recheck Cond: (dic_nrutoperador = '76047659'::numeric)
  • Heap Blocks: exact=5884
28. 4.579 4.579 ↑ 1.0 42,752 3

Bitmap Index Scan on idx_direccion_cliente_dic_nrutoperador (cost=0.00..798.60 rows=42,957 width=0) (actual time=4.579..4.579 rows=42,752 loops=3)

  • Index Cond: (dic_nrutoperador = '76047659'::numeric)
29. 0.018 0.075 ↑ 1.0 31 3

Hash (cost=1.31..1.31 rows=31 width=16) (actual time=0.075..0.075 rows=31 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
30. 0.057 0.057 ↑ 1.0 31 3

Seq Scan on categoria_negocio (cost=0.00..1.31 rows=31 width=16) (actual time=0.052..0.057 rows=31 loops=3)

31. 22.059 47.864 ↑ 1.0 42,752 3

Hash (cost=10,396.30..10,396.30 rows=42,957 width=53) (actual time=47.864..47.864 rows=42,752 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 4107kB
32. 20.896 25.805 ↑ 1.0 42,752 3

Bitmap Heap Scan on direccion_cliente visita (cost=809.34..10,396.30 rows=42,957 width=53) (actual time=5.770..25.805 rows=42,752 loops=3)

  • Recheck Cond: (dic_nrutoperador = '76047659'::numeric)
  • Heap Blocks: exact=5884
33. 4.909 4.909 ↑ 1.0 42,752 3

Bitmap Index Scan on idx_direccion_cliente_dic_nrutoperador (cost=0.00..798.60 rows=42,957 width=0) (actual time=4.909..4.909 rows=42,752 loops=3)

  • Index Cond: (dic_nrutoperador = '76047659'::numeric)
34. 23.827 51.321 ↑ 1.0 42,752 3

Hash (cost=10,396.30..10,396.30 rows=42,957 width=53) (actual time=51.321..51.321 rows=42,752 loops=3)

  • Buckets: 65536 Batches: 1 Memory Usage: 4107kB
35. 21.910 27.494 ↑ 1.0 42,752 3

Bitmap Heap Scan on direccion_cliente entrega (cost=809.34..10,396.30 rows=42,957 width=53) (actual time=6.510..27.494 rows=42,752 loops=3)

  • Recheck Cond: (dic_nrutoperador = '76047659'::numeric)
  • Heap Blocks: exact=5884
36. 5.584 5.584 ↑ 1.0 42,752 3

Bitmap Index Scan on idx_direccion_cliente_dic_nrutoperador (cost=0.00..798.60 rows=42,957 width=0) (actual time=5.584..5.584 rows=42,752 loops=3)

  • Index Cond: (dic_nrutoperador = '76047659'::numeric)
37. 0.008 0.008 ↑ 1.0 1 26,334

Index Scan using pk_direccion_cliente_new on direccion_cliente pago (cost=0.42..1.10 rows=1 width=53) (actual time=0.008..0.008 rows=1 loops=26,334)

  • Index Cond: ((relacion_comer_localcliente.rco_niddireccionpago = dic_niddireccion) AND (relacion_comer_localcliente.rco_nrutoperador = dic_nrutoperador) AND (dic_nrutoperador = '76047659'::numer (...)
38. 0.018 0.018 ↓ 3.0 3 26,334

Index Scan using idx_rep_piramidal_simple on resumen_pnv_piramidal (cost=0.56..4.46 rows=1 width=42) (actual time=0.013..0.018 rows=3 loops=26,334)

  • Index Cond: ((rpp_nrutoperador = relacion_comer_localcliente.rco_nrutoperador) AND (rpp_nrutoperador = '76047659'::numeric) AND (rpp_nrutcliente = relacion_comer_localcliente.rco_nrutcliente) AND (rpp (...)
39. 0.006 0.038 ↑ 2.3 3 3

Hash (cost=15.35..15.35 rows=7 width=18) (actual time=0.038..0.038 rows=3 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
40. 0.032 0.032 ↑ 2.3 3 3

Index Scan using idx_param_numpar on parametro cobro (cost=0.28..15.35 rows=7 width=18) (actual time=0.030..0.032 rows=3 loops=3)

  • Index Cond: (par_numparametro = '29'::numeric)
41. 0.005 0.026 ↑ 1.2 6 3

Hash (cost=15.35..15.35 rows=7 width=18) (actual time=0.026..0.026 rows=6 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.021 0.021 ↑ 1.2 6 3

Index Scan using idx_param_numpar on parametro pago1 (cost=0.28..15.35 rows=7 width=18) (actual time=0.019..0.021 rows=6 loops=3)

  • Index Cond: (par_numparametro = '7'::numeric)
43. 0.172 0.482 ↑ 1.0 271 1

Hash (cost=56.77..56.77 rows=271 width=52) (actual time=0.482..0.482 rows=271 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
44. 0.239 0.310 ↑ 1.0 271 1

Bitmap Heap Scan on territorio (cost=10.38..56.77 rows=271 width=52) (actual time=0.087..0.310 rows=271 loops=1)

  • Recheck Cond: (ter_nrutoperador = '76047659'::numeric)
  • Heap Blocks: exact=24
45. 0.071 0.071 ↑ 1.0 271 1

Bitmap Index Scan on idx_ter_extra (cost=0.00..10.31 rows=271 width=0) (actual time=0.071..0.071 rows=271 loops=1)

  • Index Cond: (ter_nrutoperador = '76047659'::numeric)
46. 0.024 0.070 ↑ 1.0 27 1

Hash (cost=2.69..2.69 rows=27 width=33) (actual time=0.070..0.070 rows=27 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
47. 0.046 0.046 ↑ 1.0 27 1

Seq Scan on supervisor (cost=0.00..2.69 rows=27 width=33) (actual time=0.022..0.046 rows=27 loops=1)

  • Filter: (sup_nrutoperador = '76047659'::numeric)
  • Rows Removed by Filter: 28
48. 0.022 0.098 ↑ 1.0 20 1

Hash (cost=5.05..5.05 rows=20 width=35) (actual time=0.098..0.098 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
49. 0.076 0.076 ↑ 1.0 20 1

Seq Scan on zona (cost=0.00..5.05 rows=20 width=35) (actual time=0.028..0.076 rows=20 loops=1)

  • Filter: (zon_nrutoperador = '76047659'::numeric)
  • Rows Removed by Filter: 144