explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WxjL

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

Limit (cost=517,505,241.62..517,505,241.67 rows=20 width=175) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=517,505,241.62..517,505,528.24 rows=114,647 width=175) (never executed)

  • Sort Key: (sum((lineitem.l_extendedprice * ('1'::numeric - lineitem.l_discount)))) DESC
3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=517,497,891.64..517,502,190.91 rows=114,647 width=175) (never executed)

  • Group Key: customer.c_custkey, customer.c_name, customer.c_acctbal, customer.c_phone, customer.c_address, customer.c_comment
4. 0.000 0.000 ↓ 0.0

Sort (cost=517,497,891.64..517,498,178.26 rows=114,647 width=155) (never executed)

  • Sort Key: customer.c_custkey, customer.c_name, customer.c_acctbal, customer.c_phone, customer.c_address, customer.c_comment
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,000.43..517,479,241.38 rows=114,647 width=155) (never executed)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,000..516,851,375.59 rows=114,835 width=147) (never executed)

7. 0.000 0.000 ↓ 0.0

Seq Scan on customer customer (cost=0..10,169 rows=300,000 width=143) (never executed)

8. 0.000 0.000 ↓ 0.0

Materialize (cost=1,000..83,993.68 rows=114,835 width=8) (never executed)

9. 0.000 0.000 ↓ 0.0

Gather (cost=1,000..83,419.5 rows=114,835 width=8) (never executed)

  • Workers Planned: 2
10. 0.000 0.000 ↓ 0.0

Seq Scan on orders orders (cost=0..70,936 rows=47,848 width=8) (never executed)

  • Filter: ((o_orderdate >= '1993-02-01'::date) AND (o_orderdate < '1993-05-01'::date))
11. 0.000 0.000 ↓ 0.0

Index Scan using lineitem_key on lineitem lineitem (cost=0.43..5.39 rows=8 width=16) (never executed)

  • Index Cond: (l_orderkey = orders.o_orderkey)
  • Filter: (l_returnflag = 'R'::bpchar)