explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 129.964 152.911 ↓ 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.881..152.911 rows=57,644 loops=1)

  • Filter: (unallocated_units > '0'::numeric)
  • Heap Blocks: exact=15,539
2. 22.947 22.947 ↓ 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.946..22.947 rows=265,693 loops=1)

  • Index Cond: (product_code = 1,169)
Planning time : 0.139 ms
Execution time : 154.281 ms