explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Cgt

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

Update on terminal_material (cost=80,685.97..80,697.20 rows=2 width=166) (actual rows= loops=)

2.          

CTE joined

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.26..80,685.55 rows=1 width=12) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.84..80,673.93 rows=1 width=12) (actual rows= loops=)

  • Filter: (tn.angelegtam IS NULL)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..80,662.58 rows=20 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on terminal t1 (cost=0.00..80,501.98 rows=19 width=18) (actual rows= loops=)

  • Filter: (nicht_gerliefert IS NOT NULL)
7. 0.000 0.000 ↓ 0.0

Index Scan using ix_terminal_terminal_idx4 on terminal t2 (cost=0.42..8.44 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((tplnr)::text = (t1.tplnr)::text)
  • Filter: (nicht_gerliefert IS NULL)
8. 0.000 0.000 ↓ 0.0

Index Scan using ix_terminal_material_terminalid on terminal_material tn (cost=0.42..0.55 rows=2 width=14) (actual rows= loops=)

  • Index Cond: (t2.id = terminalid)
9. 0.000 0.000 ↓ 0.0

Index Scan using ix_terminal_material_terminalid on terminal_material tm (cost=0.42..11.61 rows=2 width=6) (actual rows= loops=)

  • Index Cond: (terminalid = t1.id)
  • Filter: (nicht_gerliefert IS NULL)
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..11.65 rows=2 width=166) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

CTE Scan on joined (cost=0.00..0.02 rows=1 width=88) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using ix_terminal_material_terminalid on terminal_material (cost=0.42..11.61 rows=2 width=100) (actual rows= loops=)

  • Index Cond: (terminalid = joined.ist)" Filter: (nicht_gerliefert IS NULL)