explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 45RY

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

Sort (cost=55,406.46..55,406.47 rows=1 width=192) (actual rows= loops=)

  • Sort Key: supplier.s_acctbal DESC, nation.n_name, supplier.s_name, part.p_partkey
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..55,406.45 rows=1 width=192) (actual rows= loops=)

  • Join Filter: (nation.n_regionkey = region.r_regionkey)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..55,405.38 rows=1 width=200) (actual rows= loops=)

  • Join Filter: (supplier.s_nationkey = nation.n_nationkey)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..55,403.81 rows=1 width=174) (actual rows= loops=)

  • Join Filter: (partsupp.ps_suppkey = supplier.s_suppkey)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..54,948.81 rows=1 width=38) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on part (cost=0.00..7,097.00 rows=764 width=30) (actual rows= loops=)

  • Filter: (((p_type)::text ~~ '%BRASS'::text) AND (p_size = 15))
7. 0.000 0.000 ↓ 0.0

Index Scan using partsupp_pkey on partsupp (cost=0.42..62.62 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (ps_partkey = part.p_partkey)
  • Filter: ((SubPlan 1) = ps_supplycost)
8.          

SubPlan (forIndex Scan)

9. 0.000 0.000 ↓ 0.0

Aggregate (cost=14.76..14.77 rows=1 width=32) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..14.75 rows=1 width=6) (actual rows= loops=)

  • Join Filter: (nation_1.n_regionkey = region_1.r_regionkey)
11. 0.000 0.000 ↓ 0.0

Seq Scan on region region_1 (cost=0.00..1.06 rows=1 width=4) (actual rows= loops=)

  • Filter: (r_name = 'EUROPE'::bpchar)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..13.64 rows=4 width=14) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..13.02 rows=4 width=14) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using partsupp_pkey on partsupp partsupp_1 (cost=0.42..3.81 rows=4 width=14) (actual rows= loops=)

  • Index Cond: (part.p_partkey = ps_partkey)
15. 0.000 0.000 ↓ 0.0

Index Scan using supplier_pkey on supplier supplier_1 (cost=0.29..2.30 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (s_suppkey = partsupp_1.ps_suppkey)
16. 0.000 0.000 ↓ 0.0

Index Scan using nation_pkey on nation nation_1 (cost=0.14..0.16 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (n_nationkey = supplier_1.s_nationkey)
17. 0.000 0.000 ↓ 0.0

Seq Scan on supplier (cost=0.00..330.00 rows=10,000 width=148) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

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

19. 0.000 0.000 ↓ 0.0

Seq Scan on region (cost=0.00..1.06 rows=1 width=4) (actual rows= loops=)

  • Filter: (r_name = 'EUROPE'::bpchar)