explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCCx : Optimization for: plan #2bDC

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 147.002 166.083 ↓ 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=21.401..166.083 rows=57,644 loops=1)

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

  • Index Cond: (product_code = 1,169)
Planning time : 0.118 ms
Execution time : 167.607 ms