explain.depesz.com

A tool for finding a real cause for slow queries.

Result: f5t

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

Gather Motion 20:1 (slice3; segments: 20) (cost=1202687.47..13229938.92 rows=920 width=191) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=1202687.47..13229938.92 rows=920 width=191) (actual time=.. rows= loops=)

  • Hash Cond: btrim(a.bukrs_clr::text) = a.bukrs::text AND btrim(a.belnr_clr::text) = a.augbl::text AND a.gjahr_clr::numeric = a.gjahr::numeric
3. 0.000 0.000 ↓ 0.0
→

Redistribute Motion 20:20 (slice1; segments: 20) (cost=0.00..10440044.06 rows=5214872 width=78) (actual time=.. rows= loops=)

  • Hash Key: a.gjahr_clr::numeric, btrim(a.belnr_clr::text), btrim(a.bukrs_clr::text)
4. 0.000 0.000 ↓ 0.0
→

Subquery Scan a (cost=0.00..8354095.29 rows=5214872 width=78) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0
→

Append (cost=0.00..7311120.91 rows=5214872 width=170) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Seq Scan on bse_clr (cost=0.00..1829023.91 rows=4886061 width=170) (actual time=.. rows= loops=)

  • Filter: mandt::text = '368'::text
7. 0.000 0.000 ↓ 0.0
→

Hash Left Join (cost=3950620.97..4439122.61 rows=328812 width=168) (actual time=.. rows= loops=)

  • Hash Cond: bse_clr_arc.mandt::text = smusap.bse_clr.mandt::text AND bse_clr_arc.bukrs_clr::text = smusap.bse_clr.bukrs_clr::text AND bse_clr_arc.belnr_clr::text = smusap.bse_clr.belnr_clr::text AND bse_clr_arc.gjahr_clr::text = smusap.bse_clr.gjahr_clr::text AND bse_clr_arc.index_clr::text = smusap.bse_clr.index_clr::text
  • Filter: smusap.bse_clr.bukrs_clr IS NULL
8. 0.000 0.000 ↓ 0.0
→

Append-only Scan on bse_clr_arc (cost=0.00..71307.21 rows=328812 width=168) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Hash (cost=1584701.53..1584701.53 rows=4886448 width=32) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0
→

Seq Scan on bse_clr (cost=0.00..1584701.53 rows=4886448 width=32) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0
→

Hash (cost=687360.82..687360.82 rows=1069505 width=191) (actual time=.. rows= loops=)

12. 0.000 0.000 ↓ 0.0
→

Redistribute Motion 20:20 (slice2; segments: 20) (cost=0.00..687360.82 rows=1069505 width=191) (actual time=.. rows= loops=)

  • Hash Key: a.gjahr::numeric, a.augbl::text, a.bukrs::text
13. 0.000 0.000 ↓ 0.0
→

Append-only Scan on stg_ar_billing1_con a (cost=0.00..259558.94 rows=1069505 width=191) (actual time=.. rows= loops=)