explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4tFE

Settings
# exclusive inclusive rows x rows loops node
1. 53.912 236.777 ↑ 1.0 71,087 1

Merge Join (cost=8.36..30,061.23 rows=71,087 width=4) (actual time=0.020..236.777 rows=71,087 loops=1)

  • Merge Cond: (mrp_bom_line.id = mrp_bom_line_to_purchase_order_line.mrp_bom_line_id)
2. 158.050 158.050 ↑ 1.0 571,646 1

Index Only Scan using mrp_bom_line_pkey on mrp_bom_line (cost=0.42..24,028.31 rows=572,126 width=4) (actual time=0.008..158.050 rows=571,646 loops=1)

  • Heap Fetches: 177,089
3. 24.815 24.815 ↑ 1.0 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..3,820.72 rows=71,087 width=8) (actual time=0.004..24.815 rows=71,087 loops=1)

Planning time : 0.230 ms
Execution time : 239.918 ms