explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JYXP

Settings
# exclusive inclusive rows x rows loops node
1. 149.914 1,093.625 ↑ 1.0 64,670 1

Hash Join (cost=36,219.23..40,804.94 rows=65,672 width=4) (actual time=893.723..1,093.625 rows=64,670 loops=1)

  • Hash Cond: (mrp_bom_line_to_purchase_order_line.mrp_bom_line_id = mrp_bom_line.id)
2. 50.539 50.539 ↑ 1.0 64,670 1

Seq Scan on mrp_bom_line_to_purchase_order_line (cost=0.00..1,139.72 rows=65,672 width=8) (actual time=0.004..50.539 rows=64,670 loops=1)

3. 444.873 893.172 ↑ 1.0 517,915 1

Hash (cost=27,698.99..27,698.99 rows=519,299 width=4) (actual time=893.172..893.172 rows=517,915 loops=1)

  • Buckets: 131,072 Batches: 8 Memory Usage: 3,306kB
4. 448.299 448.299 ↑ 1.0 517,915 1

Seq Scan on mrp_bom_line (cost=0.00..27,698.99 rows=519,299 width=4) (actual time=0.013..448.299 rows=517,915 loops=1)

Planning time : 0.319 ms
Execution time : 1,139.126 ms