explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qeyr : Optimization for: plan #P4ZF

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 45.261 101.201 ↑ 1.0 5,213 1

Sort (cost=4,506.95..4,520.01 rows=5,222 width=279) (actual time=100.690..101.201 rows=5,213 loops=1)

  • Sort Key: cao.cao_orden, pro.pro_nombre
  • Sort Method: quicksort Memory: 1559kB
2. 3.370 55.940 ↑ 1.0 5,213 1

Hash Left Join (cost=1,820.18..4,184.48 rows=5,222 width=279) (actual time=34.890..55.940 rows=5,213 loops=1)

  • Hash Cond: (pro.pro_id = sal.pro_id)
3. 13.083 51.176 ↑ 1.0 5,213 1

Hash Right Join (cost=1,688.86..3,974.48 rows=5,222 width=128) (actual time=33.438..51.176 rows=5,213 loops=1)

  • Hash Cond: ((dlp.lpr_id = cli.lpr_id) AND (dlp.pro_id = pro.pro_id))
4. 5.789 5.789 ↑ 1.0 52,080 1

Seq Scan on dlistapre dlp (cost=0.00..1,842.80 rows=52,080 width=20) (actual time=1.111..5.789 rows=52,080 loops=1)

5. 2.849 32.304 ↑ 1.0 5,213 1

Hash (cost=1,610.66..1,610.66 rows=5,213 width=120) (actual time=32.304..32.304 rows=5,213 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 819kB
6. 5.243 29.455 ↑ 1.0 5,213 1

Hash Right Join (cost=897.44..1,610.66 rows=5,213 width=120) (actual time=22.256..29.455 rows=5,213 loops=1)

  • Hash Cond: ((cao.ubi_id = cli.canton_id) AND (cao.pro_id = pro.pro_id))
7. 4.577 4.577 ↑ 1.0 24,773 1

Seq Scan on catalogo_orden cao (cost=0.00..524.73 rows=24,773 width=12) (actual time=0.028..4.577 rows=24,773 loops=1)

8. 2.999 19.635 ↑ 1.0 5,213 1

Hash (cost=819.25..819.25 rows=5,213 width=120) (actual time=19.635..19.635 rows=5,213 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 836kB
9. 2.403 16.636 ↑ 1.0 5,213 1

Nested Loop Left Join (cost=720.49..819.25 rows=5,213 width=120) (actual time=12.105..16.636 rows=5,213 loops=1)

10. 2.181 14.233 ↑ 1.0 5,213 1

Hash Right Join (cost=720.22..751.59 rows=5,213 width=112) (actual time=12.066..14.233 rows=5,213 loops=1)

  • Hash Cond: (dpet.pro_id = pro.pro_id)
11. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on dpedido_tmp dpet (cost=0.00..19.00 rows=900 width=4) (actual time=0.012..0.012 rows=0 loops=1)

12. 2.971 12.040 ↑ 1.0 5,213 1

Hash (cost=655.05..655.05 rows=5,213 width=112) (actual time=12.040..12.040 rows=5,213 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 795kB
13. 3.305 9.069 ↑ 1.0 5,213 1

Hash Right Join (cost=281.29..655.05 rows=5,213 width=112) (actual time=4.852..9.069 rows=5,213 loops=1)

  • Hash Cond: (pdb.pro_id = pro.pro_id)
14. 0.941 0.941 ↑ 1.0 5,208 1

Seq Scan on producto_diccionario_busqueda pdb (cost=0.00..360.08 rows=5,208 width=4) (actual time=0.015..0.941 rows=5,208 loops=1)

15. 2.594 4.823 ↑ 1.0 5,213 1

Hash (cost=216.13..216.13 rows=5,213 width=112) (actual time=4.822..4.823 rows=5,213 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 795kB
16. 2.229 2.229 ↑ 1.0 5,213 1

Seq Scan on producto pro (cost=0.00..216.13 rows=5,213 width=112) (actual time=0.015..2.229 rows=5,213 loops=1)

17. 0.000 0.000 ↑ 1.0 1 5,213

Materialize (cost=0.28..2.50 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=5,213)

18. 0.029 0.029 ↑ 1.0 1 1

Index Scan using pk_cliente on cliente cli (cost=0.28..2.49 rows=1 width=8) (actual time=0.028..0.029 rows=1 loops=1)

  • Index Cond: (cli_id = 922)
19. 0.691 1.394 ↑ 1.0 3,293 1

Hash (cost=90.16..90.16 rows=3,293 width=8) (actual time=1.394..1.394 rows=3,293 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 172kB
20. 0.703 0.703 ↑ 1.0 3,293 1

Seq Scan on saldoinv sal (cost=0.00..90.16 rows=3,293 width=8) (actual time=0.041..0.703 rows=3,293 loops=1)

  • Filter: (bod_id = 1)
Planning time : 1.344 ms
Execution time : 102.955 ms