explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FOid : Optimization for: SQL; plan #Iypm

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 287,688.587 811,669.920 ↑ 36.2 345,589 1

GroupAggregate (cost=38,338,004.58..56,801,162.20 rows=12,517,395 width=1,746) (actual time=522,280.678..811,669.920 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, lfa1.name1, kna1.name1, 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. 13,107.596 523,981.333 ↑ 25.5 490,611 1

Sort (cost=38,338,004.58..38,369,298.07 rows=12,517,395 width=966) (actual time=522,181.623..523,981.333 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, lfa1.name1, kna1.name1, 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: 201232kB
3. 420.179 510,873.737 ↑ 25.5 490,611 1

Merge Left Join (cost=26,017,409.72..26,251,911.49 rows=12,517,395 width=966) (actual time=510,160.509..510,873.737 rows=490,611 loops=1)

  • Merge Cond: ((glpca.kunnr)::text = (kna1.kunnr)::text)
  • Join Filter: (kna1.mandt = glpca.rclnt)
4. 1,559.963 509,448.370 ↑ 6.3 490,611 1

Sort (cost=26,002,193.77..26,009,917.45 rows=3,089,473 width=942) (actual time=509,172.923..509,448.370 rows=490,611 loops=1)

  • Sort Key: glpca.kunnr
  • Sort Method: external merge Disk: 197664kB
5. 231.527 507,888.407 ↑ 6.3 490,611 1

Hash Left Join (cost=23,804,503.62..24,391,437.61 rows=3,089,473 width=942) (actual time=506,647.997..507,888.407 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = csku.mandt) AND ((glpca.racct)::text = (csku.kstar)::text))
6. 251.511 507,565.775 ↑ 1.7 490,611 1

Hash Left Join (cost=23,803,501.57..23,850,963.97 rows=844,111 width=910) (actual time=506,556.863..507,565.775 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))
7. 222.825 507,244.888 ↑ 1.7 490,611 1

Hash Left Join (cost=23,802,572.78..23,834,946.71 rows=844,111 width=878) (actual time=506,487.464..507,244.888 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))
8. 330.708 506,935.782 ↑ 1.7 490,611 1

Merge Left Join (cost=23,801,751.20..23,819,036.66 rows=844,111 width=846) (actual time=506,401.167..506,935.782 rows=490,611 loops=1)

  • Merge Cond: ((glpca.lifnr)::text = (lfa1.lifnr)::text)
  • Join Filter: (lfa1.mandt = glpca.rclnt)
9. 1,204.444 505,204.840 ↑ 1.0 490,611 1

Sort (cost=23,785,572.73..23,786,829.49 rows=502,703 width=814) (actual time=505,009.417..505,204.840 rows=490,611 loops=1)

  • Sort Key: glpca.lifnr
  • Sort Method: external merge Disk: 176208kB
10. 210.992 504,000.396 ↑ 1.0 490,611 1

Hash Left Join (cost=21,786,105.01..23,557,553.90 rows=502,703 width=814) (actual time=451,538.339..504,000.396 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))
11. 220.668 503,772.191 ↑ 1.0 490,611 1

Hash Left Join (cost=21,786,044.46..23,439,353.93 rows=502,703 width=801) (actual time=451,521.112..503,772.191 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = tka01.mandt) AND ((glpca.kokrs)::text = (tka01.kokrs)::text))
12. 206.781 503,532.206 ↑ 1.0 490,611 1

Hash Left Join (cost=21,786,034.41..23,435,116.60 rows=502,703 width=769) (actual time=451,501.783..503,532.206 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = t001w.mandt) AND ((glpca.werks)::text = (t001w.werks)::text))
13. 225.951 503,308.439 ↑ 1.0 490,611 1

Hash Left Join (cost=21,786,005.48..23,399,984.10 rows=502,703 width=737) (actual time=451,484.786..503,308.439 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = t001.mandt) AND ((glpca.rbukrs)::text = (t001.bukrs)::text))
14. 261.441 503,038.261 ↑ 1.0 490,611 1

Hash Left Join (cost=21,785,991.72..23,391,173.03 rows=502,703 width=705) (actual time=451,440.547..503,038.261 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = makt.mandt) AND ((glpca.matnr)::text = (makt.matnr)::text))
15. 729.141 502,319.674 ↑ 1.0 490,611 1

Hash Left Join (cost=21,773,987.21..23,372,910.51 rows=502,703 width=662) (actual time=450,981.492..502,319.674 rows=490,611 loops=1)

  • Hash Cond: (ltrim((glpca.kunnr)::text, '0'::text) = sii_kunnr.rut_dv)
16. 509.552 501,267.264 ↑ 1.0 490,611 1

Hash Left Join (cost=21,727,564.87..23,231,548.62 rows=502,703 width=599) (actual time=450,656.563..501,267.264 rows=490,611 loops=1)

  • Hash Cond: (ltrim((glpca.lifnr)::text, '0'::text) = sii_lifnr.rut_dv)
17. 313.848 499,050.793 ↑ 1.0 490,611 1

Merge Left Join (cost=21,681,142.52..23,098,040.73 rows=502,703 width=536) (actual time=448,947.907..499,050.793 rows=490,611 loops=1)

  • Merge Cond: (((glpca.refdocnr)::text = (bkpf.belnr)::text) AND (glpca.refryear = bkpf.gjahr) AND ((glpca.rbukrs)::text = (bkpf.bukrs)::text))
  • Join Filter: (glpca.rclnt = bkpf.mandt)
18. 6,404.609 498,619.990 ↑ 1.0 490,611 1

Merge Left Join (cost=21,677,446.14..23,090,191.66 rows=502,703 width=475) (actual time=448,832.068..498,619.990 rows=490,611 loops=1)

  • Merge Cond: ((glpca.refdocnr)::text = (bkpf_header_sd.awkey)::text)
  • Join Filter: (bkpf_header_sd.mandt = glpca.rclnt)
19. 6,422.212 481,528.750 ↑ 1.0 490,611 1

Merge Left Join (cost=21,677,445.57..21,943,982.94 rows=502,703 width=425) (actual time=448,832.036..481,528.750 rows=490,611 loops=1)

  • Merge Cond: (((glpca.refdocnr)::text = (bkpf_header.belnr)::text) AND (glpca.refryear = bkpf_header.gjahr) AND ((glpca.rbukrs)::text = (bkpf_header.bukrs)::text))
  • Join Filter: (glpca.rclnt = bkpf_header.mandt)
20. 3,712.774 323,134.323 ↓ 1.0 490,611 1

Sort (cost=17,781,867.08..17,783,069.80 rows=481,089 width=387) (actual time=322,545.052..323,134.323 rows=490,611 loops=1)

  • Sort Key: glpca.refdocnr, glpca.refryear, glpca.rbukrs
  • Sort Method: external merge Disk: 110776kB
21. 8,123.865 319,421.549 ↓ 1.0 490,611 1

Hash Left Join (cost=10,581,089.66..17,650,953.54 rows=481,089 width=387) (actual time=252,962.203..319,421.549 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))
22. 13,166.631 275,380.777 ↓ 1.0 490,611 1

Hash Left Join (cost=9,333,698.25..15,995,984.67 rows=481,089 width=319) (actual time=217,044.405..275,380.777 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))
23. 13,663.778 246,350.686 ↓ 1.0 490,611 1

Hash Left Join (cost=8,126,282.84..14,414,576.57 rows=481,089 width=269) (actual time=112,053.408..246,350.686 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))
24. 32,713.987 191,752.171 ↓ 1.0 490,611 1

Hash Left Join (cost=6,918,867.43..12,873,948.15 rows=481,089 width=226) (actual time=70,495.326..191,752.171 rows=490,611 loops=1)

  • Hash Cond: ((glpca.rclnt = mara_val.mandt) AND ((glpca.werks)::text = (mara_val.bwkey)::text) AND ((glpca.matnr)::text = (mara_val.matnr)::text))
25. 4,110.749 92,137.914 ↓ 1.0 490,611 1

Merge Left Join (cost=3,472,923.91..3,585,198.06 rows=481,089 width=207) (actual time=3,589.900..92,137.914 rows=490,611 loops=1)

  • Merge Cond: ((glpca.ebelp = ekpo.ebelp) AND ((glpca.ebeln)::text = (ekpo.ebeln)::text))
  • Join Filter: (glpca.rclnt = ekpo.mandt)
26. 906.731 3,788.619 ↓ 1.0 490,611 1

Sort (cost=1,434,731.61..1,435,934.33 rows=481,089 width=163) (actual time=3,589.895..3,788.619 rows=490,611 loops=1)

  • Sort Key: glpca.ebelp, glpca.ebeln
  • Sort Method: external sort Disk: 72032kB
27. 2,729.735 2,881.888 ↓ 1.0 490,611 1

Bitmap Heap Scan on glpca (cost=10,211.75..1,349,860.56 rows=481,089 width=163) (actual time=174.959..2,881.888 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
28. 152.153 152.153 ↓ 1.0 490,611 1

Bitmap Index Scan on indx_glpca_budat_bigint (cost=0.00..10,091.48 rows=481,089 width=0) (actual time=152.153..152.153 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))
29. 818.315 84,238.546 ↑ 1.0 10,810,450 1

Materialize (cost=2,038,192.30..2,092,445.93 rows=10,850,726 width=79) (actual time=73,335.904..84,238.546 rows=10,810,450 loops=1)

30. 71,445.284 83,420.231 ↑ 1.0 10,771,335 1

Sort (cost=2,038,192.30..2,065,319.11 rows=10,850,726 width=79) (actual time=73,335.899..83,420.231 rows=10,771,335 loops=1)

  • Sort Key: ekpo.ebelp, ekpo.ebeln
  • Sort Method: external merge Disk: 968440kB
31. 11,974.947 11,974.947 ↓ 1.0 10,850,951 1

Seq Scan on fi_ekpo_oc ekpo (cost=0.00..288,076.08 rows=10,850,726 width=79) (actual time=20.856..11,974.947 rows=10,850,951 loops=1)

  • Filter: (mandt = 300)
32. 25,318.803 66,900.270 ↓ 1.0 71,785,282 1

Hash (cost=1,558,814.30..1,558,814.30 rows=71,783,784 width=43) (actual time=66,900.270..66,900.270 rows=71,785,282 loops=1)

  • Buckets: 524288 Batches: 256 Memory Usage: 25779kB
33. 41,581.467 41,581.467 ↓ 1.0 71,785,282 1

Seq Scan on fi_t134_control_stock mara_val (cost=0.00..1,558,814.30 rows=71,783,784 width=43) (actual time=0.021..41,581.467 rows=71,785,282 loops=1)

  • Filter: (mandt = 300)
34. 11,695.937 40,934.737 ↑ 1.0 20,466,210 1

Hash (cost=640,554.55..640,554.55 rows=20,467,724 width=73) (actual time=40,934.737..40,934.737 rows=20,466,210 loops=1)

  • Buckets: 524288 Batches: 128 Memory Usage: 21961kB
35. 29,238.800 29,238.800 ↑ 1.0 20,466,210 1

Seq Scan on fi_bkpf_header bkpf_header_co_om (cost=0.00..640,554.55 rows=20,467,724 width=73) (actual time=0.022..29,238.800 rows=20,466,210 loops=1)

  • Filter: (mandt = 300)
36. 8,384.143 15,863.460 ↑ 1.0 20,466,210 1

Hash (cost=640,554.55..640,554.55 rows=20,467,724 width=73) (actual time=15,863.460..15,863.460 rows=20,466,210 loops=1)

  • Buckets: 524288 Batches: 128 Memory Usage: 21961kB
37. 7,479.317 7,479.317 ↑ 1.0 20,466,210 1

Seq Scan on fi_bkpf_header bkpf_header_fi (cost=0.00..640,554.55 rows=20,467,724 width=73) (actual time=0.020..7,479.317 rows=20,466,210 loops=1)

  • Filter: (mandt = 300)
38. 10,654.426 35,916.907 ↑ 1.0 20,466,210 1

Hash (cost=640,554.55..640,554.55 rows=20,467,724 width=91) (actual time=35,916.907..35,916.907 rows=20,466,210 loops=1)

  • Buckets: 262144 Batches: 128 Memory Usage: 21807kB
39. 25,262.481 25,262.481 ↑ 1.0 20,466,210 1

Seq Scan on fi_bkpf_header bkpf_header_mm (cost=0.00..640,554.55 rows=20,467,724 width=91) (actual time=0.021..25,262.481 rows=20,466,210 loops=1)

  • Filter: (mandt = 300)
40. 1,238.851 151,972.215 ↑ 1.1 18,317,534 1

Materialize (cost=3,895,578.49..3,997,917.11 rows=20,467,724 width=59) (actual time=126,286.973..151,972.215 rows=18,317,534 loops=1)

41. 144,365.154 150,733.364 ↑ 1.1 18,192,405 1

Sort (cost=3,895,578.49..3,946,747.80 rows=20,467,724 width=59) (actual time=126,286.968..150,733.364 rows=18,192,405 loops=1)

  • Sort Key: bkpf_header.belnr, bkpf_header.gjahr, bkpf_header.bukrs
  • Sort Method: external merge Disk: 1324624kB
42. 6,368.210 6,368.210 ↑ 1.0 20,466,210 1

Seq Scan on fi_bkpf_header bkpf_header (cost=0.00..640,554.55 rows=20,467,724 width=59) (actual time=0.021..6,368.210 rows=20,466,210 loops=1)

  • Filter: (mandt = 300)
43. 10,686.631 10,686.631 ↓ 1.0 20,521,489 1

Index Scan using indx_fi_bkpf_header_awkey on fi_bkpf_header bkpf_header_sd (cost=0.56..1,089,780.73 rows=20,467,724 width=73) (actual time=0.028..10,686.631 rows=20,521,489 loops=1)

  • Filter: (mandt = 300)
44. 21.410 116.955 ↑ 1.5 24,510 1

Sort (cost=3,696.38..3,785.44 rows=35,622 width=90) (actual time=115.832..116.955 rows=24,510 loops=1)

  • Sort Key: bkpf.belnr, bkpf.gjahr, bkpf.bukrs
  • Sort Method: quicksort Memory: 6543kB
45. 95.545 95.545 ↑ 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=54.597..95.545 rows=35,622 loops=1)

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

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

  • Buckets: 524288 Batches: 4 Memory Usage: 26123kB
47. 1,449.724 1,449.724 ↑ 1.0 851,882 1

Seq Scan on fi_giro_sii sii_lifnr (cost=0.00..24,958.82 rows=851,882 width=73) (actual time=74.216..1,449.724 rows=851,882 loops=1)

48. 224.660 323.269 ↑ 1.0 851,882 1

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

  • Buckets: 524288 Batches: 4 Memory Usage: 26123kB
49. 98.609 98.609 ↑ 1.0 851,882 1

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

50. 90.626 457.146 ↑ 1.0 306,782 1

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

  • Buckets: 524288 Batches: 1 Memory Usage: 33597kB
51. 366.520 366.520 ↑ 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=47.881..366.520 rows=306,782 loops=1)

  • Filter: (mandt = 300)
52. 0.025 44.227 ↓ 1.0 68 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
53. 0.005 44.202 ↓ 1.0 68 1

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

54. 0.031 44.197 ↓ 1.0 68 1

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

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

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

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 218
56. 0.046 16.986 ↑ 1.0 234 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
57. 0.012 16.940 ↑ 1.0 234 1

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

58. 0.092 16.928 ↑ 1.0 234 1

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

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

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

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 151
60. 0.022 19.317 ↓ 46.0 46 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
61. 0.007 19.295 ↓ 46.0 46 1

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

62. 0.008 19.288 ↓ 46.0 46 1

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

  • Group Key: tka01_1.mandt, tka01_1.kokrs, (btrim((COALESCE(tka01_1.bezei, ''::character varying))::text))
63. 0.044 19.280 ↓ 46.0 46 1

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

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

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

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 19
65. 0.161 17.213 ↓ 1.1 977 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 67kB
66. 0.058 17.052 ↓ 1.1 977 1

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

67. 0.522 16.994 ↓ 1.1 977 1

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

  • Group Key: xls_1.sociedad, xls_1.ceco_sap, xls_1.area_validada
68. 16.472 16.472 ↑ 1.0 981 1

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

69. 190.122 1,400.234 ↓ 2.8 134,639 1

Sort (cost=16,178.47..16,296.98 rows=47,404 width=50) (actual time=1,391.739..1,400.234 rows=134,639 loops=1)

  • Sort Key: lfa1.lifnr
  • Sort Method: quicksort Memory: 5197kB
70. 2.400 1,210.112 ↑ 1.0 46,855 1

Subquery Scan on lfa1 (cost=11,430.31..12,496.91 rows=47,404 width=50) (actual time=1,201.261..1,210.112 rows=46,855 loops=1)

71. 22.515 1,207.712 ↑ 1.0 46,855 1

HashAggregate (cost=11,430.31..12,022.87 rows=47,404 width=50) (actual time=1,201.260..1,207.712 rows=46,855 loops=1)

  • Group Key: lfa_1.mandt, lfa_1.lifnr, btrim((COALESCE(lfa_1.mcod1, ''::character varying))::text)
72. 1,185.197 1,185.197 ↑ 1.0 46,855 1

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

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 138843
73. 0.790 86.281 ↓ 303.0 4,545 1

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

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 405kB
74. 0.447 85.491 ↓ 303.0 4,545 1

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

  • Filter: (cskt.mandt = 300)
75. 0.721 85.044 ↓ 1.5 4,545 1

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

76. 28.725 84.323 ↓ 2.3 7,373 1

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

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

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

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

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

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 796kB
79. 0.802 67.803 ↓ 328.1 8,858 1

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

  • Filter: (cepct.mandt = 300)
80. 1.061 67.001 ↓ 1.6 8,858 1

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

81. 26.511 65.940 ↓ 1.6 8,907 1

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

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

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

  • Filter: (((spras)::text = 'S'::text) AND (mandt = 300))
  • Rows Removed by Filter: 5058
83. 0.987 91.105 ↓ 2.2 5,337 1

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

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

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

85. 2.245 89.815 ↓ 2.2 5,337 1

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

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

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

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

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

  • Index Cond: ((spras)::text = 'S'::text)
88. 306.192 1,005.188 ↓ 4.5 292,883 1

Sort (cost=15,215.95..15,377.87 rows=64,769 width=50) (actual time=987.573..1,005.188 rows=292,883 loops=1)

  • Sort Key: kna1.kunnr
  • Sort Method: quicksort Memory: 7908kB
89. 3.182 698.996 ↓ 1.0 65,091 1

Subquery Scan on kna1 (cost=8,582.63..10,039.93 rows=64,769 width=50) (actual time=685.350..698.996 rows=65,091 loops=1)

90. 33.649 695.814 ↓ 1.0 65,091 1

HashAggregate (cost=8,582.63..9,392.24 rows=64,769 width=50) (actual time=685.348..695.814 rows=65,091 loops=1)

  • Group Key: kna_1.mandt, kna_1.kunnr, btrim((COALESCE(kna_1.name1, ''::character varying))::text)
91. 662.165 662.165 ↑ 1.0 65,091 1

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

  • Filter: (mandt = 300)
  • Rows Removed by Filter: 34508
Planning time : 1,055.223 ms
Execution time : 812,144.578 ms