explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QNpo

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on outputs o (cost=19,896.69..31,976.78 rows=1,510 width=349) (never executed)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19,896.69..31,976.78 rows=1,510 width=349) (never executed)

3. 0.000 0.000 ↓ 0.0

Subquery Scan on allocation_select (cost=19,896.26..19,994.41 rows=1,510 width=360) (never executed)

4. 0.000 0.000 ↓ 0.0

Aggregate (cost=19,896.26..19,979.31 rows=1,510 width=168) (never executed)

5. 0.000 0.000 ↓ 0.0

Sort (cost=19,896.26..19,900.03 rows=1,510 width=24) (never executed)

  • Sort Key: aa.output_id
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=38.97..19,816.53 rows=1,510 width=24) (never executed)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on outputs oo (cost=38.54..5,871.97 rows=1,821 width=8) (never executed)

8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on stock_outputs_product_code_idx (cost=0..38.09 rows=1,821 width=0) (never executed)

  • Index Cond: (product_code = 312)
9. 0.000 0.000 ↓ 0.0

Index Scan using stock_allocations_output_id_idx on allocations aa (cost=0.43..7.65 rows=1 width=24) (never executed)

  • Index Cond: (output_id = oo.id)
10. 0.000 0.000 ↓ 0.0

Index Scan using outputs_pkey on outputs o (cost=0.43..7.92 rows=1 width=77) (never executed)

  • Index Cond: (id = allocation_select.output_id)
  • Filter: (NOT has_custom_value)