explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gCi : Optimization for: plan #yNwe

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.260 13.571 ↓ 1.0 4,483 1

Hash Join (cost=436.21..863.86 rows=4,449 width=63) (actual time=6.606..13.571 rows=4,483 loops=1)

  • Hash Cond: (pro.mar_id = mar.mar_id)
2. 1.572 12.274 ↓ 1.0 4,483 1

Hash Join (cost=433.81..800.29 rows=4,449 width=49) (actual time=6.562..12.274 rows=4,483 loops=1)

  • Hash Cond: (p1.pro_id = pro.pro_id)
3. 1.293 7.013 ↓ 1.0 4,483 1

Hash Join (cost=213.05..518.36 rows=4,449 width=37) (actual time=2.812..7.013 rows=4,483 loops=1)

  • Hash Cond: (p1.mdl_id = mdl.mdl_id)
4. 1.438 5.061 ↓ 1.0 4,483 1

Hash Join (cost=161.15..405.27 rows=4,452 width=33) (actual time=2.127..5.061 rows=4,483 loops=1)

  • Hash Cond: (pi1.prod1_id = p1.prod1_id)
5. 1.565 1.565 ↓ 1.0 4,483 1

Index Scan using idx_producto1i_idi_id on producto1_idioma pi1 (cost=0.29..183.19 rows=4,452 width=29) (actual time=0.014..1.565 rows=4,483 loops=1)

  • Index Cond: (idi_id = 4)
  • Filter: (prod1i_descripcion IS NOT NULL)
  • Rows Removed by Filter: 128
6. 0.948 2.058 ↑ 1.0 4,616 1

Hash (cost=103.16..103.16 rows=4,616 width=12) (actual time=2.058..2.058 rows=4,616 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 263kB
7. 1.110 1.110 ↑ 1.0 4,616 1

Seq Scan on producto1 p1 (cost=0.00..103.16 rows=4,616 width=12) (actual time=0.006..1.110 rows=4,616 loops=1)

8. 0.363 0.659 ↓ 1.0 1,552 1

Hash (cost=32.52..32.52 rows=1,551 width=12) (actual time=0.659..0.659 rows=1,552 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 87kB
9. 0.296 0.296 ↓ 1.0 1,552 1

Seq Scan on modelo mdl (cost=0.00..32.52 rows=1,551 width=12) (actual time=0.009..0.296 rows=1,552 loops=1)

  • Filter: (mdl_nombre IS NOT NULL)
  • Rows Removed by Filter: 1
10. 1.282 3.689 ↑ 1.0 4,616 1

Hash (cost=162.56..162.56 rows=4,656 width=20) (actual time=3.689..3.689 rows=4,616 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 299kB
11. 2.407 2.407 ↑ 1.0 4,616 1

Seq Scan on producto pro (cost=0.00..162.56 rows=4,656 width=20) (actual time=0.007..2.407 rows=4,616 loops=1)

  • Filter: ((pro_codigo IS NOT NULL) AND (pro_codigo IS NOT NULL))
12. 0.016 0.037 ↑ 1.0 62 1

Hash (cost=1.62..1.62 rows=62 width=10) (actual time=0.037..0.037 rows=62 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
13. 0.021 0.021 ↑ 1.0 62 1

Seq Scan on marca mar (cost=0.00..1.62 rows=62 width=10) (actual time=0.011..0.021 rows=62 loops=1)

  • Filter: (mar_nombre IS NOT NULL)