explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JMRg : Optimization for: plan #K6NZ

Settings

Optimization path:

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

Nested Loop Left Join (cost=0.09..22,157,358.26 rows=30 width=168) (actual rows= loops=)

  • Join Filter: (tfo.bsnr = tforbs.bsnr)
2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.09..22,142,630.45 rows=30 width=36) (actual rows= loops=)

  • Join Filter: (SubPlan 1)
3. 0.000 0.000 ↓ 0.0

Index Scan using pk_tfo on tfo (cost=0.09..199,463.88 rows=60 width=36) (actual rows= loops=)

  • Filter: ((uthdat >= '2019-05-13'::date) AND (uthdat <= '2019-05-13'::date) AND (betstnr = '9700'::bpchar) AND (betstehnr = '00'::bpchar) AND (bsstakod = 'B'::bpchar) AND (kdjbsnr = ' '::bpchar) AND ((lsid = ' '::bpchar) OR (lstotid <= CURRENT_TIMESTAMP)))
4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..453,488.10 rows=3,375,638 width=9) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on tfor (cost=0.00..433,629.46 rows=3,375,638 width=9) (actual rows= loops=)

  • Filter: (bsrdstakod = 'KL'::bpchar)
6.          

SubPlan (forNested Loop Semi Join)

7. 0.000 0.000 ↓ 0.0

Index Scan using ix_tfo_04 on tfo tfo_1 (cost=0.09..0.31 rows=1 width=9) (actual rows= loops=)

  • Index Cond: (bsalias = tfo.bsalias)
8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1,787.01 rows=39,274 width=107) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on tforbs (cost=0.00..1,747.74 rows=39,274 width=107) (actual rows= loops=)