explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cspV

Settings
# exclusive inclusive rows x rows loops node
1. 968.870 24,000.223 ↑ 107.1 32,314 1

Hash Left Join (cost=8,925,480.57..9,309,531.28 rows=3,462,242 width=164) (actual time=20,088.186..24,000.223 rows=32,314 loops=1)

  • Hash Cond: (((jclosed.stat)::text = (jsclosed.stat)::text) AND ((vk.objnr)::text = (jsclosed.objnr)::text) AND ((jclosed.chgnr)::text = (jsclosed.chgnr)::text))
  • Filter: ((jsclosed.udate IS NULL) OR ((jsclosed.udate)::text > ("left"(to_char((CURRENT_DATE - '1 year'::interval), 'YYYYMMdd'::text), 4) || '1231'::text)))
  • Rows Removed by Filter: 108,941
2. 1,483.601 18,203.640 ↑ 24.5 141,255 1

Hash Left Join (cost=6,868,575.22..7,225,360.77 rows=3,462,242 width=142) (actual time=15,257.906..18,203.640 rows=141,255 loops=1)

  • Hash Cond: ((vk.objnr)::text = (jclosed.objnr)::text)
3. 1,041.825 10,298.755 ↑ 2.5 141,255 1

Hash Left Join (cost=4,608,366.70..4,888,317.86 rows=352,911 width=132) (actual time=8,807.941..10,298.755 rows=141,255 loops=1)

  • Hash Cond: (((jcreated.stat)::text = (jscreated.stat)::text) AND ((vk.objnr)::text = (jscreated.objnr)::text) AND ((jcreated.chgnr)::text = (jscreated.chgnr)::text))
  • Filter: ((jscreated.udate IS NULL) OR ((jscreated.udate)::text < to_char(now(), 'YYYYMMdd'::text)))
4. 418.605 3,412.114 ↑ 2.5 141,255 1

Hash Left Join (cost=2,397,104.56..2,610,328.54 rows=352,911 width=142) (actual time=2,936.056..3,412.114 rows=141,255 loops=1)

  • Hash Cond: ((vk.objnr)::text = (jcreated.objnr)::text)
5. 0.000 87.021 ↓ 7.0 141,255 1

Gather (cost=1,404.47..103,758.15 rows=20,311 width=132) (actual time=2.412..87.021 rows=141,255 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
6. 7.752 176.989 ↓ 5.8 23,542 6 / 6

Hash Join (cost=404.48..102,758.15 rows=4,062 width=132) (actual time=1.548..176.989 rows=23,542 loops=6)

  • Hash Cond: ((vk.zz_prctr)::text = (prct.profit_center)::text)
7. 167.806 167.806 ↑ 1.2 28,891 6 / 6

Parallel Seq Scan on vbak vk (cost=0.00..102,185.89 rows=33,910 width=132) (actual time=0.019..167.806 rows=28,891 loops=6)

  • Filter: (((mandt)::text = '400'::text) AND (hvr_is_deleted = 0) AND ((auart)::text = ANY ('{ZFCA,ZFXA,YSBA,ZSCA,YSCA,ZSXA,ZKEA,ZSBA,YVCA}'::text[])))
  • Rows Removed by Filter: 102,202
8. 0.154 1.431 ↑ 1.0 1,168 6 / 6

Hash (cost=389.88..389.88 rows=1,168 width=7) (actual time=1.431..1.431 rows=1,168 loops=6)

  • Buckets: 2,048 Batches: 1 Memory Usage: 61kB
9. 1.277 1.277 ↑ 1.0 1,168 6 / 6

Seq Scan on cntrll_drm_profit_center_sot prct (cost=0.00..389.88 rows=1,168 width=7) (actual time=0.065..1.277 rows=1,168 loops=6)

  • Filter: (tier1_code = 'PXATCO'::text)
  • Rows Removed by Filter: 8,582
10. 276.052 2,906.488 ↑ 13.6 1,181,795 1

Hash (cost=2,084,493.21..2,084,493.21 rows=16,094,710 width=27) (actual time=2,906.487..2,906.488 rows=1,181,795 loops=1)

  • Buckets: 8,388,608 Batches: 4 Memory Usage: 83,478kB
11. 0.000 2,630.436 ↑ 13.6 1,181,795 1

Gather (cost=1,000.00..2,084,493.21 rows=16,094,710 width=27) (actual time=0.544..2,630.436 rows=1,181,795 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
12. 2,706.948 2,706.948 ↑ 15.6 147,724 8 / 8

Parallel Seq Scan on jest jcreated (cost=0.00..2,083,493.21 rows=2,299,244 width=27) (actual time=0.955..2,706.948 rows=147,724 loops=8)

  • Filter: (((inact)::text <> 'X'::text) AND ((mandt)::text = '400'::text) AND (hvr_is_deleted = 0) AND ((stat)::text = 'I0001'::text))
  • Rows Removed by Filter: 19,870,148
13. 3,533.685 5,844.816 ↓ 1.4 8,943,441 1

Hash (cost=2,050,972.94..2,050,972.94 rows=6,332,412 width=33) (actual time=5,844.816..5,844.816 rows=8,943,441 loops=1)

  • Buckets: 8,388,608 (originally 8388608) Batches: 2 (originally 1) Memory Usage: 446,465kB
14. 0.000 2,311.131 ↓ 1.4 8,943,441 1

Gather (cost=1,000.00..2,050,972.94 rows=6,332,412 width=33) (actual time=0.491..2,311.131 rows=8,943,441 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
15. 2,647.927 2,647.927 ↓ 1.2 1,117,930 8 / 8

Parallel Seq Scan on jcds jscreated (cost=0.00..2,049,972.94 rows=904,630 width=33) (actual time=0.008..2,647.927 rows=1,117,930 loops=8)

  • Filter: (((mandt)::text = '400'::text) AND (hvr_is_deleted = 0) AND ((stat)::text = 'I0001'::text))
  • Rows Removed by Filter: 14,121,309
16. 3,244.691 6,421.284 ↓ 1.5 13,557,705 1

Hash (cost=2,084,493.21..2,084,493.21 rows=9,087,465 width=27) (actual time=6,421.284..6,421.284 rows=13,557,705 loops=1)

  • Buckets: 8,388,608 Batches: 2 Memory Usage: 457,169kB
17. 254.283 3,176.593 ↓ 1.5 13,557,705 1

Gather (cost=1,000.00..2,084,493.21 rows=9,087,465 width=27) (actual time=1.247..3,176.593 rows=13,557,705 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
18. 2,922.310 2,922.310 ↓ 1.3 1,694,713 8 / 8

Parallel Seq Scan on jest jclosed (cost=0.00..2,083,493.21 rows=1,298,209 width=27) (actual time=0.145..2,922.310 rows=1,694,713 loops=8)

  • Filter: (((inact)::text <> 'X'::text) AND ((mandt)::text = '400'::text) AND (hvr_is_deleted = 0) AND ((stat)::text = 'I0046'::text))
  • Rows Removed by Filter: 18,323,160
19. 2,772.795 4,827.713 ↓ 22.1 7,487,077 1

Hash (cost=2,050,972.94..2,050,972.94 rows=338,995 width=33) (actual time=4,827.713..4,827.713 rows=7,487,077 loops=1)

  • Buckets: 8,388,608 (originally 524288) Batches: 2 (originally 1) Memory Usage: 446,465kB
20. 0.000 2,054.918 ↓ 22.1 7,487,077 1

Gather (cost=1,000.00..2,050,972.94 rows=338,995 width=33) (actual time=0.514..2,054.918 rows=7,487,077 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
21. 2,509.142 2,509.142 ↓ 19.3 935,885 8 / 8

Parallel Seq Scan on jcds jsclosed (cost=0.00..2,049,972.94 rows=48,428 width=33) (actual time=1.150..2,509.142 rows=935,885 loops=8)

  • Filter: (((mandt)::text = '400'::text) AND (hvr_is_deleted = 0) AND ((stat)::text = 'I0046'::text))
  • Rows Removed by Filter: 14,303,355
Planning time : 1.756 ms
Execution time : 24,091.747 ms