explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4hgT

Settings
# exclusive inclusive rows x rows loops node
1. 511.221 1,313.051 ↑ 1.0 64,670 1

Merge Join (cost=11.53..35,661.35 rows=65,672 width=4) (actual time=0.114..1,313.051 rows=64,670 loops=1)

  • Merge Cond: (mrp_bom_line_to_purchase_order_line.mrp_bom_line_id = mrp_bom_line.id)
2. 67.052 67.052 ↑ 1.0 64,670 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.29..1,972.37 rows=65,672 width=8) (actual time=0.011..67.052 rows=64,670 loops=1)

3. 734.778 734.778 ↓ 1.0 537,796 1

Index Only Scan using mrp_bom_line_pkey on mrp_bom_line (cost=0.42..31,726.91 rows=519,299 width=4) (actual time=0.020..734.778 rows=537,796 loops=1)

  • Heap Fetches: 537,796
Planning time : 0.495 ms
Execution time : 1,359.476 ms