explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qiDz : Optimization for: plan #pwt9

Settings

Optimization path:

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

Update on commission e (cost=6.62..11.98 rows=2 width=246) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=6.62..11.98 rows=2 width=246) (actual rows= loops=)

  • Hash Cond: (e.commissioned_option = c.id)
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on commission e (cost=4.16..9.50 rows=2 width=230) (actual rows= loops=)

  • Recheck Cond: (commissioned_contract IS NULL)
  • -> Bitmap Index Scan on commission_commissioned_contract_index (cost=0.00..4.16 rows=2
  • Index Cond: (commissioned_contract IS NULL)
4. 0.000 0.000 ↓ 0.0

Hash (cost=2.31..2.31 rows=12 width=20) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.14..2.31 rows=12 width=20) (actual rows= loops=)

  • Hash Cond: (c.covered_element = d.id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on contract_option c (cost=0.00..1.12 rows=12 width=14) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1.06..1.06 rows=6 width=14) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on contract_covered_element d (cost=0.00..1.06 rows=6 width=14) (actual rows= loops=)