explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GzCq

Settings
# exclusive inclusive rows x rows loops node
1. 22.919 501.929 ↑ 1.2 71,163 1

Hash Left Join (cost=441.98..63,942.61 rows=88,139 width=4) (actual time=6.771..501.929 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. 99.636 472.354 ↑ 1.2 71,087 1

Merge Left Join (cost=16.48..57,850.81 rows=88,139 width=12) (actual time=0.028..472.354 rows=71,087 loops=1)

  • Merge Cond: (mrp_bom_line_to_purchase_order_line.mrp_bom_line_id = mrp_bom_line.id)
3. 33.530 33.530 ↑ 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=24) (actual time=0.007..33.530 rows=71,087 loops=1)

4. 339.188 339.188 ↓ 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.004..339.188 rows=593,447 loops=1)

5. 3.159 6.656 ↑ 1.0 10,047 1

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

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

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

Planning time : 1.192 ms
Execution time : 505.552 ms