explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.481 12.575 ↑ 1.0 4,611 1

Hash Join (cost=434.32..870.83 rows=4,611 width=63) (actual time=5.645..12.575 rows=4,611 loops=1)

  • Hash Cond: (p1.mdl_id = mdl.mdl_id)
2. 1.151 10.507 ↑ 1.0 4,611 1

Hash Join (cost=382.40..755.51 rows=4,611 width=47) (actual time=5.050..10.507 rows=4,611 loops=1)

  • Hash Cond: (pro.mar_id = mar.mar_id)
3. 1.436 9.330 ↑ 1.0 4,611 1

Hash Join (cost=380.01..689.71 rows=4,611 width=45) (actual time=5.018..9.330 rows=4,611 loops=1)

  • Hash Cond: (p1.pro_id = pro.pro_id)
4. 1.673 5.013 ↑ 1.0 4,611 1

Hash Join (cost=161.15..407.45 rows=4,611 width=33) (actual time=2.077..5.013 rows=4,611 loops=1)

  • Hash Cond: (pi1.prod1_id = p1.prod1_id)
5. 1.295 1.295 ↑ 1.0 4,611 1

Index Scan using idx_producto1i_idi_id on producto1_idioma pi1 (cost=0.29..183.19 rows=4,611 width=29) (actual time=0.013..1.295 rows=4,611 loops=1)

  • Index Cond: (idi_id = 4)
6. 0.963 2.045 ↑ 1.0 4,616 1

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

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

8. 1.125 2.881 ↑ 1.0 4,616 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 299kB
9. 1.756 1.756 ↑ 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.756 rows=4,616 loops=1)

10. 0.013 0.026 ↑ 1.0 62 1

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

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

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

12. 0.326 0.587 ↓ 1.0 1,553 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 87kB
13. 0.261 0.261 ↓ 1.0 1,553 1

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