explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 09Q : Optimization for: Optimization for: plan #yNwe; plan #gCi

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.298 12.461 ↓ 1.0 4,483 1

Hash Join (cost=434.31..861.96 rows=4,449 width=63) (actual time=5.639..12.461 rows=4,483 loops=1)

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

Hash Join (cost=431.91..798.39 rows=4,449 width=49) (actual time=5.597..11.126 rows=4,483 loops=1)

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

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

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

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

  • Hash Cond: (pi1.prod1_id = p1.prod1_id)
5. 1.611 1.611 ↓ 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.611 rows=4,483 loops=1)

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

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

  • Buckets: 8192 Batches: 1 Memory Usage: 263kB
7. 1.057 1.057 ↑ 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.057 rows=4,616 loops=1)

8. 0.342 0.639 ↓ 1.0 1,552 1

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

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

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

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

Hash (cost=161.16..161.16 rows=4,616 width=20) (actual time=2.875..2.875 rows=4,616 loops=1)

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

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

  • Filter: ((pro_codigo IS NOT NULL) AND (pro_codigo IS NOT NULL))
12. 0.018 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.019 0.019 ↑ 1.0 62 1

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

  • Filter: (mar_nombre IS NOT NULL)