explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Comg

Settings
# exclusive inclusive rows x rows loops node
1. 13.847 46.168 ↑ 1.0 38,760 1

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

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

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

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

4. 2.015 11.102 ↓ 1.0 4,616 1

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

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

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

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

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

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

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

  • Hash Cond: (pro.pro_id = pro1.pro_id)
8. 0.967 0.967 ↓ 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.967 rows=4,616 loops=1)

9. 1.058 2.536 ↓ 1.0 4,616 1

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

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

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

11. 0.007 0.016 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=15) (actual time=0.016..0.016 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.012 0.029 ↑ 1.0 62 1

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

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

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

15. 0.020 0.040 ↓ 1.1 67 1

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

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

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