explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g0bm

Settings
# exclusive inclusive rows x rows loops node
1. 147.696 131,288.107 ↑ 1.0 31,880 1

Sort (cost=47,157,094.02..47,157,174.80 rows=32,314 width=212) (actual time=131,286.253..131,288.107 rows=31,880 loops=1)

  • Sort Key: k.vbeln, k.erdat
  • Sort Method: quicksort Memory: 5,173kB
2. 53,968.174 131,140.411 ↑ 1.0 31,880 1

HashAggregate (cost=47,153,381.16..47,154,673.72 rows=32,314 width=212) (actual time=131,102.133..131,140.411 rows=31,880 loops=1)

  • Group Key: k.vbeln, k.erdat
3. 52,451.374 77,172.237 ↓ 2.1 261,890,278 1

Hash Left Join (cost=738,864.97..4,107,676.99 rows=124,770,157 width=79) (actual time=9,796.617..77,172.237 rows=261,890,278 loops=1)

  • Hash Cond: (acv.accountgroupid = c.id)
4. 7,663.777 24,663.890 ↑ 1.0 35,266,331 1

Hash Left Join (cost=733,200.95..2,625,445.59 rows=36,617,515 width=74) (actual time=9,739.590..24,663.890 rows=35,266,331 loops=1)

  • Hash Cond: ((cb.kstar)::text = (acv.fromcostelement)::text)
5. 7,218.013 16,985.359 ↓ 1.0 14,712,257 1

Hash Right Join (cost=733,077.43..1,762,805.38 rows=14,706,416 width=80) (actual time=9,724.810..16,985.359 rows=14,712,257 loops=1)

  • Hash Cond: ((p.objnr)::text = (cb.objnr)::text)
6. 48.519 83.771 ↑ 1.0 200,968 1

Hash Left Join (cost=1,622.06..7,872.06 rows=200,968 width=38) (actual time=13.929..83.771 rows=200,968 loops=1)

  • Hash Cond: ((p.vbeln)::text = (k.vbeln)::text)
7. 21.471 21.471 ↑ 1.0 200,968 1

Seq Scan on vbap_limited p (cost=0.00..3,486.68 rows=200,968 width=29) (actual time=0.012..21.471 rows=200,968 loops=1)

8. 6.127 13.781 ↑ 1.0 32,314 1

Hash (cost=1,218.14..1,218.14 rows=32,314 width=25) (actual time=13.781..13.781 rows=32,314 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,055kB
9. 7.654 7.654 ↑ 1.0 32,314 1

Seq Scan on sdasco_vbak_limited k (cost=0.00..1,218.14 rows=32,314 width=25) (actual time=0.008..7.654 rows=32,314 loops=1)

10. 5,409.154 9,683.575 ↓ 1.0 14,712,257 1

Hash (cost=360,922.16..360,922.16 rows=14,706,416 width=74) (actual time=9,683.575..9,683.575 rows=14,712,257 loops=1)

  • Buckets: 8,388,608 Batches: 4 Memory Usage: 474,536kB
11. 4,274.421 4,274.421 ↓ 1.0 14,712,257 1

Seq Scan on cosp_limited cb (cost=0.00..360,922.16 rows=14,706,416 width=74) (actual time=0.036..4,274.421 rows=14,712,257 loops=1)

12. 0.797 14.754 ↑ 1.0 3,709 1

Hash (cost=74.90..74.90 rows=3,890 width=15) (actual time=14.754..14.754 rows=3,709 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 206kB
13. 13.957 13.957 ↑ 1.0 3,709 1

Seq Scan on ficops_accountgroupvalues_t acv (cost=0.00..74.90 rows=3,890 width=15) (actual time=1.701..13.957 rows=3,709 loops=1)

14. 0.647 56.973 ↑ 1.1 3,510 1

Hash (cost=5,615.72..5,615.72 rows=3,864 width=15) (actual time=56.973..56.973 rows=3,510 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 192kB
15. 41.359 56.326 ↑ 1.1 3,510 1

Hash Left Join (cost=72.52..5,615.72 rows=3,864 width=15) (actual time=14.926..56.326 rows=3,510 loops=1)

  • 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,887
16. 3.168 3.168 ↑ 2.0 567 1

Seq Scan on ficops_accountgroup_sot c (cost=0.00..58.34 rows=1,134 width=88) (actual time=3.099..3.168 rows=567 loops=1)

17. 0.119 11.799 ↑ 2.0 567 1

Hash (cost=58.34..58.34 rows=1,134 width=20) (actual time=11.799..11.799 rows=567 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 46kB
18. 11.680 11.680 ↑ 2.0 567 1

Seq Scan on ficops_accountgroup_sot g (cost=0.00..58.34 rows=1,134 width=20) (actual time=0.003..11.680 rows=567 loops=1)

Planning time : 9.192 ms
Execution time : 131,328.675 ms