explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9azL : Optimization for: Optimization for: Optimization for: plan #2bDC; plan #vCCx; plan #KOFY

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 123.681 146.029 ↓ 1.4 57,644 1

Bitmap Heap Scan on outputs outputs (cost=1,346.27..24,499.48 rows=40,964 width=67) (actual time=25.265..146.029 rows=57,644 loops=1)

  • Filter: (unallocated_units > '0'::numeric)
  • Heap Blocks: exact=15,539
2. 22.348 22.348 ↓ 4.1 265,693 1

Bitmap Index Scan on stock_outputs_product_code_idx (cost=0..1,336.03 rows=65,547 width=0) (actual time=22.348..22.348 rows=265,693 loops=1)

  • Index Cond: (product_code = 1,169)
Planning time : 0.192 ms
Execution time : 147.4 ms