explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0LOs

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,220.205 ↓ 1.8 7 1

Nested Loop (cost=34,908.86..79,833.23 rows=4 width=266) (actual time=4,220.187..4,220.205 rows=7 loops=1)

  • Join Filter: (supplier.s_nationkey = nation_1.n_nationkey)
  • Rows Removed by Join Filter: 168
2.          

Initplan (forNested Loop)

3. 0.000 3,647.083 ↑ 1.0 1 1

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

4. 218.739 3,647.129 ↓ 1.5 3 1

Gather (cost=34,907.50..34,907.71 rows=2 width=32) (actual time=3,646.749..3,647.129 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 116.981 3,428.390 ↑ 1.0 1 3

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

6. 3,311.409 3,311.409 ↑ 1.2 500,000 3

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

7. 5.411 5.411 ↑ 6.8 25 1

Seq Scan on nation nation_1 (cost=0.00..11.70 rows=170 width=108) (actual time=5.409..5.411 rows=25 loops=1)

8. 0.065 4,214.725 ↓ 1.8 7 25

Materialize (cost=1.14..44,903.62 rows=4 width=166) (actual time=153.578..168.589 rows=7 loops=25)

9. 0.089 4,214.660 ↓ 1.8 7 1

Nested Loop (cost=1.14..44,903.60 rows=4 width=166) (actual time=3,839.417..4,214.660 rows=7 loops=1)

10. 0.023 4,143.332 ↓ 1.8 7 1

Nested Loop (cost=0.85..44,902.39 rows=4 width=140) (actual time=3,812.709..4,143.332 rows=7 loops=1)

11. 0.007 4,120.649 ↑ 1.0 1 1

Nested Loop (cost=0.42..44,867.26 rows=1 width=135) (actual time=3,798.573..4,120.649 rows=1 loops=1)

  • Join Filter: (customer.c_nationkey = nation.n_nationkey)
  • Rows Removed by Join Filter: 22
12. 0.006 4,120.624 ↑ 1.0 1 1

Nested Loop (cost=0.42..44,853.44 rows=1 width=35) (actual time=3,798.549..4,120.624 rows=1 loops=1)

13. 4,090.401 4,090.401 ↑ 1.0 1 1

Seq Scan on orders (cost=0.00..44,845.00 rows=1 width=16) (actual time=3,768.326..4,090.401 rows=1 loops=1)

  • Filter: (o_totalprice = $1)
  • Rows Removed by Filter: 1499999
14. 30.217 30.217 ↑ 1.0 1 1

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

  • Index Cond: (c_custkey = orders.o_custkey)
15. 0.018 0.018 ↑ 7.4 23 1

Seq Scan on nation (cost=0.00..11.70 rows=170 width=108) (actual time=0.018..0.018 rows=23 loops=1)

16. 22.660 22.660 ↑ 2.3 7 1

Index Scan using pklineitem on lineitem (cost=0.43..34.96 rows=16 width=13) (actual time=14.130..22.660 rows=7 loops=1)

  • Index Cond: (l_orderkey = orders.o_orderkey)
17. 71.239 71.239 ↑ 1.0 1 7

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

  • Index Cond: (s_suppkey = lineitem.l_suppkey)