explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HOvR : tpch3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=205,525.37..205,525.60 rows=10 width=48) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Motion 16:1 (slice2; segments: 16) (cost=205,525.37..205,525.60 rows=10 width=48) (actual rows= loops=)

  • Merge Key: revenue, orders.o_orderdate
3. 0.000 0.000 ↓ 0.0

Limit (cost=205,525.37..205,525.40 rows=1 width=48) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=205,525.37..206,297.41 rows=19,301 width=48) (actual rows= loops=)

  • Sort Key (Limit): revenue, orders.o_orderdate
5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=171,962.65..177,366.93 rows=19,301 width=48) (actual rows= loops=)

  • Group By: lineitem.l_orderkey, orders.o_orderdate, orders.o_shippriority
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=50,071.89..168,874.48 rows=19,302 width=32) (actual rows= loops=)

  • Hash Cond: lineitem.l_orderkey = orders.o_orderkey
7. 0.000 0.000 ↓ 0.0

Seq Scan on lineitem (cost=0.00..106,613.89 rows=208,213 width=24) (actual rows= loops=)

  • Filter: l_shipdate > '1995-03-28'::date
8. 0.000 0.000 ↓ 0.0

Hash (cost=48,332.28..48,332.28 rows=8,699 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash Join (cost=13,807.21..48,332.28 rows=8,699 width=16) (actual rows= loops=)

  • Hash Cond: orders.o_custkey = customer.c_custkey
10. 0.000 0.000 ↓ 0.0

Seq Scan on orders (cost=0.00..25,790.25 rows=44,410 width=24) (actual rows= loops=)

  • Filter: o_orderdate < '1995-03-28'::date
11. 0.000 0.000 ↓ 0.0

Hash (cost=7,882.09..7,882.09 rows=29,626 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Broadcast Motion 16:16 (slice1; segments: 16) (cost=0.00..7,882.09 rows=29,626 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on customer (cost=0.00..2,845.74 rows=1,852 width=8) (actual rows= loops=)

  • Filter: c_mktsegment = 'HOUSEHOLD'::bpchar