explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9MwS

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

Nested Loop (cost=34,908.86..79,801.82 rows=4 width=266) (actual rows= loops=)

  • Join Filter: (supplier.s_nationkey = nation_1.n_nationkey)
2.          

Initplan (forNested Loop)

3. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=34,907.71..34,907.72 rows=1 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Gather (cost=34,907.50..34,907.71 rows=2 width=32) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=33,907.50..33,907.51 rows=1 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on orders orders_1 (cost=0.00..32,345.00 rows=625,000 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on nation nation_1 (cost=0.00..1.25 rows=25 width=108) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Materialize (cost=1.14..44,891.35 rows=4 width=166) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.14..44,891.33 rows=4 width=166) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..44,890.12 rows=4 width=140) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..44,855.00 rows=1 width=135) (actual rows= loops=)

  • Join Filter: (customer.c_nationkey = nation.n_nationkey)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..44,853.44 rows=1 width=35) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on orders (cost=0.00..44,845.00 rows=1 width=16) (actual rows= loops=)

  • Filter: (o_totalprice = $1)
14. 0.000 0.000 ↓ 0.0

Index Scan using pkcustomer on customer (cost=0.42..8.44 rows=1 width=27) (actual rows= loops=)

  • Index Cond: (c_custkey = orders.o_custkey)
15. 0.000 0.000 ↓ 0.0

Seq Scan on nation (cost=0.00..1.25 rows=25 width=108) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Index Scan using pklineitem on lineitem (cost=0.43..34.96 rows=16 width=13) (actual rows= loops=)

  • Index Cond: (l_orderkey = orders.o_orderkey)
17. 0.000 0.000 ↓ 0.0

Index Scan using pksupplier on supplier (cost=0.29..0.30 rows=1 width=34) (actual rows= loops=)

  • Index Cond: (s_suppkey = lineitem.l_suppkey)