explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pwt9

Settings

Optimization(s) for this plan:

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

Update on commission e (cost=9.66..25.09 rows=2 width=252) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.66..25.09 rows=2 width=252) (actual rows= loops=)

  • Join Filter: (c.covered_element = d.id)
3. 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=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=9.66..23.85 rows=2 width=246) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.66..23.84 rows=2 width=246) (actual rows= loops=)

  • -> Index Scan using contract_option_pkey on contract_option c (cost=0.14..0.19 ro
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=9.52..23.45 rows=2 width=240) (actual rows= loops=)

  • Hash Cond: (b.id = e.id)
  • Index Cond: (id = b.commissioned_option)
  • Filter: (covered_element IS NOT NULL)
7. 0.000 0.000 ↓ 0.0

Seq Scan on commission b (cost=0.00..13.10 rows=310 width=14) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=9.50..9.50 rows=2 width=230) (actual rows= loops=)

  • -> Bitmap Heap Scan on commission e (cost=4.16..9.50 rows=2 width=230
  • Recheck Cond: (commissioned_contract IS NULL)
  • -> Bitmap Index Scan on commission_commissioned_contract_index
  • Index Cond: (commissioned_contract IS NULL)