explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fdx

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 1,597.773 ↑ 7.4 5 1

Sort (cost=11,731.27..11,731.36 rows=37 width=112) (actual time=1,597.772..1,597.773 rows=5 loops=1)

  • Sort Key: (sum((lineitem.l_extendedprice * ('1'::double precision - lineitem.l_discount)))) DESC
  • Sort Method: quicksort Memory: 25kB
  • Planning Time: 9.506 ms
  • Execution Time: 1611.121 ms
2. 0.000 1,597.762 ↑ 7.4 5 1

Finalize GroupAggregate (cost=11,726.86..11,730.31 rows=37 width=112) (actual time=1,597.462..1,597.762 rows=5 loops=1)

  • Group Key: nation.n_name
3. 0.000 1,610.875 ↑ 2.2 10 1

Gather Merge (cost=11,726.86..11,729.83 rows=22 width=112) (actual time=1,597.360..1,610.875 rows=10 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 0.792 3,143.166 ↑ 4.4 5 2

Partial GroupAggregate (cost=10,726.85..10,727.34 rows=22 width=112) (actual time=1,571.218..1,571.583 rows=5 loops=2)

  • Group Key: nation.n_name
5. 4.114 3,142.374 ↓ 26.1 574 2

Sort (cost=10,726.85..10,726.90 rows=22 width=120) (actual time=1,571.107..1,571.187 rows=574 loops=2)

  • Sort Key: nation.n_name
  • Sort Method: quicksort Memory: 71kB
  • Worker 0: Sort Method: quicksort Memory: 68kB
6. 36.152 3,138.260 ↓ 26.1 574 2

Nested Loop (cost=25.78..10,726.36 rows=22 width=120) (actual time=4.135..1,569.130 rows=574 loops=2)

7. 176.913 2,857.436 ↓ 28.4 15,292 2

Nested Loop (cost=25.36..9,550.83 rows=539 width=132) (actual time=1.371..1,428.718 rows=15,292 loops=2)

8. 145.453 1,279.676 ↓ 28.9 100,060 2

Nested Loop (cost=24.92..3,654.22 rows=3,460 width=132) (actual time=1.042..639.838 rows=100,060 loops=2)

9. 65.182 112.336 ↓ 29.0 10,018 2

Hash Join (cost=24.50..3,090.78 rows=346 width=116) (actual time=0.995..56.168 rows=10,018 loops=2)

  • Hash Cond: (supplier.s_nationkey = nation.n_nationkey)
10. 45.812 45.812 ↑ 1.2 50,000 2

Parallel Seq Scan on supplier (cost=0.00..2,842.24 rows=58,824 width=8) (actual time=0.017..22.906 rows=50,000 loops=2)

11. 0.014 1.342 ↓ 5.0 5 2

Hash (cost=24.48..24.48 rows=1 width=108) (actual time=0.671..0.671 rows=5 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.060 1.328 ↓ 5.0 5 2

Hash Join (cost=12.14..24.48 rows=1 width=108) (actual time=0.651..0.664 rows=5 loops=2)

  • Hash Cond: (nation.n_regionkey = region.r_regionkey)
13. 0.308 0.308 ↑ 6.8 25 2

Seq Scan on nation (cost=0.00..11.70 rows=170 width=112) (actual time=0.149..0.154 rows=25 loops=2)

14. 0.054 0.960 ↑ 1.0 1 2

Hash (cost=12.12..12.12 rows=1 width=4) (actual time=0.479..0.480 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.906 0.906 ↑ 1.0 1 2

Seq Scan on region (cost=0.00..12.12 rows=1 width=4) (actual time=0.451..0.453 rows=1 loops=2)

  • Filter: (r_name = 'ASIA'::bpchar)
  • Rows Removed by Filter: 4
16. 1,021.887 1,021.887 ↑ 1.1 10 20,037

Index Scan using test8 on lineitem (cost=0.42..1.52 rows=11 width=24) (actual time=0.010..0.051 rows=10 loops=20,037)

  • Index Cond: (l_suppkey = supplier.s_suppkey)
17. 1,400.847 1,400.847 ↓ 0.0 0 200,121

Index Scan using orders_o_orderkey_idx on orders (cost=0.43..1.69 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=200,121)

  • Index Cond: (o_orderkey = lineitem.l_orderkey)
  • Filter: ((o_orderdate >= '1994-01-01'::date) AND (o_orderdate < '1995-01-01 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 1
18. 244.672 244.672 ↓ 0.0 0 30,584

Index Only Scan using customer_c_nationkey_c_custkey_idx on customer (cost=0.43..2.17 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=30,584)

  • Index Cond: ((c_nationkey = supplier.s_nationkey) AND (c_custkey = orders.o_custkey))
  • Heap Fetches: 1148