explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 146.879 180.022 ↓ 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=37.31..180.022 rows=57,644 loops=1)

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

  • Index Cond: (product_code = 1,169)
Planning time : 0.183 ms
Execution time : 181.394 ms