explain.depesz.com

PostgreSQL's explain analyze made readable

Result: opZr

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 13.976 47.065 ↑ 1.0 38,760 1

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

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

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

  • Hash Cond: (pem.pro_id = pro.pro_id)
3. 4.624 4.624 ↑ 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.624 rows=38,760 loops=1)

4. 2.363 12.467 ↓ 1.0 4,616 1

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

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

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

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

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

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

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

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

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

9. 1.085 2.548 ↓ 1.0 4,616 1

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

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

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

11. 0.014 0.029 ↑ 1.0 16 1

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

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

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

13. 0.038 0.061 ↑ 1.0 62 1

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

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

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

15. 0.028 0.044 ↓ 1.1 67 1

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

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

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