explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LCh9

Settings
# exclusive inclusive rows x rows loops node
1. 85,856.511 86,311.952 ↑ 1.2 71,087 1

Merge Left Join (cost=16.47..79,893.37 rows=88,139 width=4) (actual time=1.541..86,311.952 rows=71,087 loops=1)

  • Merge Cond: (mrp_bom_line_to_purchase_order_line.mrp_bom_line_id = mrp_bom_line.id)
2. 50.423 50.423 ↑ 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=20) (actual time=0.005..50.423 rows=71,087 loops=1)

3. 405.018 405.018 ↓ 1.0 593,447 1

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

Planning time : 0.458 ms
Execution time : 86,319.112 ms