explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bLZo1

Settings
# exclusive inclusive rows x rows loops node
1. 1,008.993 33,183.456 ↓ 134.0 26,804 1

HashAggregate (cost=1,362,039.90..1,362,041.90 rows=200 width=44) (actual time=33,179.555..33,183.456 rows=26,804 loops=1)

  • Group Key: rel.parent_snr
2.          

CTE unified_assembly_relations

3. 285.612 30,496.345 ↓ 8.9 6,733,370 1

Append (cost=1,330,841.72..1,345,040.18 rows=755,543 width=11) (actual time=26,953.062..30,496.345 rows=6,733,370 loops=1)

4. 431.369 30,209.342 ↓ 8.9 6,733,370 1

Subquery Scan on "*SELECT* 1" (cost=1,330,841.72..1,340,285.94 rows=755,538 width=11) (actual time=26,953.061..30,209.342 rows=6,733,370 loops=1)

5. 18,608.547 29,777.973 ↓ 8.9 6,733,370 1

Sort (cost=1,330,841.72..1,332,730.56 rows=755,538 width=25) (actual time=26,953.058..29,777.973 rows=6,733,370 loops=1)

  • Sort Key: assembly_relation.kogr, assembly_relation.typnr, assembly_relation.fixzus
  • Sort Method: external merge Disk: 250,376kB
6. 3,594.511 11,169.426 ↓ 8.9 6,733,370 1

Hash Join (cost=817,376.60..1,257,074.22 rows=755,538 width=25) (actual time=7,577.684..11,169.426 rows=6,733,370 loops=1)

  • Hash Cond: (indata.part_number = assembly_relation.child_snr)
7. 0.096 0.096 ↑ 1.1 1,000 1

Seq Scan on temp_read_assembly_parent_part_numbers_input indata (cost=0.00..21.30 rows=1,130 width=44) (actual time=0.009..0.096 rows=1,000 loops=1)

8. 4,537.168 7,574.819 ↑ 1.0 19,612,514 1

Hash (cost=418,995.60..418,995.60 rows=19,612,560 width=36) (actual time=7,574.819..7,574.819 rows=19,612,514 loops=1)

  • Buckets: 1,048,576 Batches: 32 Memory Usage: 59,109kB
9. 3,037.651 3,037.651 ↑ 1.0 19,612,514 1

Seq Scan on assembly_relation (cost=0.00..418,995.60 rows=19,612,560 width=36) (actual time=0.011..3,037.651 rows=19,612,514 loops=1)

10. 0.001 1.391 ↓ 0.0 0 1

Subquery Scan on "*SELECT* 2" (cost=976.46..976.53 rows=5 width=11) (actual time=1.391..1.391 rows=0 loops=1)

11. 0.010 1.390 ↓ 0.0 0 1

Sort (cost=976.46..976.48 rows=5 width=25) (actual time=1.390..1.390 rows=0 loops=1)

  • Sort Key: bt.kogr, bt.typ, bt.""position"
  • Sort Method: quicksort Memory: 25kB
12. 0.072 1.380 ↓ 0.0 0 1

Hash Join (cost=950.82..976.40 rows=5 width=25) (actual time=1.380..1.380 rows=0 loops=1)

  • Hash Cond: (indata_1.part_number = bt.sachnr)
13. 0.064 0.064 ↑ 1.1 1,000 1

Seq Scan on temp_read_assembly_parent_part_numbers_input indata_1 (cost=0.00..21.30 rows=1,130 width=44) (actual time=0.013..0.064 rows=1,000 loops=1)

14. 0.044 1.244 ↓ 208.0 208 1

Hash (cost=950.80..950.80 rows=1 width=47) (actual time=1.243..1.244 rows=208 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
15. 0.046 1.200 ↓ 208.0 208 1

Nested Loop (cost=0.42..950.80 rows=1 width=47) (actual time=0.037..1.200 rows=208 loops=1)

16. 0.322 0.322 ↑ 1.0 208 1

Seq Scan on lmt_tlm0bt bt (cost=0.00..63.64 rows=208 width=39) (actual time=0.009..0.322 rows=208 loops=1)

  • Filter: ((relevanz_kz = 'P'::bpchar) AND (eaenr = 'E00000'::bpchar))
  • Rows Removed by Filter: 1,435
17. 0.832 0.832 ↑ 1.0 1 208

Index Only Scan using lmt_tlm0bv_staging_pkey1 on lmt_tlm0bv bv (cost=0.42..4.26 rows=1 width=29) (actual time=0.004..0.004 rows=1 loops=208)

  • Index Cond: ((mo = bt.mo) AND (bauk_snr = bt.bauk_snr) AND (sachnr = bt.sachnr) AND (""position"" = bt.""position""))
  • Heap Fetches: 0
18. 32,174.463 32,174.463 ↓ 8.9 6,733,370 1

CTE Scan on unified_assembly_relations rel (cost=0.00..15,110.86 rows=755,543 width=44) (actual time=26,953.066..32,174.463 rows=6,733,370 loops=1)

Planning time : 1.363 ms
Execution time : 33,239.731 ms