explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zEd4

Settings
# exclusive inclusive rows x rows loops node
1. 67.867 103.061 ↓ 1.0 5,199 1

Sort (cost=3,361.86..3,374.77 rows=5,163 width=551) (actual time=95.803..103.061 rows=5,199 loops=1)

  • Sort Key: pro.pro_nombre
  • Sort Method: external merge Disk: 2,992kB
2. 4.308 35.194 ↓ 1.0 5,199 1

Hash Join (cost=2,324.04..3,043.46 rows=5,163 width=551) (actual time=14.967..35.194 rows=5,199 loops=1)

  • Hash Cond: (sal.pro_id = dlp.pro_id)
3. 4.325 26.441 ↓ 1.0 5,199 1

Hash Join (cost=1,001.40..1,707.34 rows=5,132 width=515) (actual time=10.433..26.441 rows=5,199 loops=1)

  • Hash Cond: (pro.pro_id = sal.pro_id)
4. 5.021 19.717 ↓ 1.0 5,199 1

Hash Join (cost=776.90..1,412.49 rows=5,123 width=487) (actual time=8.014..19.717 rows=5,199 loops=1)

  • Hash Cond: (pro.pro_id = pdb.pro_id)
5. 4.595 10.253 ↓ 1.0 5,199 1

Hash Join (cost=242.55..807.67 rows=5,132 width=201) (actual time=3.494..10.253 rows=5,199 loops=1)

  • Hash Cond: (img.img_registro = pro.pro_id)
6. 2.557 2.557 ↓ 1.0 5,199 1

Seq Scan on imagen img (cost=0.00..551.63 rows=5,132 width=52) (actual time=0.364..2.557 rows=5,199 loops=1)

  • Filter: ((img_orden = 1) AND (tat_id = 1) AND (tab_id = 209))
  • Rows Removed by Filter: 1,637
7. 2.036 3.101 ↑ 1.0 5,269 1

Hash (cost=176.69..176.69 rows=5,269 width=149) (actual time=3.100..3.101 rows=5,269 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,036kB
8. 1.065 1.065 ↑ 1.0 5,269 1

Seq Scan on producto pro (cost=0.00..176.69 rows=5,269 width=149) (actual time=0.008..1.065 rows=5,269 loops=1)

9. 3.497 4.443 ↑ 1.0 5,260 1

Hash (cost=468.60..468.60 rows=5,260 width=286) (actual time=4.443..4.443 rows=5,260 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,719kB
10. 0.946 0.946 ↑ 1.0 5,260 1

Seq Scan on producto_diccionario_busqueda pdb (cost=0.00..468.60 rows=5,260 width=286) (actual time=0.018..0.946 rows=5,260 loops=1)

11. 1.113 2.399 ↑ 1.0 5,260 1

Hash (cost=158.75..158.75 rows=5,260 width=28) (actual time=2.399..2.399 rows=5,260 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 388kB
12. 1.286 1.286 ↑ 1.0 5,260 1

Seq Scan on saldoinv sal (cost=0.00..158.75 rows=5,260 width=28) (actual time=0.032..1.286 rows=5,260 loops=1)

  • Filter: (bod_id = 1)
13. 1.806 4.445 ↑ 1.0 5,260 1

Hash (cost=1,256.47..1,256.47 rows=5,293 width=36) (actual time=4.444..4.445 rows=5,260 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 440kB
14. 2.270 2.639 ↑ 1.0 5,260 1

Bitmap Heap Scan on dlistapre dlp (cost=101.31..1,256.47 rows=5,293 width=36) (actual time=0.438..2.639 rows=5,260 loops=1)

  • Recheck Cond: (lpr_id = 1)
  • Heap Blocks: exact=450
15. 0.369 0.369 ↑ 1.0 5,260 1

Bitmap Index Scan on idx_dlistapre_lpr_id (cost=0.00..99.99 rows=5,293 width=0) (actual time=0.369..0.369 rows=5,260 loops=1)

  • Index Cond: (lpr_id = 1)