explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hjAm

Settings
# exclusive inclusive rows x rows loops node
1. 359.199 359.199 ↑ 1.0 63,828 1

CTE Scan on x (cost=34,593.45..35,897.81 rows=65,218 width=4) (actual time=0.029..359.199 rows=63,828 loops=1)

2.          

CTE x

3. 56.028 342.412 ↑ 1.0 63,828 1

Merge Join (cost=11.59..34,593.45 rows=65,218 width=4) (actual time=0.028..342.412 rows=63,828 loops=1)

  • Merge Cond: (mrp_bom_line_to_purchase_order_line.mrp_bom_line_id = mrp_bom_line.id)
4. 21.893 21.893 ↑ 1.0 63,828 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,655.56 rows=65,218 width=8) (actual time=0.006..21.893 rows=63,828 loops=1)

5. 264.491 264.491 ↓ 1.0 526,759 1

Index Only Scan using mrp_bom_line_pkey on mrp_bom_line (cost=0.42..30,994.99 rows=507,038 width=4) (actual time=0.011..264.491 rows=526,759 loops=1)

  • Heap Fetches: 526,759
Planning time : 0.266 ms
Execution time : 362.998 ms