explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iypm : SQL

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 271,736.503 2,335,964.295 ↑ 480.7 345,589 1

GroupAggregate (cost=348,091,467.42..593,111,899.25 rows=166,115,547 width=1,747) (actual time=2,062,673.795..2,335,964.295 rows=345,589 loops=1)

  • Group Key: glpca.ryear, glpca.poper, glpca.rbukrs, glpca.kokrs, glpca.werks, glpca.racct, glpca.kostl, glpca.rprctr, glpca.lifnr, glpca.kunnr, glpca.matnr, t001.butxt, t001w.name1, tka01.bezei, cskt.mctxt, csku.mctxt, cepct.mctxt, (btrim((COALESCE(lfa_1.mcod1, ''::character varying))::text)), (btrim((COALESCE(kna_1.name1, ''::character varying))::text)), sii_lifnr.acteco, sii_kunnr.acteco, bkpf.name1, bkpf.lifnr, makt.maktx, makt.matkl, makt.wgbez, mara_val.mtart, mara_val.mtbez, mara_val.mengu, mara_val.wertu, glpca.ebeln, glpca.blart, glpca.refdocnr, bkpf_header.usnam, ekpo.matkl, ekpo.wgbez, ekpo.txz01, ekpo.bsart, ekpo.zzprior, bkpf_header.belnr, bkpf_header_mm.belnr, bkpf.belnr, bkpf_header.bktxt, bkpf_header_mm.bktxt, bkpf.bktxt, xls_ceco_area.area_validada, bkpf_header_mm.waers, bkpf_header_mm.kursf, bkpf_header_mm.hwaer, bkpf_header_mm.hwae2, bkpf_header_mm.hwae3, bkpf_header_mm.kurs2, bkpf_header_mm.kurs3, bkpf_header_fi.belnr, bkpf_header_fi.waers, bkpf_header_fi.kursf, bkpf_header_fi.hwaer, bkpf_header_fi.hwae2, bkpf_header_fi.hwae3, bkpf_header_fi.kurs2, bkpf_header_fi.kurs3, bkpf_header_co_om.belnr, bkpf_header_co_om.waers, bkpf_header_co_om.kursf, bkpf_header_co_om.hwaer, bkpf_header_co_om.hwae2, bkpf_header_co_om.hwae3, bkpf_header_co_om.kurs2, bkpf_header_co_om.kurs3, bkpf_header_sd.belnr, bkpf_header_sd.waers, bkpf_header_sd.kursf, bkpf_header_sd.hwaer, bkpf_header_sd.hwae2, bkpf_header_sd.hwae3, bkpf_header_sd.kurs2, bkpf_header_sd.kurs3
2. 11,780.899 2,064,227.792 ↑ 338.6 490,611 1

Sort (cost=348,091,467.42..348,506,756.29 rows=166,115,547 width=967) (actual time=2,062,554.022..2,064,227.792 rows=490,611 loops=1)

  • Sort Key: glpca.ryear, glpca.poper, glpca.rbukrs, glpca.kokrs, glpca.werks, glpca.racct, glpca.kostl, glpca.rprctr, glpca.lifnr, glpca.kunnr, glpca.matnr, t001.butxt, t001w.name1, tka01.bezei, cskt.mctxt, csku.mctxt, cepct.mctxt, (btrim((COALESCE(lfa_1.mcod1, ''::character varying))::text)), (btrim((COALESCE(kna_1.name1, ''::character varying))::text)), sii_lifnr.acteco, sii_kunnr.acteco, bkpf.name1, bkpf.lifnr, makt.maktx, makt.matkl, makt.wgbez, mara_val.mtart, mara_val.mtbez, mara_val.mengu, mara_val.wertu, glpca.ebeln, glpca.blart, glpca.refdocnr, bkpf_header.usnam, ekpo.matkl, ekpo.wgbez, ekpo.txz01, ekpo.bsart, ekpo.zzprior, bkpf_header.belnr, bkpf_header_mm.belnr, bkpf.belnr, bkpf_header.bktxt, bkpf_header_mm.bktxt, bkpf.bktxt, xls_ceco_area.area_validada, bkpf_header_mm.waers, bkpf_header_mm.kursf, bkpf_header_mm.hwaer, bkpf_header_mm.hwae2, bkpf_header_mm.hwae3, bkpf_header_mm.kurs2, bkpf_header_mm.kurs3, bkpf_header_fi.belnr, bkpf_header_fi.waers, bkpf_header_fi.kursf, bkpf_header_fi.hwaer, bkpf_header_fi.hwae2, bkpf_header_fi.hwae3, bkpf_header_fi.kurs2, bkpf_header_fi.kurs3, bkpf_header_co_om.belnr, bkpf_header_co_om.waers, bkpf_header_co_om.kursf, bkpf_header_co_om.hwaer, bkpf_header_co_om.hwae2, bkpf_header_co_om.hwae3, bkpf_header_co_om.kurs2, bkpf_header_co_om.kurs3, bkpf_header_sd.belnr, bkpf_header_sd.waers, bkpf_header_sd.kursf, bkpf_header_sd.hwaer, bkpf_header_sd.hwae2, bkpf_header_sd.hwae3, bkpf_header_sd.kurs2, bkpf_header_sd.kurs3
  • Sort Method: external merge Disk: 201248kB
3. 225.182 2,052,446.893 ↑ 338.6 490,611 1

Hash Left Join (cost=20,566,202.90..43,792,603.02 rows=166,115,547 width=967) (actual time=2,051,508.351..2,052,446.893 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = csku.mandt) AND ((glpca.racct)::text = (csku.kstar)::text))
4. 391.372 2,052,120.337 ↑ 70.8 490,611 1

Merge Left Join (cost=20,565,200.86..21,192,243.36 rows=34,752,203 width=943) (actual time=2,051,406.935..2,052,120.337 rows=490,611 loops=1)

  • Merge Cond: ((glpca.kunnr)::text = (kna_1.kunnr)::text)
  • Join Filter: (kna_1.mandt = glpca.rclnt)
5. 1,617.460 2,050,713.254 ↑ 7.1 490,611 1

Sort (cost=20,549,655.55..20,558,363.90 rows=3,483,340 width=911) (actual time=2,050,425.800..2,050,713.254 rows=490,611 loops=1)

  • Sort Key: glpca.kunnr
  • Sort Method: external merge Disk: 188848kB
6. 283.188 2,049,095.794 ↑ 7.1 490,611 1

Merge Left Join (cost=15,926,273.49..15,992,165.63 rows=3,483,340 width=911) (actual time=2,048,602.850..2,049,095.794 rows=490,611 loops=1)

  • Merge Cond: ((glpca.lifnr)::text = (lfa_1.lifnr)::text)
  • Join Filter: (lfa_1.mandt = glpca.rclnt)
7. 1,303.079 2,047,327.481 ↑ 1.6 490,611 1

Sort (cost=15,911,516.75..15,913,450.28 rows=773,410 width=879) (actual time=2,047,137.682..2,047,327.481 rows=490,611 loops=1)

  • Sort Key: glpca.lifnr
  • Sort Method: external merge Disk: 186752kB
8. 174.767 2,046,024.402 ↑ 1.6 490,611 1

Hash Left Join (cost=14,538,450.19..15,238,437.88 rows=773,410 width=879) (actual time=2,041,423.519..2,046,024.402 rows=490,611 loops=1)

  • Hash Cond: (((glpca.rbukrs)::text = (xls_ceco_area.sociedad)::text) AND ((glpca.kostl)::text = (xls_ceco_area.ceco_sap)::text))
9. 221.567 2,045,830.873 ↑ 1.6 490,611 1

Hash Left Join (cost=14,538,389.65..15,056,613.85 rows=773,410 width=866) (actual time=2,041,404.712..2,045,830.873 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = cepct.mandt) AND ((glpca.rprctr)::text = (cepct.prctr)::text) AND ((glpca.kokrs)::text = (cepct.kokrs)::text))
10. 191.564 2,045,539.384 ↑ 1.6 490,611 1

Hash Left Join (cost=14,537,460.85..15,041,860.40 rows=773,410 width=834) (actual time=2,041,334.776..2,045,539.384 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = cskt.mandt) AND ((glpca.kostl)::text = (cskt.kostl)::text) AND ((glpca.kokrs)::text = (cskt.kokrs)::text))
11. 181.806 2,045,263.582 ↑ 1.6 490,611 1

Hash Left Join (cost=14,536,639.28..15,027,214.12 rows=773,410 width=802) (actual time=2,041,250.528..2,045,263.582 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = tka01.mandt) AND ((glpca.kokrs)::text = (tka01.kokrs)::text))
12. 173.961 2,045,073.514 ↑ 1.6 490,611 1

Hash Left Join (cost=14,536,629.22..15,020,700.40 rows=773,410 width=770) (actual time=2,041,242.256..2,045,073.514 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = t001w.mandt) AND ((glpca.werks)::text = (t001w.werks)::text))
13. 192.395 2,044,882.530 ↑ 1.6 490,611 1

Hash Left Join (cost=14,536,600.30..14,966,661.19 rows=773,410 width=738) (actual time=2,041,225.221..2,044,882.530 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = t001.mandt) AND ((glpca.rbukrs)::text = (t001.bukrs)::text))
14. 875.055 2,044,662.861 ↑ 1.6 490,611 1

Hash Left Join (cost=14,536,586.53..14,953,112.75 rows=773,410 width=706) (actual time=2,041,197.931..2,044,662.861 rows=490,611 loops=1)

  • Hash Cond: (ltrim((glpca.kunnr)::text, '0'::text) = sii_kunnr.rut_dv)
15. 942.304 2,043,461.300 ↑ 1.6 490,611 1

Hash Left Join (cost=14,490,164.18..14,757,386.26 rows=773,410 width=642) (actual time=2,040,851.044..2,043,461.300 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = makt.mandt) AND ((glpca.matnr)::text = (makt.matnr)::text))
16. 659.701 2,042,024.113 ↑ 1.6 490,611 1

Hash Left Join (cost=14,474,863.68..14,611,360.32 rows=773,410 width=599) (actual time=2,040,352.498..2,042,024.113 rows=490,611 loops=1)

  • Hash Cond: (ltrim((glpca.lifnr)::text, '0'::text) = sii_lifnr.rut_dv)
17. 338.272 2,039,666.153 ↑ 1.6 490,611 1

Merge Left Join (cost=14,428,441.33..14,436,781.82 rows=773,410 width=535) (actual time=2,038,654.210..2,039,666.153 rows=490,611 loops=1)

  • Merge Cond: (((glpca.rbukrs)::text = (bkpf.bukrs)::text) AND ((glpca.refdocnr)::text = (bkpf.belnr)::text) AND (glpca.refryear = bkpf.gjahr))
  • Join Filter: (glpca.rclnt = bkpf.mandt)
18. 3,704.798 2,038,979.618 ↑ 1.6 490,611 1

Sort (cost=14,422,917.95..14,424,851.47 rows=773,410 width=474) (actual time=2,038,313.918..2,038,979.618 rows=490,611 loops=1)

  • Sort Key: glpca.rbukrs, glpca.refdocnr, glpca.refryear
  • Sort Method: external merge Disk: 123256kB
19. 155.665 2,035,274.820 ↑ 1.6 490,611 1

Nested Loop Left Join (cost=4,875,571.16..14,014,194.07 rows=773,410 width=474) (actual time=1,495,551.811..2,035,274.820 rows=490,611 loops=1)

20. 518.328 1,925,222.291 ↓ 1.7 490,611 1

Nested Loop Left Join (cost=4,875,570.60..11,697,671.35 rows=290,855 width=436) (actual time=1,495,472.953..1,925,222.291 rows=490,611 loops=1)

21. 552.355 1,882,511.417 ↓ 1.7 490,611 1

Nested Loop Left Join (cost=4,875,570.04..9,386,904.62 rows=290,855 width=393) (actual time=1,495,457.681..1,882,511.417 rows=490,611 loops=1)

22. 29,131.637 1,543,437.472 ↓ 1.7 490,611 1

Hash Left Join (cost=4,875,569.47..7,056,920.48 rows=290,855 width=374) (actual time=1,495,299.921..1,543,437.472 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = bkpf_header_mm.mandt) AND (((glpca.refdocnr)::text || (glpca.refryear)::text) = (bkpf_header_mm.awkey)::text))
23. 35,813.417 1,194,126.267 ↓ 1.7 490,611 1

Hash Left Join (cost=3,628,240.81..5,445,213.13 rows=290,855 width=306) (actual time=1,124,942.026..1,194,126.267 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = bkpf_header_sd.mandt) AND ((glpca.refdocnr)::text = (bkpf_header_sd.awkey)::text))
24. 52,753.306 874,004.122 ↓ 1.7 490,611 1

Hash Left Join (cost=2,420,885.16..3,939,241.90 rows=290,855 width=256) (actual time=779,655.840..874,004.122 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = bkpf_header_fi.mandt) AND ((((glpca.refdocnr)::text || (glpca.rbukrs)::text) || (glpca.refryear)::text) = (bkpf_header_fi.awkey)::text))
25. 42,168.638 515,661.561 ↓ 1.7 490,611 1

Hash Left Join (cost=1,213,529.50..2,407,593.17 rows=290,855 width=206) (actual time=472,166.113..515,661.561 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = bkpf_header_co_om.mandt) AND (((glpca.refdocnr)::text || (glpca.aworg)::text) = (bkpf_header_co_om.awkey)::text))
26. 2,825.096 2,976.361 ↓ 1.7 490,611 1

Bitmap Heap Scan on glpca (cost=6,173.85..900,600.56 rows=290,855 width=163) (actual time=171.466..2,976.361 rows=490,611 loops=1)

  • Recheck Cond: (((budat)::bigint >= (concat('2019', '01', '01'))::bigint) AND ((budat)::bigint < (to_char((to_date('20190101'::text, 'YYYYMMDD'::text) + '1 mon'::interval), 'YYYYMMDD'::text))::bigint))
  • Filter: (rclnt = 300)
  • Heap Blocks: exact=30977
27. 151.265 151.265 ↓ 1.7 490,611 1

Bitmap Index Scan on indx_glpca_budat_bigint (cost=0.00..6,101.13 rows=290,855 width=0) (actual time=151.265..151.265 rows=490,611 loops=1)

  • Index Cond: (((budat)::bigint >= (concat('2019', '01', '01'))::bigint) AND ((budat)::bigint < (to_char((to_date('20190101'::text, 'YYYYMMDD'::text) + '1 mon'::interval), 'YYYYMMDD'::text))::bigint))
28. 454,981.805 470,516.562 ↑ 1.0 20,466,210 1

Hash (cost=640,536.03..640,536.03 rows=20,466,242 width=73) (actual time=470,516.562..470,516.562 rows=20,466,210 loops=1)

  • Buckets: 65536 Batches: 1024 Memory Usage: 2742kB
29. 15,534.757 15,534.757 ↑ 1.0 20,466,210 1

Seq Scan on fi_bkpf_header bkpf_header_co_om (cost=0.00..640,536.03 rows=20,466,242 width=73) (actual time=0.016..15,534.757 rows=20,466,210 loops=1)

  • Filter: (mandt = 300)
30. 294,248.573 305,589.255 ↑ 1.0 20,466,210 1

Hash (cost=640,536.03..640,536.03 rows=20,466,242 width=73) (actual time=305,589.255..305,589.255 rows=20,466,210 loops=1)

  • Buckets: 65536 Batches: 1024 Memory Usage: 2742kB
31. 11,340.682 11,340.682 ↑ 1.0 20,466,210 1

Seq Scan on fi_bkpf_header bkpf_header_fi (cost=0.00..640,536.03 rows=20,466,242 width=73) (actual time=0.024..11,340.682 rows=20,466,210 loops=1)

  • Filter: (mandt = 300)
32. 273,877.350 284,308.728 ↑ 1.0 20,466,210 1

Hash (cost=640,536.03..640,536.03 rows=20,466,242 width=73) (actual time=284,308.728..284,308.728 rows=20,466,210 loops=1)

  • Buckets: 65536 Batches: 1024 Memory Usage: 2742kB
33. 10,431.378 10,431.378 ↑ 1.0 20,466,210 1

Seq Scan on fi_bkpf_header bkpf_header_sd (cost=0.00..640,536.03 rows=20,466,242 width=73) (actual time=0.016..10,431.378 rows=20,466,210 loops=1)

  • Filter: (mandt = 300)
34. 308,638.412 320,179.568 ↑ 1.0 20,466,210 1

Hash (cost=640,536.03..640,536.03 rows=20,466,242 width=91) (actual time=320,179.568..320,179.568 rows=20,466,210 loops=1)

  • Buckets: 32768 Batches: 1024 Memory Usage: 2737kB
35. 11,541.156 11,541.156 ↑ 1.0 20,466,210 1

Seq Scan on fi_bkpf_header bkpf_header_mm (cost=0.00..640,536.03 rows=20,466,242 width=91) (actual time=1.331..11,541.156 rows=20,466,210 loops=1)

  • Filter: (mandt = 300)
36. 338,521.590 338,521.590 ↓ 0.0 0 490,611

Index Scan using indx_fi_t134_control_stock_bwkey_matnr on fi_t134_control_stock mara_val (cost=0.57..8.00 rows=1 width=43) (actual time=0.689..0.690 rows=0 loops=490,611)

  • Index Cond: (((glpca.werks)::text = (bwkey)::text) AND ((glpca.matnr)::text = (matnr)::text))
  • Filter: ((mandt = 300) AND (glpca.rclnt = mandt))
37. 42,192.546 42,192.546 ↓ 0.0 0 490,611

Index Scan using indx_fi_ekpo_oc_mandt_ebeln_ebelp on fi_ekpo_oc ekpo (cost=0.56..7.93 rows=1 width=78) (actual time=0.086..0.086 rows=0 loops=490,611)

  • Index Cond: ((glpca.rclnt = mandt) AND (mandt = 300) AND ((glpca.ebeln)::text = (ebeln)::text) AND (glpca.ebelp = ebelp))
38. 109,896.864 109,896.864 ↓ 0.0 0 490,611

Index Scan using indx_fi_bkpf_header_belnr_gjahr_bukrs on fi_bkpf_header bkpf_header (cost=0.56..7.95 rows=1 width=51) (actual time=0.223..0.224 rows=0 loops=490,611)

  • Index Cond: (((glpca.refdocnr)::text = (belnr)::text) AND (glpca.refryear = gjahr) AND ((glpca.rbukrs)::text = (bukrs)::text))
39. 2.263 348.263 ↓ 1.1 37,637 1

Materialize (cost=5,523.38..5,701.49 rows=35,622 width=90) (actual time=340.282..348.263 rows=37,637 loops=1)

40. 240.810 346.000 ↑ 1.0 35,622 1

Sort (cost=5,523.38..5,612.44 rows=35,622 width=90) (actual time=340.275..346.000 rows=35,622 loops=1)

  • Sort Key: bkpf.bukrs, bkpf.belnr, bkpf.gjahr
  • Sort Method: external sort Disk: 3728kB
41. 105.190 105.190 ↑ 1.0 35,622 1

Seq Scan on fi_bkpf_reclasificaciones bkpf (cost=0.00..1,003.28 rows=35,622 width=90) (actual time=79.696..105.190 rows=35,622 loops=1)

  • Filter: (mandt = 300)
42. 254.257 1,698.259 ↑ 1.0 851,882 1

Hash (cost=24,958.82..24,958.82 rows=851,882 width=74) (actual time=1,698.259..1,698.259 rows=851,882 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 3268kB
43. 1,444.002 1,444.002 ↑ 1.0 851,882 1

Seq Scan on fi_giro_sii sii_lifnr (cost=0.00..24,958.82 rows=851,882 width=74) (actual time=66.659..1,444.002 rows=851,882 loops=1)

44. 110.710 494.883 ↑ 1.0 306,782 1

Hash (cost=7,402.77..7,402.77 rows=306,782 width=62) (actual time=494.883..494.883 rows=306,782 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 2343kB
45. 384.173 384.173 ↑ 1.0 306,782 1

Seq Scan on fi_mara_matname makt (cost=0.00..7,402.77 rows=306,782 width=62) (actual time=63.220..384.173 rows=306,782 loops=1)

  • Filter: (mandt = 300)
46. 225.574 326.506 ↑ 1.0 851,882 1

Hash (cost=24,958.82..24,958.82 rows=851,882 width=74) (actual time=326.506..326.506 rows=851,882 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 3268kB
47. 100.932 100.932 ↑ 1.0 851,882 1

Seq Scan on fi_giro_sii sii_kunnr (cost=0.00..24,958.82 rows=851,882 width=74) (actual time=0.015..100.932 rows=851,882 loops=1)

48. 0.021 27.274 ↓ 1.0 68 1

Hash (cost=12.76..12.76 rows=67 width=45) (actual time=27.274..27.274 rows=68 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
49. 0.006 27.253 ↓ 1.0 68 1

Subquery Scan on t001 (cost=11.25..12.76 rows=67 width=45) (actual time=27.242..27.253 rows=68 loops=1)

50. 0.031 27.247 ↓ 1.0 68 1

HashAggregate (cost=11.25..12.09 rows=67 width=45) (actual time=27.241..27.247 rows=68 loops=1)

  • Group Key: t001_1.mandt, t001_1.bukrs, btrim((COALESCE(t001_1.butxt, ''::character varying))::text)
51. 27.216 27.216 ↑ 1.0 68 1

Seq Scan on t001 t001_1 (cost=0.00..10.74 rows=68 width=45) (actual time=27.086..27.216 rows=68 loops=1)

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 218
52. 0.045 17.023 ↑ 1.0 234 1

Hash (cost=25.42..25.42 rows=234 width=44) (actual time=17.023..17.023 rows=234 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
53. 0.013 16.978 ↑ 1.0 234 1

Subquery Scan on t001w (cost=20.15..25.42 rows=234 width=44) (actual time=16.944..16.978 rows=234 loops=1)

54. 0.088 16.965 ↑ 1.0 234 1

HashAggregate (cost=20.15..23.08 rows=234 width=44) (actual time=16.943..16.965 rows=234 loops=1)

  • Group Key: t001w_1.mandt, t001w_1.werks, btrim((COALESCE(t001w_1.name1, ''::character varying))::text)
55. 16.877 16.877 ↑ 1.0 234 1

Seq Scan on t001w t001w_1 (cost=0.00..18.40 rows=234 width=44) (actual time=16.590..16.877 rows=234 loops=1)

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 151
56. 0.020 8.262 ↓ 46.0 46 1

Hash (cost=10.04..10.04 rows=1 width=556) (actual time=8.262..8.262 rows=46 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
57. 0.003 8.242 ↓ 46.0 46 1

Subquery Scan on tka01 (cost=10.01..10.04 rows=1 width=556) (actual time=8.231..8.242 rows=46 loops=1)

58. 0.008 8.239 ↓ 46.0 46 1

Group (cost=10.01..10.03 rows=1 width=556) (actual time=8.230..8.239 rows=46 loops=1)

  • Group Key: tka01_1.mandt, tka01_1.kokrs, (btrim((COALESCE(tka01_1.bezei, ''::character varying))::text))
59. 0.030 8.231 ↓ 46.0 46 1

Sort (cost=10.01..10.02 rows=1 width=556) (actual time=8.229..8.231 rows=46 loops=1)

  • Sort Key: tka01_1.kokrs, (btrim((COALESCE(tka01_1.bezei, ''::character varying))::text))
  • Sort Method: quicksort Memory: 28kB
60. 8.201 8.201 ↓ 46.0 46 1

Seq Scan on tka01 tka01_1 (cost=0.00..10.00 rows=1 width=556) (actual time=8.167..8.201 rows=46 loops=1)

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 19
61. 0.828 84.238 ↓ 303.0 4,545 1

Hash (cost=821.32..821.32 rows=15 width=54) (actual time=84.238..84.238 rows=4,545 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 405kB
62. 0.434 83.410 ↓ 303.0 4,545 1

Subquery Scan on cskt (cost=759.95..821.32 rows=15 width=54) (actual time=82.071..83.410 rows=4,545 loops=1)

  • Filter: (cskt.mandt = 300)
63. 0.732 82.976 ↓ 1.5 4,545 1

Unique (cost=759.95..784.09 rows=2,978 width=63) (actual time=82.069..82.976 rows=4,545 loops=1)

64. 28.110 82.244 ↓ 2.3 7,373 1

Sort (cost=759.95..768.00 rows=3,219 width=63) (actual time=82.067..82.244 rows=7,373 loops=1)

  • Sort Key: cskt_1.kokrs, cskt_1.kostl, cskt_1.datbi DESC
  • Sort Method: quicksort Memory: 1071kB
65. 54.134 54.134 ↓ 2.3 7,373 1

Seq Scan on cskt cskt_1 (cost=0.00..572.40 rows=3,219 width=63) (actual time=24.505..54.134 rows=7,373 loops=1)

  • Filter: (((spras)::text = 'S'::text) AND (mandt = 300))
  • Rows Removed by Filter: 10384
66. 1.765 69.922 ↓ 328.1 8,858 1

Hash (cost=928.33..928.33 rows=27 width=55) (actual time=69.922..69.922 rows=8,858 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 796kB
67. 0.876 68.157 ↓ 328.1 8,858 1

Subquery Scan on cepct (cost=817.94..928.33 rows=27 width=55) (actual time=65.941..68.157 rows=8,858 loops=1)

  • Filter: (cepct.mandt = 300)
68. 1.110 67.281 ↓ 1.6 8,858 1

Unique (cost=817.94..860.55 rows=5,422 width=64) (actual time=65.938..67.281 rows=8,858 loops=1)

69. 26.008 66.171 ↓ 1.6 8,907 1

Sort (cost=817.94..832.15 rows=5,681 width=64) (actual time=65.936..66.171 rows=8,907 loops=1)

  • Sort Key: cepct_1.prctr, cepct_1.kokrs, cepct_1.datbi DESC
  • Sort Method: quicksort Memory: 1472kB
70. 40.163 40.163 ↓ 1.6 8,907 1

Seq Scan on cepct cepct_1 (cost=0.00..463.68 rows=5,681 width=64) (actual time=22.703..40.163 rows=8,907 loops=1)

  • Filter: (((spras)::text = 'S'::text) AND (mandt = 300))
  • Rows Removed by Filter: 5058
71. 0.172 18.762 ↓ 1.1 977 1

Hash (cost=46.67..46.67 rows=925 width=28) (actual time=18.762..18.762 rows=977 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 67kB
72. 0.051 18.590 ↓ 1.1 977 1

Subquery Scan on xls_ceco_area (cost=28.17..46.67 rows=925 width=28) (actual time=18.440..18.590 rows=977 loops=1)

73. 0.417 18.539 ↓ 1.1 977 1

HashAggregate (cost=28.17..37.42 rows=925 width=28) (actual time=18.439..18.539 rows=977 loops=1)

  • Group Key: xls_1.sociedad, xls_1.ceco_sap, xls_1.area_validada
74. 18.122 18.122 ↑ 1.0 981 1

Seq Scan on xls_ceco_area xls_1 (cost=0.00..20.81 rows=981 width=28) (actual time=17.953..18.122 rows=981 loops=1)

75. 8.092 1,485.125 ↓ 2.8 134,639 1

Materialize (cost=14,756.74..15,941.89 rows=47,404 width=50) (actual time=1,465.160..1,485.125 rows=134,639 loops=1)

76. 7.094 1,477.033 ↑ 1.0 46,854 1

Group (cost=14,756.74..15,349.34 rows=47,404 width=50) (actual time=1,465.148..1,477.033 rows=46,854 loops=1)

  • Group Key: lfa_1.mandt, lfa_1.lifnr, (btrim((COALESCE(lfa_1.mcod1, ''::character varying))::text))
77. 301.020 1,469.939 ↑ 1.0 46,854 1

Sort (cost=14,756.74..14,875.26 rows=47,409 width=50) (actual time=1,465.145..1,469.939 rows=46,854 loops=1)

  • Sort Key: lfa_1.lifnr, (btrim((COALESCE(lfa_1.mcod1, ''::character varying))::text))
  • Sort Method: external sort Disk: 2448kB
78. 1,168.919 1,168.919 ↑ 1.0 46,855 1

Seq Scan on lfa1 lfa_1 (cost=0.00..11,074.75 rows=47,409 width=50) (actual time=44.914..1,168.919 rows=46,855 loops=1)

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 138843
79. 16.714 1,015.711 ↓ 4.5 292,883 1

Materialize (cost=15,545.31..17,169.48 rows=64,769 width=50) (actual time=981.116..1,015.711 rows=292,883 loops=1)

80. 10.248 998.997 ↓ 1.0 65,089 1

Group (cost=15,545.31..16,359.87 rows=64,769 width=50) (actual time=981.097..998.997 rows=65,089 loops=1)

  • Group Key: kna_1.mandt, kna_1.kunnr, (btrim((COALESCE(kna_1.name1, ''::character varying))::text))
81. 414.356 988.749 ↑ 1.0 65,089 1

Sort (cost=15,545.31..15,708.47 rows=65,264 width=50) (actual time=981.094..988.749 rows=65,089 loops=1)

  • Sort Key: kna_1.kunnr, (btrim((COALESCE(kna_1.name1, ''::character varying))::text))
  • Sort Method: external sort Disk: 3464kB
82. 574.393 574.393 ↑ 1.0 65,091 1

Seq Scan on kna1 kna_1 (cost=0.00..8,093.15 rows=65,264 width=50) (actual time=358.446..574.393 rows=65,091 loops=1)

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 34508
83. 0.817 101.374 ↓ 2.2 5,337 1

Hash (cost=966.19..966.19 rows=2,390 width=50) (actual time=101.374..101.374 rows=5,337 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 433kB
84. 0.295 100.557 ↓ 2.2 5,337 1

Subquery Scan on csku (cost=912.42..966.19 rows=2,390 width=50) (actual time=99.636..100.557 rows=5,337 loops=1)

85. 2.062 100.262 ↓ 2.2 5,337 1

HashAggregate (cost=912.42..942.29 rows=2,390 width=50) (actual time=99.634..100.262 rows=5,337 loops=1)

  • Group Key: csku_1.mandt, csku_1.kstar, btrim((COALESCE(csku_1.mctxt, ''::character varying))::text)
86. 56.145 98.200 ↓ 2.1 5,488 1

Bitmap Heap Scan on csku csku_1 (cost=159.85..893.11 rows=2,574 width=50) (actual time=68.409..98.200 rows=5,488 loops=1)

  • Recheck Cond: ((spras)::text = 'S'::text)
  • Filter: (mandt = 300)
  • Rows Removed by Filter: 1893
  • Heap Blocks: exact=130
87. 42.055 42.055 ↓ 1.0 7,381 1

Bitmap Index Scan on indx_csku_spras (cost=0.00..159.20 rows=7,322 width=0) (actual time=42.055..42.055 rows=7,381 loops=1)

  • Index Cond: ((spras)::text = 'S'::text)
Planning time : 20.528 ms
Execution time : 2,336,139.933 ms