explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EzH

Settings
# exclusive inclusive rows x rows loops node
1. 44.183 2,861.702 ↑ 79.9 10,000 1

Sort (cost=573,943.44..575,941.44 rows=799,201 width=140) (actual time=2,859.211..2,861.702 rows=10,000 loops=1)

  • Sort Key: r.r_name, (max(ps.ps_supplycost))
  • Sort Method: external merge Disk: 760kB
2. 231.398 2,817.519 ↑ 79.9 10,000 1

GroupAggregate (cost=305,511.96..323,493.98 rows=799,201 width=140) (actual time=2,145.940..2,817.519 rows=10,000 loops=1)

3. 1,921.525 2,586.121 ↓ 1.0 800,000 1

Sort (cost=305,511.96..307,509.96 rows=799,201 width=140) (actual time=2,145.882..2,586.121 rows=800,000 loops=1)

  • Sort Key: s.s_suppkey, s.s_name, r.r_name
  • Sort Method: external merge Disk: 57088kB
4. 453.167 664.596 ↓ 1.0 800,000 1

Hash Join (cost=818.49..55,062.50 rows=799,201 width=140) (actual time=15.611..664.596 rows=800,000 loops=1)

  • Hash Cond: (ps.ps_suppkey = s.s_suppkey)
5. 196.005 196.005 ↑ 1.0 800,000 1

Seq Scan on partsupp ps (cost=0.00..26,242.00 rows=800,000 width=14) (actual time=0.023..196.005 rows=800,000 loops=1)

6. 6.979 15.424 ↑ 1.0 10,000 1

Hash (cost=497.49..497.49 rows=10,000 width=134) (actual time=15.424..15.424 rows=10,000 loops=1)

  • Buckets: 1024 Batches: 2 Memory Usage: 438kB
7. 6.274 8.445 ↑ 1.0 10,000 1

Hash Join (cost=29.99..497.49 rows=10,000 width=134) (actual time=0.064..8.445 rows=10,000 loops=1)

  • Hash Cond: (s.s_nationkey = n.n_nationkey)
8. 2.117 2.117 ↑ 1.0 10,000 1

Seq Scan on supplier s (cost=0.00..330.00 rows=10,000 width=38) (actual time=0.003..2.117 rows=10,000 loops=1)

9. 0.009 0.054 ↑ 6.8 25 1

Hash (cost=27.86..27.86 rows=170 width=108) (actual time=0.054..0.054 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
10. 0.023 0.045 ↑ 6.8 25 1

Hash Join (cost=13.82..27.86 rows=170 width=108) (actual time=0.032..0.045 rows=25 loops=1)

  • Hash Cond: (r.r_regionkey = n.n_regionkey)
11. 0.002 0.002 ↑ 34.0 5 1

Seq Scan on region r (cost=0.00..11.70 rows=170 width=108) (actual time=0.001..0.002 rows=5 loops=1)

12. 0.010 0.020 ↑ 6.8 25 1

Hash (cost=11.70..11.70 rows=170 width=12) (actual time=0.020..0.020 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
13. 0.010 0.010 ↑ 6.8 25 1

Seq Scan on nation n (cost=0.00..11.70 rows=170 width=12) (actual time=0.002..0.010 rows=25 loops=1)