explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o6UG

Settings
# exclusive inclusive rows x rows loops node
1. 105.306 687.114 ↓ 0.0 0 1

HashAggregate (cost=2,127.35..2,127.55 rows=5 width=12) (actual time=687.113..687.114 rows=0 loops=1)

  • Group Key: products.category
  • Filter: (sum(orderlines.quantity) < 100)
  • Rows Removed by Filter: 16
2. 212.652 581.808 ↑ 1.0 60,350 1

Hash Join (cost=327.36..1,674.73 rows=60,350 width=6) (actual time=39.577..581.808 rows=60,350 loops=1)

  • Hash Cond: (products.category = categories.category)
3. 238.969 369.089 ↑ 1.0 60,350 1

Hash Join (cost=326.00..1,472.99 rows=60,350 width=6) (actual time=39.499..369.089 rows=60,350 loops=1)

  • Hash Cond: (orderlines.prod_id = products.prod_id)
4. 90.659 90.659 ↑ 1.0 60,350 1

Seq Scan on orderlines (cost=0.00..988.50 rows=60,350 width=6) (actual time=0.006..90.659 rows=60,350 loops=1)

5. 18.595 39.461 ↑ 1.0 10,000 1

Hash (cost=201.00..201.00 rows=10,000 width=8) (actual time=39.459..39.461 rows=10,000 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 519kB
6. 20.866 20.866 ↑ 1.0 10,000 1

Seq Scan on products (cost=0.00..201.00 rows=10,000 width=8) (actual time=0.007..20.866 rows=10,000 loops=1)

7. 0.032 0.067 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=4) (actual time=0.066..0.067 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.035 0.035 ↑ 1.0 16 1

Seq Scan on categories (cost=0.00..1.16 rows=16 width=4) (actual time=0.009..0.035 rows=16 loops=1)

Planning time : 0.252 ms
Execution time : 687.195 ms