explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 41OE

Settings
# exclusive inclusive rows x rows loops node
1. 205.149 1,267.396 ↑ 14.2 25 1

HashAggregate (cost=345.44..349.00 rows=356 width=40) (actual time=1,267.389..1,267.396 rows=25 loops=1)

  • Group Key: operador_fuerza_vta.ofv_nrutoperador, operador.ope_sdigverificador, operador.ope_snombre
2. 103.100 1,062.247 ↓ 1,167.3 415,555 1

Nested Loop (cost=5.94..342.77 rows=356 width=40) (actual time=2.001..1,062.247 rows=415,555 loops=1)

  • Join Filter: (operador_fuerza_vta.ofv_nrutoperador = relacion_comer_localcliente.rco_nrutoperador)
3. 2.137 16.667 ↓ 410.7 1,232 1

Nested Loop (cost=5.51..107.04 rows=3 width=69) (actual time=1.508..16.667 rows=1,232 loops=1)

  • Join Filter: (operador_fuerza_vta.ofv_nrutoperador = operador.ope_nrutoperador)
4. 0.975 12.066 ↓ 410.7 1,232 1

Nested Loop (cost=5.38..106.50 rows=3 width=29) (actual time=1.488..12.066 rows=1,232 loops=1)

  • Join Filter: (((fuerza_venta.fvt_scodfuerzavta)::text = (territorio.ter_scodfuerzavta)::text) AND (operador_fuerza_vta.ofv_nrutoperador = territorio.ter_nrutoperador))
5. 0.172 1.639 ↓ 2.9 139 1

Hash Join (cost=5.09..12.17 rows=48 width=28) (actual time=1.008..1.639 rows=139 loops=1)

  • Hash Cond: ((operador_fuerza_vta.ofv_scodfuerzavta)::text = (fuerza_venta.fvt_scodfuerzavta)::text)
6. 0.272 1.444 ↓ 1.3 139 1

Hash Join (cost=3.84..10.51 rows=109 width=25) (actual time=0.972..1.444 rows=139 loops=1)

  • Hash Cond: (((zona.zon_scodfuerzavta)::text = (operador_fuerza_vta.ofv_scodfuerzavta)::text) AND (zona.zon_nrutoperador = operador_fuerza_vta.ofv_nrutoperador))
7. 0.264 0.264 ↑ 1.0 139 1

Seq Scan on zona (cost=0.00..5.92 rows=139 width=15) (actual time=0.026..0.264 rows=139 loops=1)

  • Filter: (((zon_scodzona)::text >= ' '::text) AND ((zon_scodzona)::text <= 'zzzzz'::text) AND ((zon_scodestado)::text = 'VIGEN'::text))
  • Rows Removed by Filter: 28
8. 0.041 0.908 ↓ 1.0 88 1

Hash (cost=2.54..2.54 rows=87 width=10) (actual time=0.908..0.908 rows=88 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
9. 0.867 0.867 ↓ 1.0 88 1

Seq Scan on operador_fuerza_vta (cost=0.00..2.54 rows=87 width=10) (actual time=0.828..0.867 rows=88 loops=1)

  • Filter: ((ofv_nrutoperador >= '0'::numeric) AND (ofv_nrutoperador <= '9999999999'::numeric) AND ((ofv_scodestado)::text = 'VIGEN'::text))
10. 0.008 0.023 ↑ 1.0 10 1

Hash (cost=1.12..1.12 rows=10 width=3) (actual time=0.023..0.023 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.015 0.015 ↑ 1.0 10 1

Seq Scan on fuerza_venta (cost=0.00..1.12 rows=10 width=3) (actual time=0.011..0.015 rows=10 loops=1)

  • Filter: ((fvt_scodestado)::text = 'VIGEN'::text)
12. 9.452 9.452 ↓ 9.0 9 139

Index Scan using pk_territorio on territorio (cost=0.28..1.95 rows=1 width=23) (actual time=0.053..0.068 rows=9 loops=139)

  • Index Cond: ((ter_nrutoperador = zona.zon_nrutoperador) AND ((ter_scodfuerzavta)::text = (zona.zon_scodfuerzavta)::text) AND ((ter_scodzona)::text = (zona.zon_scodzona)::text) AND ((ter_scodterritorio)::text >= ' '::text) AND ((te (...)
  • Filter: ((ter_scodestado)::text = 'VIGEN'::text)
  • Rows Removed by Filter: 6
13. 2.464 2.464 ↑ 1.0 1 1,232

Index Scan using pk_operador on operador (cost=0.14..0.17 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=1,232)

  • Index Cond: (ope_nrutoperador = territorio.ter_nrutoperador)
14. 942.480 942.480 ↓ 9.6 337 1,232

Index Scan using idx_rco_operador_territorio on relacion_comer_localcliente (cost=0.42..78.14 rows=35 width=15) (actual time=0.033..0.765 rows=337 loops=1,232)

  • Index Cond: ((rco_nrutoperador = territorio.ter_nrutoperador) AND (rco_nidterritorio = territorio.ter_nidterritorio))
  • Filter: ((rco_nrutcliente >= '0'::numeric) AND (rco_nrutcliente <= '9999999999'::numeric) AND (rco_nnumlocal >= '0'::numeric) AND (rco_nnumlocal <= '9999999999'::numeric) AND ((rco_scodrelacioncomercial)::text >= ' '::text) AND ((rco_scodrela (...)
Planning time : 11.694 ms
Execution time : 1,267.646 ms