explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uT3B

Settings
# exclusive inclusive rows x rows loops node
1. 1.193 30,286.938 ↓ 561.0 1,122 1

GroupAggregate (cost=23,156.19..23,156.29 rows=2 width=140) (actual time=30,285.721..30,286.938 rows=1,122 loops=1)

  • Group Key: s.plant, s.material, s.voptions, s.batchnum, s.qunit, s.qunitx, s.warehouse, s.stockplace, s.isvariant, s.variantkey
2. 16.193 30,285.745 ↓ 561.0 1,122 1

Sort (cost=23,156.19..23,156.20 rows=2 width=87) (actual time=30,285.710..30,285.745 rows=1,122 loops=1)

  • Sort Key: s.plant, s.material, s.voptions, s.batchnum, s.qunit, s.qunitx, s.warehouse, s.stockplace, s.isvariant, s.variantkey
  • Sort Method: quicksort Memory: 206kB
3. 3.160 30,269.552 ↓ 561.0 1,122 1

Nested Loop (cost=158.83..23,156.18 rows=2 width=87) (actual time=15.500..30,269.552 rows=1,122 loops=1)

4. 2.678 35.224 ↓ 160.3 1,122 1

Nested Loop (cost=158.40..187.27 rows=7 width=26) (actual time=4.035..35.224 rows=1,122 loops=1)

5. 1.269 5.618 ↓ 102.0 1,122 1

Unique (cost=157.98..158.03 rows=11 width=10) (actual time=4.004..5.618 rows=1,122 loops=1)

6. 3.710 4.349 ↓ 102.0 1,122 1

Sort (cost=157.98..158.01 rows=11 width=10) (actual time=4.003..4.349 rows=1,122 loops=1)

  • Sort Key: iaswmspoitembatch.batchnum
  • Sort Method: quicksort Memory: 101kB
7. 0.639 0.639 ↓ 102.0 1,122 1

Index Scan using iaswmspoitembatch_n1 on iaswmspoitembatch (cost=0.42..157.79 rows=11 width=10) (actual time=0.050..0.639 rows=1,122 loops=1)

  • Index Cond: (((client)::text = '00'::text) AND ((company)::text = '02'::text) AND ((ordernum)::text = '00000706'::text))
  • Filter: (isdeldone = 0)
8. 26.928 26.928 ↑ 1.0 1 1,122

Index Only Scan using iaswmspoitembatch_u on iaswmspoitembatch b (cost=0.42..2.65 rows=1 width=16) (actual time=0.024..0.024 rows=1 loops=1,122)

  • Index Cond: ((client = '00'::text) AND (company = '02'::text) AND (batchnum = (iaswmspoitembatch.batchnum)::text))
  • Heap Fetches: 1,122
9. 30,231.168 30,231.168 ↑ 1.0 1 1,122

Index Scan using iasinvstock_s8 on iasinvstock s (cost=0.42..3,281.26 rows=1 width=93) (actual time=11.135..26.944 rows=1 loops=1,122)

  • Index Cond: (((client)::text = '00'::text) AND ((company)::text = '02'::text) AND ((batchnum)::text = (b.batchnum)::text))
Planning time : 0.776 ms
Execution time : 30,287.111 ms