explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aUzf

Settings
# exclusive inclusive rows x rows loops node
1. 0.162 32,145.197 ↑ 1.0 25 1

Finalize GroupAggregate (cost=154,691.77..154,692.39 rows=25 width=19) (actual time=32,145.028..32,145.197 rows=25 loops=1)

  • Group Key: part.p_brand
2. 0.000 32,145.035 ↓ 1.5 75 1

Sort (cost=154,691.77..154,691.89 rows=50 width=19) (actual time=32,145.013..32,145.035 rows=75 loops=1)

  • Sort Key: part.p_brand
  • Sort Method: quicksort Memory: 30kB
3. 524.934 32,176.577 ↓ 1.5 75 1

Gather (cost=154,685.11..154,690.36 rows=50 width=19) (actual time=32,091.914..32,176.577 rows=75 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 248.350 31,651.643 ↑ 1.0 25 3

Partial HashAggregate (cost=153,685.11..153,685.36 rows=25 width=19) (actual time=31,651.629..31,651.643 rows=25 loops=3)

  • Group Key: part.p_brand
5. 1,322.826 31,403.293 ↑ 1.3 349,525 3

Hash Join (cost=98,678.96..151,500.57 rows=436,907 width=11) (actual time=16,244.580..31,403.293 rows=349,525 loops=3)

  • Hash Cond: (partsupp.ps_partkey = part.p_partkey)
6. 2,124.719 28,995.099 ↑ 1.3 349,525 3

Hash Join (cost=89,104.96..135,534.67 rows=436,907 width=16) (actual time=15,157.430..28,995.099 rows=349,525 loops=3)

  • Hash Cond: ((lineitem.l_partkey = partsupp.ps_partkey) AND (lineitem.l_suppkey = partsupp.ps_suppkey))
7. 1,792.177 19,446.953 ↑ 1.3 349,525 3

Hash Join (cost=46,960.96..82,921.91 rows=436,907 width=16) (actual time=7,066.107..19,446.953 rows=349,525 loops=3)

  • Hash Cond: (lineitem.l_orderkey = orders.o_orderkey)
8. 10,932.668 10,932.668 ↑ 1.3 349,525 3

Parallel Seq Scan on lineitem (cost=0.00..25,596.07 rows=436,907 width=24) (actual time=0.312..10,932.668 rows=349,525 loops=3)

9. 1,089.540 6,722.108 ↑ 1.0 1,048,576 3

Hash (cost=29,757.76..29,757.76 rows=1,048,576 width=4) (actual time=6,722.108..6,722.108 rows=1,048,576 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 3335kB
10. 5,632.568 5,632.568 ↑ 1.0 1,048,576 3

Seq Scan on orders (cost=0.00..29,757.76 rows=1,048,576 width=4) (actual time=0.289..5,632.568 rows=1,048,576 loops=3)

11. 919.337 7,423.427 ↑ 1.0 800,000 3

Hash (cost=26,237.00..26,237.00 rows=800,000 width=16) (actual time=7,423.427..7,423.427 rows=800,000 loops=3)

  • Buckets: 131072 Batches: 16 Memory Usage: 3373kB
12. 6,504.090 6,504.090 ↑ 1.0 800,000 3

Seq Scan on partsupp (cost=0.00..26,237.00 rows=800,000 width=16) (actual time=9.993..6,504.090 rows=800,000 loops=3)

13. 184.351 1,085.368 ↑ 1.0 200,000 3

Hash (cost=6,097.00..6,097.00 rows=200,000 width=15) (actual time=1,085.368..1,085.368 rows=200,000 loops=3)

  • Buckets: 131072 Batches: 4 Memory Usage: 3373kB
14. 901.017 901.017 ↑ 1.0 200,000 3

Seq Scan on part (cost=0.00..6,097.00 rows=200,000 width=15) (actual time=0.355..901.017 rows=200,000 loops=3)