#	exclusive	inclusive	rows x	rows	loops	node
1.	25,937.836	25,937.836	↓ 60,228.0	60,228	1	→ CTE Scan on dbg_mrt (cost=918.25..918.27 rows=1 width=52) (actual time=25,811.704..25,937.836 rows=60,228 loops=1) Filter: ((dbg_mo)::text = (mrt_mo)::text) Rows Removed by Filter: 50562
2.						CTE dbg_mrt
3.	75.322	25,900.626	↓ 110,790.0	110,790	1	→ GroupAggregate (cost=918.21..918.25 rows=1 width=75) (actual time=25,811.695..25,900.626 rows=110,790 loops=1) Group Key: l09.gueltig_ab, l09.gueltig_bis, b02.mo, b02_1.mo, l09.sachnr
4.	275.129	25,825.304	↓ 150,533.0	150,533	1	→ Sort (cost=918.21..918.22 rows=1 width=54) (actual time=25,811.675..25,825.304 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,233.106	25,550.175	↓ 150,533.0	150,533	1	→ Nested Loop (cost=1.50..918.20 rows=1 width=54) (actual time=0.294..25,550.175 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.	1,978.233	16,809.201	↓ 753,934.0	753,934	1	→ Nested Loop (cost=1.50..915.76 rows=1 width=72) (actual time=0.283..16,809.201 rows=753,934 loops=1)
7.	337.526	1,671.908	↓ 2,631,812.0	2,631,812	1	→ Nested Loop (cost=0.56..910.52 rows=1 width=34) (actual time=0.062..1,671.908 rows=2,631,812 loops=1)
8.	0.014	0.014	↑ 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.014 rows=32 loops=1)
9.	1,334.368	1,334.368	↓ 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.036..41.699 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.584 ms
Execution time	:	25,941.850 ms

"CTE Scan on dbg_mrt  (cost=918.25..918.27 rows=1 width=52) (actual time=25811.704..25937.836 rows=60228 loops=1)"
"  Filter: ((dbg_mo)::text = (mrt_mo)::text)"
"  Rows Removed by Filter: 50562"
"  CTE dbg_mrt"
"    ->  GroupAggregate  (cost=918.21..918.25 rows=1 width=75) (actual time=25811.695..25900.626 rows=110790 loops=1)"
"          Group Key: l09.gueltig_ab, l09.gueltig_bis, b02.mo, b02_1.mo, l09.sachnr"
"          ->  Sort  (cost=918.21..918.22 rows=1 width=54) (actual time=25811.675..25825.304 rows=150533 loops=1)"
"                Sort Key: l09.gueltig_ab, l09.gueltig_bis, b02.mo, b02_1.mo, l09.sachnr"
"                Sort Method: quicksort  Memory: 17905kB"
"                ->  Nested Loop  (cost=1.50..918.20 rows=1 width=54) (actual time=0.294..25550.175 rows=150533 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"
"                      ->  Nested Loop  (cost=1.50..915.76 rows=1 width=72) (actual time=0.283..16809.201 rows=753934 loops=1)"
"                            ->  Nested Loop  (cost=0.56..910.52 rows=1 width=34) (actual time=0.062..1671.908 rows=2631812 loops=1)"
"                                  ->  Seq Scan on uit_tuib02 b02_1  (cost=0.00..1.32 rows=32 width=132) (actual time=0.006..0.014 rows=32 loops=1)"
"                                  ->  Index Scan using uit_tuil02_staging_pkey1 on uit_tuil02 l02  (cost=0.56..28.29 rows=12 width=52) (actual time=0.036..41.699 rows=82244 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 = ( (...)"
"                            ->  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=2631812)"
"                                  Recheck Cond: (((sachnr)::text = (l02.sachnr)::text) OR ((sachnr)::text = (l02.neutralsachnr)::text))"
"                                  Heap Blocks: exact=717642"
"                                  ->  BitmapOr  (cost=0.94..0.94 rows=12 width=0) (actual time=0.005..0.005 rows=0 loops=2631812)"
"                                        ->  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=2631812)"
"                                              Index Cond: ((sachnr)::text = (l02.sachnr)::text)"
"                                        ->  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=2631812)"
"                                              Index Cond: ((sachnr)::text = (l02.neutralsachnr)::text)"
"                      ->  Seq Scan on uit_tuib02 b02  (cost=0.00..1.32 rows=32 width=132) (actual time=0.000..0.002 rows=32 loops=753934)"
"Planning time: 1.584 ms"
"Execution time: 25941.850 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.000 ms	0.0 %
Bitmap Index Scan	2	13,159.060 ms	50.7 %
BitmapOr	1	0.000 ms	0.0 %
CTE Scan	1	25,937.836 ms	100.0 %
GroupAggregate	1	75.322 ms	0.3 %
Index Scan	1	1,334.368 ms	5.1 %
Nested Loop	3	9,548.865 ms	36.8 %
Seq Scan	2	1,507.882 ms	5.8 %
Sort	1	275.129 ms	1.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
uit_tuib02	2	1,507.882 ms	5.8 %
Seq Scan	2	1,507.882 ms	100.0 %
uit_tuil02	1	1,334.368 ms	5.1 %
Index Scan	1	1,334.368 ms	100.0 %
uit_tuil09	1	0.000 ms	0.0 %
Bitmap Heap Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uiXf

Color mode:

Visible columns:

Per node type stats

Per table stats