explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MDvn

Settings
# exclusive inclusive rows x rows loops node
1. 41.654 70.355 ↓ 1.0 5,231 1

Sort (cost=3,401.73..3,414.63 rows=5,163 width=329) (actual time=69.534..70.355 rows=5,231 loops=1)

  • Sort Key: pro.pro_nombre
  • Sort Method: quicksort Memory: 1,588kB
2. 4.404 28.701 ↓ 1.0 5,231 1

Hash Join (cost=2,281.16..3,083.32 rows=5,163 width=329) (actual time=13.239..28.701 rows=5,231 loops=1)

  • Hash Cond: (pdb.pro_id = dlp.pro_id)
3. 2.657 20.340 ↓ 1.0 5,231 1

Hash Join (cost=958.52..1,695.58 rows=5,132 width=198) (actual time=9.223..20.340 rows=5,231 loops=1)

  • Hash Cond: (pdb.pro_id = sal.pro_id)
4. 1.726 15.772 ↓ 1.0 5,231 1

Hash Left Join (cost=734.02..1,400.64 rows=5,123 width=190) (actual time=7.291..15.772 rows=5,231 loops=1)

  • Hash Cond: (pdb.pro_id = pre.pro_id)
5. 2.528 13.811 ↓ 1.0 5,199 1

Hash Join (cost=713.54..1,349.12 rows=5,123 width=177) (actual time=7.028..13.811 rows=5,199 loops=1)

  • Hash Cond: (pro.pro_id = pdb.pro_id)
6. 2.561 8.812 ↓ 1.0 5,199 1

Hash Join (cost=242.55..807.67 rows=5,132 width=137) (actual time=4.516..8.812 rows=5,199 loops=1)

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

Seq Scan on imagen img (cost=0.00..551.63 rows=5,132 width=24) (actual time=0.292..2.052 rows=5,199 loops=1)

  • Filter: ((img_orden = 1) AND (tat_id = 1) AND (tab_id = 209))
  • Rows Removed by Filter: 1,637
8. 2.234 4.199 ↑ 1.0 5,269 1

Hash (cost=176.69..176.69 rows=5,269 width=113) (actual time=4.198..4.199 rows=5,269 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 821kB
9. 1.965 1.965 ↑ 1.0 5,269 1

Seq Scan on producto pro (cost=0.00..176.69 rows=5,269 width=113) (actual time=0.013..1.965 rows=5,269 loops=1)

10. 0.996 2.471 ↑ 1.0 5,260 1

Hash (cost=405.23..405.23 rows=5,260 width=40) (actual time=2.471..2.471 rows=5,260 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 249kB
11. 0.801 1.475 ↑ 1.0 5,260 1

Merge Left Join (cost=0.43..405.23 rows=5,260 width=40) (actual time=0.030..1.475 rows=5,260 loops=1)

  • Merge Cond: (pdb.pro_id = dpet.pro_id)
12. 0.668 0.668 ↑ 1.0 5,260 1

Index Only Scan using idx_producto_diccionario_busqueda_pro_id on producto_diccionario_busqueda pdb (cost=0.28..323.18 rows=5,260 width=4) (actual time=0.020..0.668 rows=5,260 loops=1)

  • Heap Fetches: 0
13. 0.006 0.006 ↓ 0.0 0 1

Index Scan using idx_dpedido_tmp_pro_id on dpedido_tmp dpet (cost=0.15..57.65 rows=900 width=40) (actual time=0.006..0.006 rows=0 loops=1)

14. 0.120 0.235 ↑ 1.0 555 1

Hash (cost=13.55..13.55 rows=555 width=17) (actual time=0.235..0.235 rows=555 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
15. 0.115 0.115 ↑ 1.0 555 1

Seq Scan on preventa pre (cost=0.00..13.55 rows=555 width=17) (actual time=0.011..0.115 rows=555 loops=1)

16. 0.925 1.911 ↑ 1.0 5,260 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 278kB
17. 0.986 0.986 ↑ 1.0 5,260 1

Seq Scan on saldoinv sal (cost=0.00..158.75 rows=5,260 width=8) (actual time=0.033..0.986 rows=5,260 loops=1)

  • Filter: (bod_id = 1)
18. 1.502 3.957 ↑ 1.0 5,260 1

Hash (cost=1,256.47..1,256.47 rows=5,293 width=16) (actual time=3.956..3.957 rows=5,260 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 329kB
19. 2.131 2.455 ↑ 1.0 5,260 1

Bitmap Heap Scan on dlistapre dlp (cost=101.31..1,256.47 rows=5,293 width=16) (actual time=0.379..2.455 rows=5,260 loops=1)

  • Recheck Cond: (lpr_id = 1)
  • Heap Blocks: exact=450
20. 0.324 0.324 ↑ 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.324..0.324 rows=5,260 loops=1)

  • Index Cond: (lpr_id = 1)