explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ehXT

Settings
# exclusive inclusive rows x rows loops node
1. 2,235.911 997,391.458 ↑ 1.0 28,922 1

HashAggregate (cost=137,837,110,635.77..137,837,112,877.23 rows=28,922 width=170) (actual time=997,339.382..997,391.458 rows=28,922 loops=1)

  • Group Key: k.vbeln
2. 41,113.521 995,155.547 ↑ 28,144.9 7,019,783 1

Merge Right Join (cost=26,535,943.12..2,994,701,534.15 rows=197,571,295,387 width=116) (actual time=809,190.076..995,155.547 rows=7,019,783 loops=1)

  • Merge Cond: ((cb.objnr)::text = (p.objnr)::text)
3. 831,382.584 920,782.148 ↓ 2.0 260,830,043 1

Sort (cost=22,836,970.61..23,158,988.66 rows=128,807,220 width=72) (actual time=777,971.230..920,782.148 rows=260,830,043 loops=1)

  • Sort Key: cb.objnr
  • Sort Method: external merge Disk: 23,179,632kB
4. 77,698.766 89,399.564 ↓ 2.0 260,830,043 1

Gather (cost=6,751.12..2,391,834.04 rows=128,807,220 width=72) (actual time=44.348..89,399.564 rows=260,830,043 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
5. 7,362.641 11,700.798 ↓ 1.8 32,603,755 8 / 8

Hash Left Join (cost=5,751.12..2,390,834.04 rows=18,401,031 width=72) (actual time=43.979..11,700.798 rows=32,603,755 loops=8)

  • Hash Cond: (acv.accountgroupid = c.id)
6. 1,061.498 4,295.467 ↑ 1.2 4,390,997 8 / 8

Hash Left Join (cost=123.53..2,167,401.79 rows=5,409,871 width=67) (actual time=1.248..4,295.467 rows=4,390,997 loops=8)

  • Hash Cond: ((cb.kstar)::text = (acv.fromcostelement)::text)
7. 3,232.961 3,232.961 ↑ 1.1 1,832,182 8 / 8

Parallel Seq Scan on cosp cb (cost=0.00..2,042,396.39 rows=2,097,279 width=73) (actual time=0.132..3,232.961 rows=1,832,182 loops=8)

  • Filter: (((mandt)::text = '400'::text) AND (hvr_is_deleted = 0) AND ((wrttp)::text = '01'::text))
  • Rows Removed by Filter: 1,780,560
8. 0.579 1.008 ↑ 1.1 3,693 8 / 8

Hash (cost=74.90..74.90 rows=3,890 width=15) (actual time=1.008..1.008 rows=3,693 loops=8)

  • Buckets: 4,096 Batches: 1 Memory Usage: 206kB
9. 0.429 0.429 ↑ 1.1 3,693 8 / 8

Seq Scan on ficops_accountgroupvalues_t acv (cost=0.00..74.90 rows=3,890 width=15) (actual time=0.032..0.429 rows=3,693 loops=8)

10. 0.653 42.690 ↑ 1.1 3,508 8 / 8

Hash (cost=5,579.47..5,579.47 rows=3,850 width=15) (actual time=42.690..42.690 rows=3,508 loops=8)

  • Buckets: 4,096 Batches: 1 Memory Usage: 192kB
11. 41.759 42.037 ↑ 1.1 3,508 8 / 8

Hash Left Join (cost=63.47..5,579.47 rows=3,850 width=15) (actual time=0.407..42.037 rows=3,508 loops=8)

  • Hash Cond: ((c.fin_stat_vers)::text = (g.fin_stat_vers)::text)
  • Join Filter: (c.path && ARRAY[g.id])
  • Rows Removed by Join Filter: 92,760
12. 0.085 0.085 ↑ 2.0 566 8 / 8

Seq Scan on ficops_accountgroup_sot c (cost=0.00..49.32 rows=1,132 width=88) (actual time=0.026..0.085 rows=566 loops=8)

13. 0.097 0.193 ↑ 2.0 566 8 / 8

Hash (cost=49.32..49.32 rows=1,132 width=20) (actual time=0.193..0.193 rows=566 loops=8)

  • Buckets: 2,048 Batches: 1 Memory Usage: 45kB
14. 0.096 0.096 ↑ 2.0 566 8 / 8

Seq Scan on ficops_accountgroup_sot g (cost=0.00..49.32 rows=1,132 width=20) (actual time=0.005..0.096 rows=566 loops=8)

15. 352.684 33,259.878 ↑ 37.3 7,019,783 1

Materialize (cost=3,698,972.51..8,306,195.61 rows=262,042,706 width=68) (actual time=31,218.841..33,259.878 rows=7,019,783 loops=1)

16. 842.263 32,907.194 ↑ 1,800.2 145,561 1

Merge Left Join (cost=3,698,972.51..7,651,088.85 rows=262,042,706 width=68) (actual time=31,218.833..32,907.194 rows=145,561 loops=1)

  • Merge Cond: ((p.objnr)::text = (cs.objnr)::text)
17. 996.796 1,635.465 ↑ 29.5 145,532 1

Sort (cost=1,593,622.76..1,604,361.70 rows=4,295,575 width=20) (actual time=1,622.487..1,635.465 rows=145,532 loops=1)

  • Sort Key: p.objnr
  • Sort Method: quicksort Memory: 17,411kB
18. 28.194 638.669 ↑ 29.5 145,532 1

Nested Loop Left Join (cost=0.56..1,120,370.25 rows=4,295,575 width=20) (actual time=0.047..638.669 rows=145,532 loops=1)

19. 3.113 3.113 ↑ 1.0 28,922 1

Seq Scan on ctrnll_vbak_limited k (cost=0.00..905.22 rows=28,922 width=10) (actual time=0.009..3.113 rows=28,922 loops=1)

20. 607.362 607.362 ↑ 29.8 5 28,922

Index Scan using vbap_pkey on vbap p (cost=0.56..37.22 rows=149 width=20) (actual time=0.012..0.021 rows=5 loops=28,922)

  • Index Cond: (((mandt)::text = '400'::text) AND ((vbeln)::text = (k.vbeln)::text))
  • Filter: (hvr_is_deleted = 0)
  • Rows Removed by Filter: 0
21. 27,867.690 30,429.466 ↓ 1.0 4,799,848 1

Sort (cost=2,105,349.75..2,117,262.14 rows=4,764,958 width=62) (actual time=29,596.337..30,429.466 rows=4,799,848 loops=1)

  • Sort Key: cs.objnr
  • Sort Method: external sort Disk: 384,728kB
22. 353.730 2,561.776 ↓ 1.0 4,799,848 1

Gather (cost=1,000.00..1,576,819.84 rows=4,764,958 width=62) (actual time=0.624..2,561.776 rows=4,799,848 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
23. 2,208.046 2,208.046 ↑ 1.1 599,981 8 / 8

Parallel Seq Scan on coss cs (cost=0.00..1,575,819.84 rows=680,708 width=62) (actual time=0.011..2,208.046 rows=599,981 loops=8)

  • Filter: (((mandt)::text = '400'::text) AND (hvr_is_deleted = 0) AND ((wrttp)::text = '01'::text))
  • Rows Removed by Filter: 1,839,141
Planning time : 52.413 ms
Execution time : 999,985.562 ms