explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hQ7R

Settings
# exclusive inclusive rows x rows loops node
1. 56,157.058 134,837.415 ↑ 1.0 31,880 1

HashAggregate (cost=47,153,381.16..47,154,673.72 rows=32,314 width=212) (actual time=134,800.512..134,837.415 rows=31,880 loops=1)

  • Group Key: k.vbeln, k.erdat
2. 54,791.254 78,680.357 ↓ 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=8,973.835..78,680.357 rows=261,890,278 loops=1)

  • Hash Cond: (acv.accountgroupid = c.id)
3. 7,743.195 23,849.710 ↑ 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=8,934.413..23,849.710 rows=35,266,331 loops=1)

  • Hash Cond: ((cb.kstar)::text = (acv.fromcostelement)::text)
4. 7,134.463 16,105.595 ↓ 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=8,933.464..16,105.595 rows=14,712,257 loops=1)

  • Hash Cond: ((p.objnr)::text = (cb.objnr)::text)
5. 47.433 79.365 ↑ 1.0 200,968 1

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

  • Hash Cond: ((p.vbeln)::text = (k.vbeln)::text)
6. 18.128 18.128 ↑ 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.008..18.128 rows=200,968 loops=1)

7. 6.101 13.804 ↑ 1.0 32,314 1

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

  • Buckets: 32,768 Batches: 1 Memory Usage: 2,055kB
8. 7.703 7.703 ↑ 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.007..7.703 rows=32,314 loops=1)

9. 5,459.165 8,891.767 ↓ 1.0 14,712,257 1

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

  • Buckets: 8,388,608 Batches: 4 Memory Usage: 474,536kB
10. 3,432.602 3,432.602 ↓ 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.018..3,432.602 rows=14,712,257 loops=1)

11. 0.544 0.920 ↑ 1.0 3,709 1

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

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

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

13. 0.608 39.393 ↑ 1.1 3,510 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 192kB
14. 38.521 38.785 ↑ 1.1 3,510 1

Hash Left Join (cost=72.52..5,615.72 rows=3,864 width=15) (actual time=0.225..38.785 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
15. 0.058 0.058 ↑ 2.0 567 1

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

16. 0.088 0.206 ↑ 2.0 567 1

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

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

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

Planning time : 1.064 ms
Execution time : 134,876.467 ms