explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2PKn

Settings
# exclusive inclusive rows x rows loops node
1. 26,208.418 26,208.418 ↓ 60,228.0 60,228 1

CTE Scan on dbg_mrt (cost=918.25..918.27 rows=1 width=52) (actual time=26,078.837..26,208.418 rows=60,228 loops=1)

  • Filter: ((dbg_mo)::text = (mrt_mo)::text)
  • Rows Removed by Filter: 50562
2.          

CTE dbg_mrt

3. 76.826 26,169.968 ↓ 110,790.0 110,790 1

GroupAggregate (cost=918.21..918.25 rows=1 width=75) (actual time=26,078.829..26,169.968 rows=110,790 loops=1)

  • Group Key: l09.gueltig_ab, l09.gueltig_bis, b02.mo, b02_1.mo, l09.sachnr
4. 281.777 26,093.142 ↓ 150,533.0 150,533 1

Sort (cost=918.21..918.22 rows=1 width=54) (actual time=26,078.807..26,093.142 rows=150,533 loops=1)

  • Sort Key: l09.gueltig_ab, l09.gueltig_bis, b02.mo, b02_1.mo, l09.sachnr
  • Sort Method: quicksort Memory: 17905kB
5. 7,307.229 25,811.365 ↓ 150,533.0 150,533 1

Nested Loop (cost=1.50..918.20 rows=1 width=54) (actual time=0.288..25,811.365 rows=150,533 loops=1)

  • 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 (...)
  • Rows Removed by Join Filter: 23975355
6. 2,130.521 16,996.268 ↓ 753,934.0 753,934 1

Nested Loop (cost=1.50..915.76 rows=1 width=72) (actual time=0.278..16,996.268 rows=753,934 loops=1)

7. 336.756 1,706.687 ↓ 2,631,812.0 2,631,812 1

Nested Loop (cost=0.56..910.52 rows=1 width=34) (actual time=0.063..1,706.687 rows=2,631,812 loops=1)

8. 0.011 0.011 ↑ 1.0 32 1

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

9. 1,369.920 1,369.920 ↓ 6,853.7 82,244 32

Index Scan using uit_tuil02_staging_pkey1 on uit_tuil02 l02 (cost=0.56..28.29 rows=12 width=52) (actual time=0.034..42.810 rows=82,244 loops=32)

  • 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 13,159.060 ↓ 0.0 0 2,631,812

Bitmap Heap Scan on uit_tuil09 l09 (cost=0.94..5.12 rows=12 width=49) (actual time=0.005..0.005 rows=0 loops=2,631,812)

  • Recheck Cond: (((sachnr)::text = (l02.sachnr)::text) OR ((sachnr)::text = (l02.neutralsachnr)::text))
  • Heap Blocks: exact=717642
11. 0.000 13,159.060 ↓ 0.0 0 2,631,812

BitmapOr (cost=0.94..0.94 rows=12 width=0) (actual time=0.005..0.005 rows=0 loops=2,631,812)

12. 10,527.248 10,527.248 ↓ 0.0 0 2,631,812

Bitmap Index Scan on uit_tuil09_staging_sachnr_idx (cost=0.00..0.47 rows=6 width=0) (actual time=0.004..0.004 rows=0 loops=2,631,812)

  • Index Cond: ((sachnr)::text = (l02.sachnr)::text)
13. 2,631.812 2,631.812 ↓ 0.0 0 2,631,812

Bitmap Index Scan on uit_tuil09_staging_sachnr_idx (cost=0.00..0.47 rows=6 width=0) (actual time=0.001..0.001 rows=0 loops=2,631,812)

  • Index Cond: ((sachnr)::text = (l02.neutralsachnr)::text)
14. 1,507.868 1,507.868 ↑ 1.0 32 753,934

Seq Scan on uit_tuib02 b02 (cost=0.00..1.32 rows=32 width=132) (actual time=0.000..0.002 rows=32 loops=753,934)

Planning time : 1.437 ms
Execution time : 26,212.393 ms