explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dxjf : Optimization for: plan #opZr

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 13.951 45.016 ↑ 1.0 38,760 1

Hash Left Join (cost=701.83..2,779.33 rows=38,760 width=216) (actual time=10.510..45.016 rows=38,760 loops=1)

  • Hash Cond: (pem.emp_id = emp.emp_id)
2. 16.143 31.019 ↑ 1.0 38,760 1

Hash Left Join (cost=699.44..2,243.99 rows=38,760 width=113) (actual time=10.441..31.019 rows=38,760 loops=1)

  • Hash Cond: (pem.pro_id = pro.pro_id)
3. 4.460 4.460 ↑ 1.0 38,760 1

Seq Scan on presupuesto_emp pem (cost=0.00..1,011.60 rows=38,760 width=22) (actual time=0.009..4.460 rows=38,760 loops=1)

4. 1.944 10.416 ↓ 1.0 4,616 1

Hash (cost=642.83..642.83 rows=4,529 width=95) (actual time=10.416..10.416 rows=4,616 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 654kB
5. 1.397 8.472 ↓ 1.0 4,616 1

Hash Left Join (cost=189.00..642.83 rows=4,529 width=95) (actual time=2.474..8.472 rows=4,616 loops=1)

  • Hash Cond: (pro.mar_id = mar.mar_id)
6. 1.252 7.040 ↓ 1.0 4,616 1

Hash Left Join (cost=186.61..578.16 rows=4,529 width=93) (actual time=2.423..7.040 rows=4,616 loops=1)

  • Hash Cond: (pro1.cla2_id = cla2.cla2_id)
7. 2.558 5.769 ↓ 1.0 4,616 1

Hash Left Join (cost=185.25..514.52 rows=4,529 width=86) (actual time=2.380..5.769 rows=4,616 loops=1)

  • Hash Cond: (pro.pro_id = pro1.pro_id)
8. 0.924 0.924 ↓ 1.0 4,616 1

Seq Scan on producto pro (cost=0.00..267.29 rows=4,529 width=78) (actual time=0.006..0.924 rows=4,616 loops=1)

9. 0.984 2.287 ↓ 1.0 4,616 1

Hash (cost=129.00..129.00 rows=4,500 width=12) (actual time=2.287..2.287 rows=4,616 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 263kB
10. 1.303 1.303 ↓ 1.0 4,616 1

Seq Scan on producto1 pro1 (cost=0.00..129.00 rows=4,500 width=12) (actual time=0.010..1.303 rows=4,616 loops=1)

11. 0.010 0.019 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=15) (actual time=0.019..0.019 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.009 0.009 ↑ 1.0 16 1

Seq Scan on clasificacion2 cla2 (cost=0.00..1.16 rows=16 width=15) (actual time=0.005..0.009 rows=16 loops=1)

13. 0.021 0.035 ↑ 1.0 62 1

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

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

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

15. 0.028 0.046 ↓ 1.1 67 1

Hash (cost=1.62..1.62 rows=62 width=9) (actual time=0.046..0.046 rows=67 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
16. 0.018 0.018 ↓ 1.1 67 1

Seq Scan on empleado emp (cost=0.00..1.62 rows=62 width=9) (actual time=0.008..0.018 rows=67 loops=1)