explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yNwe

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.214 14.994 ↓ 1.0 4,483 1

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

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

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

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

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

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

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

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

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

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

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

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

8. 0.369 0.770 ↓ 1.0 1,552 1

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

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

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

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

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

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

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

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

Hash (cost=1.62..1.62 rows=62 width=10) (actual time=0.044..0.044 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.010..0.021 rows=62 loops=1)

  • Filter: (mar_nombre IS NOT NULL)