explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zalN

Settings
# exclusive inclusive rows x rows loops node
1. 486.283 1,273.841 ↑ 1.0 64,670 1

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

  • Merge Cond: (mrp_bom_line_to_purchase_order_line.mrp_bom_line_id = mrp_bom_line.id)
2. 67.552 67.552 ↑ 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.007..67.552 rows=64,670 loops=1)

3. 720.006 720.006 ↓ 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.012..720.006 rows=537,796 loops=1)

  • Heap Fetches: 537,796
Planning time : 3.523 ms
Execution time : 1,317.738 ms