explain.depesz.com

PostgreSQL's explain analyze made readable

Result: akyn

Settings
# exclusive inclusive rows x rows loops node
1. 20.059 445.989 ↑ 1.2 71,163 1

Hash Left Join (cost=441.98..63,942.70 rows=88,139 width=6) (actual time=3.928..445.989 rows=71,163 loops=1)

  • Hash Cond: ((mrp_bom_line.product_id = vendor_material.product_id) AND (mrp_bom_line.vendor = vendor_material.vendor_id))
2. 86.879 422.103 ↑ 1.2 71,087 1

Merge Left Join (cost=16.48..57,850.90 rows=88,139 width=14) (actual time=0.022..422.103 rows=71,087 loops=1)

  • Merge Cond: (mrp_bom_line_to_purchase_order_line.mrp_bom_line_id = mrp_bom_line.id)
3. 29.586 29.586 ↑ 1.2 71,087 1

Index Scan using index_mrp_bom_line_to_purchase_order_line_mrp_bom_line_id on mrp_bom_line_to_purchase_order_line (cost=0.42..4,076.50 rows=88,139 width=26) (actual time=0.005..29.586 rows=71,087 loops=1)

4. 305.638 305.638 ↓ 1.0 593,447 1

Index Scan using mrp_bom_line_pkey on mrp_bom_line (cost=0.42..51,464.74 rows=571,821 width=24) (actual time=0.003..305.638 rows=593,447 loops=1)

5. 1.852 3.827 ↑ 1.0 10,047 1

Hash (cost=274.00..274.00 rows=10,100 width=8) (actual time=3.827..3.827 rows=10,047 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 521kB
6. 1.975 1.975 ↑ 1.0 10,047 1

Seq Scan on vendor_material (cost=0.00..274.00 rows=10,100 width=8) (actual time=0.006..1.975 rows=10,047 loops=1)

Planning time : 0.956 ms
Execution time : 449.449 ms