explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GSML

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

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

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

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

3. 2,011.913 2,713.159 ↓ 1.0 800,000 1

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

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

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

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

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

6. 7.062 16.131 ↑ 1.0 10,000 1

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

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

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

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

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

9. 0.008 0.052 ↑ 6.8 25 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
10. 0.021 0.044 ↑ 6.8 25 1

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

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

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

12. 0.011 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.009 0.009 ↑ 6.8 25 1

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