explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1mvt

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

CTE Scan on dbg_mrt (cost=918.25..918.27 rows=1 width=52) (actual rows= loops=)

  • Filter: ((dbg_mo)::text = (mrt_mo)::text)
2.          

CTE dbg_mrt

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=918.21..918.25 rows=1 width=75) (actual rows= loops=)

  • Group Key: l09.gueltig_ab, l09.gueltig_bis, b02.mo, b02_1.mo, l09.sachnr
4. 0.000 0.000 ↓ 0.0

Sort (cost=918.21..918.22 rows=1 width=54) (actual rows= loops=)

  • Sort Key: l09.gueltig_ab, l09.gueltig_bis, b02.mo, b02_1.mo, l09.sachnr
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.50..918.20 rows=1 width=54) (actual rows= loops=)

  • Join Filter: (((l09.send_unternehmen)::text = (b02.send_unternehmen)::text) AND ((l09.send_abreinh)::text = (b02.send_abreinh)::text) AND ((l09.send_standort)::text = (b02.send_standort)::text) AND ((l09.send_stoteil)::text = (b02.sen (...)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.50..915.76 rows=1 width=72) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..910.52 rows=1 width=34) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on uit_tuib02 b02_1 (cost=0.00..1.32 rows=32 width=132) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using uit_tuil02_staging_pkey1 on uit_tuil02 l02 (cost=0.56..28.29 rows=12 width=52) (actual rows= loops=)

  • Index Cond: (((send_unternehmen)::text = (b02_1.send_unternehmen)::text) AND ((send_abreinh)::text = (b02_1.send_abreinh)::text) AND ((send_standort)::text = (b02_1.send_standort)::text) AND ((send_stoteil)::text = ( (...)
10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on uit_tuil09 l09 (cost=0.94..5.12 rows=12 width=49) (actual rows= loops=)

  • Recheck Cond: (((sachnr)::text = (l02.sachnr)::text) OR ((sachnr)::text = (l02.neutralsachnr)::text))
11. 0.000 0.000 ↓ 0.0

BitmapOr (cost=0.94..0.94 rows=12 width=0) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uit_tuil09_staging_sachnr_idx (cost=0.00..0.47 rows=6 width=0) (actual rows= loops=)

  • Index Cond: ((sachnr)::text = (l02.sachnr)::text)
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uit_tuil09_staging_sachnr_idx (cost=0.00..0.47 rows=6 width=0) (actual rows= loops=)

  • Index Cond: ((sachnr)::text = (l02.neutralsachnr)::text)
14. 0.000 0.000 ↓ 0.0

Seq Scan on uit_tuib02 b02 (cost=0.00..1.32 rows=32 width=132) (actual rows= loops=)