explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iJ5j

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

Update on pos_tkm (cost=354,921.48..403,510.55 rows=347,539 width=228) (actual rows= loops=)

2.          

CTE joined

3. 0.000 0.000 ↓ 0.0

Hash Join (cost=80,404.67..219,692.37 rows=347,539 width=39) (actual rows= loops=)

  • Hash Cond: (((pos.kennung)::text = (imp.kennung)::text) AND ((pos.extterminalid)::text = (imp.extterminalid)::text) AND ((pos.tkm_kennung_hex)::text = (imp.tkm_kennung_hex)::text))
4. 0.000 0.000 ↓ 0.0

Seq Scan on pos_tkm pos (cost=0.00..86,737.27 rows=1,924,627 width=20) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=36,023.06..36,023.06 rows=1,688,206 width=48) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on imp_pos_tkm imp (cost=0.00..36,023.06 rows=1,688,206 width=48) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=135,229.11..183,818.18 rows=347,539 width=228) (actual rows= loops=)

  • Hash Cond: (joined.id = pos_tkm.id)
8. 0.000 0.000 ↓ 0.0

CTE Scan on joined (cost=0.00..6,950.78 rows=347,539 width=168) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=86,737.27..86,737.27 rows=1,924,627 width=76) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on pos_tkm (cost=0.00..86,737.27 rows=1,924,627 width=76) (actual rows= loops=)