explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y6k

Settings
# exclusive inclusive rows x rows loops node
1. 29.437 55.121 ↓ 1.0 5,301 1

Sort (cost=3,430.87..3,444.10 rows=5,293 width=329) (actual time=54.479..55.121 rows=5,301 loops=1)

  • Sort Key: pro.pro_nombre
  • Sort Method: quicksort Memory: 1,607kB
2. 3.125 25.684 ↓ 1.0 5,301 1

Hash Left Join (cost=2,310.28..3,103.50 rows=5,293 width=329) (actual time=15.005..25.684 rows=5,301 loops=1)

  • Hash Cond: (pro.pro_id = dlp.pro_id)
3. 1.938 19.496 ↓ 1.0 5,301 1

Hash Left Join (cost=987.64..1,714.09 rows=5,269 width=186) (actual time=11.886..19.496 rows=5,301 loops=1)

  • Hash Cond: (pro.pro_id = pdb.pro_id)
4. 1.274 16.211 ↓ 1.0 5,301 1

Hash Left Join (cost=598.71..1,252.80 rows=5,269 width=186) (actual time=10.484..16.211 rows=5,301 loops=1)

  • Hash Cond: (pro.pro_id = pre.pro_id)
5. 3.257 14.732 ↑ 1.0 5,269 1

Hash Right Join (cost=578.22..1,200.42 rows=5,269 width=173) (actual time=10.264..14.732 rows=5,269 loops=1)

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

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

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

Hash (cost=512.36..512.36 rows=5,269 width=153) (actual time=10.016..10.016 rows=5,269 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 880kB
8. 1.416 8.485 ↑ 1.0 5,269 1

Hash Right Join (cost=480.98..512.36 rows=5,269 width=153) (actual time=7.087..8.485 rows=5,269 loops=1)

  • Hash Cond: (dpet.pro_id = pro.pro_id)
9. 0.008 0.008 ↓ 0.0 0 1

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

10. 1.630 7.061 ↑ 1.0 5,269 1

Hash (cost=415.12..415.12 rows=5,269 width=117) (actual time=7.061..7.061 rows=5,269 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 845kB
11. 1.821 5.431 ↑ 1.0 5,269 1

Hash Right Join (cost=242.55..415.12 rows=5,269 width=117) (actual time=2.941..5.431 rows=5,269 loops=1)

  • Hash Cond: (sal.pro_id = pro.pro_id)
12. 0.705 0.705 ↑ 1.0 5,260 1

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

  • Filter: (bod_id = 1)
13. 1.389 2.905 ↑ 1.0 5,269 1

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

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

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

15. 0.085 0.205 ↑ 1.0 555 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
16. 0.120 0.120 ↑ 1.0 555 1

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

17. 0.760 1.347 ↑ 1.0 5,260 1

Hash (cost=323.18..323.18 rows=5,260 width=4) (actual time=1.347..1.347 rows=5,260 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 249kB
18. 0.587 0.587 ↑ 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.023..0.587 rows=5,260 loops=1)

  • Heap Fetches: 0
19. 1.117 3.063 ↑ 1.0 5,260 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 329kB
20. 1.706 1.946 ↑ 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.282..1.946 rows=5,260 loops=1)

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

  • Index Cond: (lpr_id = 1)